OraFAQ Forum: Reports & Discoverer » WITH Clause with Report Builder

Home » Developer & Programmer » Reports & Discoverer » WITH Clause with Report Builder (Reports Developer, 10g, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WITH Clause with Report Builder [message #414399]

Tue, 21 July 2009 23:58

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

Report message to a moderator

Re: WITH Clause with Report Builder [message #414416 is a reply to message #414399]

Wed, 22 July 2009 01:34

Littlefoot
Messages: 21823
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;

Attachment: with_report.PNG
(Size: 2.80KB, Downloaded 1897 times)

Report message to a moderator

Re: WITH Clause with Report Builder [message #414989 is a reply to message #414399]

Fri, 24 July 2009 05:47

shaz
Messages: 182
Registered: June 2009

Senior Member

it works absolutely fine in reports.

I guess its something wrong in your query. check that.

Report message to a moderator

Re: WITH Clause with Report Builder [message #415043 is a reply to message #414399]

Fri, 24 July 2009 08:28

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

what version of reports are you using?

Report message to a moderator

Previous Topic:	oracle report 6i
Next Topic:	report header

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 15:34:27 CST 2025