How to get SQL used by a Report ?

[sheila11]

Hi all,

I am running a BO report. It works fine. Now I want to know the exact SQL that the BO used to generate that report, and use it in my ASP.

How can I get that SQL ?

TIA,
Sheila

 

[RogerCruse]

Hi Sheila,
Can you see the SQL icon?

If you can, then this will give you access to the code used to get the data... You may need to open the report under the full client version of BO to see this.

Otherwsise, talk to you BO supervisor.

Roger...

 

[skrandel]

But, do be careful. If you report has prompts in it, you won't get the exact SQL.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[sheila11]

Thanks, guys. It worked fine.

 

[RogerCruse]

Sheila,
I'm pleased that it worked.

Steve's point is valid and your DBA should be able to capture the actual SQL from the rDBMS audit logs.

Roger...