Displaying and Exporting the SQL Report
After you have completed steps 1 through 6 (see Creating Static Reports Using SQL for information about the preceeding steps) successfully, the report will appear in the Reports module in Commerce Server Business Desk. The next step is to run or export the report from Business Desk. For information about running or exporting this report, see Business Desk Analysis.
After the report is run, it can be viewed from Business Desk or you can programmatically display or export the report using the ReportRenderer or AsyncRpt objects. For information about programmatically displaying or exporting the report, see ReportRenderer Object and AsyncRpt Object.
A SQL script file is included in the SDK which creates a static SQL report. The file is located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts.