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!
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: 912
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.
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!
Previous Topic: Installing Discoverer
Next Topic: How to schedule report export to excel
Goto Forum:
  


Current Time: Sun Dec 04 10:45:44 CST 2016

Total time taken to generate the page: 0.05569 seconds