Kbase P117525: Report Builder: How to export the SQL Statement used for a Report
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/25/2006 |
|
Status: Unverified
GOAL:
Report Builder: How to export the SQL Statement used for a Report
GOAL:
How to get the SQL used for a Report builder report
GOAL:
How to enable debug mode in report builder
GOAL:
How to print Report specifications with SQL statement used in the report
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
1. To get the SQL statement used in a report to the screen:
1a. Open the Report Builder Report
1b. Press CTRL+ALT+P (this puts report builder into Debug Mode)
1c. Press F12 and a dialog will appear with the SELECT statement Report Builder uses to execute the report
2. To Print the SQL SELECT statement used in a report:
2a. Open the report in Report Builder
2b. Choose REPORT->Print... from the Report Builder Menu bar
2c. Choose Report Specification in the print combo box
2d. Choose the print button