DO REPORT CRYSTAL command

Used to generate reports using the specified a Crystal Reports template and the active ACL table.

Syntax

DO REPORT CRYSTAL WITH template_filename <HEADER header_text> 
<FOOTER footer_text> TO {SCREEN|filename|EXCEL|PDF|PRINT}

Parameters

WITH template_filename

Specifies the Crystal Reports template to use.

HEADER header_text

Optional. Specifies the header text to pass to the “ACL Header” field in the Crystal Reports template. The header_text value must be specified as a quoted string.

FOOTER footer_text

Optional. Specifies the footer text to pass to the “ACL Footer” field in the Crystal Reports template. The footer_text value must be specified as a quoted string.

TO SCREEN | filename | EXCEL | PDF | PRINT
  • SCREEN opens the report in the Crystal Report viewer.

  • filename is the filename of the output report.

  • EXCEL creates a Microsoft Excel file in the ACL project folder. The filename is the same as the report name with a .xls file extension.

  • PDF creates an Adobe Acrobat file in the ACL project folder. The filename is the same as the report name with a .pdf file extension.

  • PRINT sends the output to the default printer.

Examples

The following example uses the cc_activity_br.rpt template to generate a report from the data in the Expenses table. A custom header is assigned to the report when it is generated, and the report is saved as a file that can be opened in the Crystal Reports Viewer.

OPEN Expenses
DO REPORT CRYSTAL WITH "cc_activity_br.rpt" 
HEADER="Activity per branch - Dec. 2011" TO "CC_Dec.rpt"


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback