Home » Developer & Programmer » Reports & Discoverer » User Discoverer SQL code for PL/SQL developer report
User Discoverer SQL code for PL/SQL developer report [message #231779] Wed, 18 April 2007 07:05 Go to next message
guysa30
Messages: 3
Registered: April 2007
Junior Member
Hi,
Does anyone know how to use the SQL Inspector window in a report I created in order to create the same report in PL/SQL developer?
Is it possible? (I created a crosstab report).
10x!

Report message to a moderator

Re: User Discoverer SQL code for PL/SQL developer report [message #231975 is a reply to message #231779] Thu, 19 April 2007 00:14 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
No, this is not possible because Discoverer takes care of the formatting (including transforming it into a crosstab layout) AFTER the SQl statement has been processed.

So, you can get the same data by executing the SQL you find in the SQL inspector, but you can't get the same layout.

Report message to a moderator

Re: User Discoverer SQL code for PL/SQL developer report [message #232004 is a reply to message #231975] Thu, 19 April 2007 01:18 Go to previous message
guysa30
Messages: 3
Registered: April 2007
Junior Member
Thanks!

Report message to a moderator

Previous Topic: Installing Discoverer
Next Topic: How to schedule report export to excel
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 11:37:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.