Need SQL Statement for Report Builder

ecfmis

ecfmis

New Member
I have inherited the job of re-creating a report from the old report builder and moving it to access. I was able to create the odbc connection but the report itself is very complex. If I could just pull the SQL statement(s) out of the report it would make my life much easier. I see where to get joins and filters, but is there a way to get the actual statement?

Thanks,
Tim
 
Note to any one following the link:

It no longer works (the number isn't stored in the online KB). I'll try and work out if this will be a recurring issue.

In the meantime, here's the text:

----

See the SQL SELECT in a Report Builder report - debug mode

Report Builder has a debug mode that enables you to see the actual
SQL SELECT statement that is sent to the SQL Engine. This is primarily
intended as a diagnostic tool, not as a fully supported feature.

To get into debug mode, do the following:
While the report definition is open in Report Builder, press the
CTRL-ALT-P keys. This puts you in debug mode. To see the SELECT
statement on the screen, press F12 and a dialog box will appear.
If you want to print the SELECT statement along with the rest of the
Report Specification, go into menu Report->Print and choose
"Report Specification" in the Print: combo box.

Progress Software Technical Support Note # 15662


----


And here's another way:


KB 23287:

How to analyze your Report Builder Query

FIX:

Use the start-up parameter -rbzsqldump and create a directory called
c:\foo.

This will create a log file c:\foo\sql.log which contains all of the
ESQL generated by Report Builder for a report. The directory c:\foo
must exist before Report Builder is run with this parameter.

This report will show you all of the SQL queries being made which you
can in turn use to optimize your report.

http://tinyurl.com/8w4vb

(See how long that link works...)

-----

Lee
 
You must log in or register to reply here.
Back
Top