Home » Developer & Programmer » Reports & Discoverer » WITH Clause with Report Builder (Reports Developer, 10g, Windows)
WITH Clause with Report Builder [message #414399] Tue, 21 July 2009 23:58 Go to next message
ommin
Messages: 22
Registered: June 2006
Location: pune,India
Junior Member

Hi,

I'm developing one report, the query for that report is a WITH clause query,

When i try to built that report using the query it's giving error.

WITH clause query doesn't supported by reports developer?


Please help



Onkar
Re: WITH Clause with Report Builder [message #414416 is a reply to message #414399] Wed, 22 July 2009 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It works fine for me (Report Builder 9.0.4.0.33), at least such a simple example:
with test as
(select 'abc' col from dual)
select * From test;


/forum/fa/6567/0/
Re: WITH Clause with Report Builder [message #414989 is a reply to message #414399] Fri, 24 July 2009 05:47 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
it works absolutely fine in reports.

I guess its something wrong in your query. check that.
Re: WITH Clause with Report Builder [message #415043 is a reply to message #414399] Fri, 24 July 2009 08:28 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
what version of reports are you using?
Previous Topic: oracle report 6i
Next Topic: report header
Goto Forum:
  


Current Time: Thu Mar 28 12:02:27 CDT 2024