Report Page

The Report page includes basic processing options for the report.

Report File

Shows the name of the report file to be processed. To select a different report, select Open from the File menu.

Note that the Command-Line Builder is not able to open report files via HTTP or FTP download. If you want to use the Builder with a report that will be downloaded at runtime, you need to work with a local copy of the report, and then modify the generated command line to point to the HTTP or FTP target.

Force refresh of report data after loading

This option has an effect only if you checked the Save Data with Report option in the Crystal Reports Designer before you saved the report. If Save Data with Report was checked, Force refresh of report data after loading works as follows:

• If Force refresh of report data after loading is not checked, Report Commander works only with the data saved in the report. The logins and parameters are not used, because the report is not refreshed from the data source.
• If Force refresh of report data after loading is checked, Report Commander refreshes the data, producing the same result as if data were not saved in the report.

Skip further processing if report contains no data

When checked, Report Commander will not export, print, or e-mail the report if it does not contain any data records.

This option works by checking to see if the report contains detail records, regardless of whether they are displayed, and may not always produce the result you want. More information.

Print

The Print options are used to print the report to a printer.

Print report

When checked, Report Commander will print the specified number of copies of the report.

Printer

Select Use default printer to print the report to the default printer for the user under whose account Report Commander is run. Select Use this printer to print to a specific printer.

Paper Source

Select a paper source to print using a specific paper source. Only available if you have selected a specific printer.

Export

The Export options are used to export the report to a file and, optionally, send the exported report by e-mail.

Export the report

The report is exported to a file.

E-mail the report

The report is exported to a file and then sent by e-mail, using the settings on the E-Mail page.

If Export the report and E-mail the report are both checked, the report is exported to a file and sent to the e-mail recipients, and the exported file remains on the computer in the location specified in the Name box.

If E-mail the report is checked but Export the report is not, the report is exported to a temporary location and sent to the e-mail recipients. The exported file does not remain on the computer after it is sent.

Format

Select the file format for the exported data. See the Command Line Syntax topic for a description of the available formats.

Depending on the format you select, additional formatting options will be available on a separate page. Click the Set Export Options link to go to the options page.

Name

Specify the path and name of the export file. Use the ... button to browse for the target.

This field can contain variables and functions that are replaced at runtime. More... Click the {} button to display the text editor, which helps you insert variables and functions into the text. When you hover your mouse pointer over the field for a second, a preview of the "expanded" text will be displayed so you can confirm your variables and functions are working correctly.

If E-mail the report is checked but Export the report is not, only the file name is used (not the path); the report is exported to a temporary directory using the specified file name, then deleted after it is e-mailed.

You can configure Report Commander to upload the export file to an FTP, SFTP, or HTTP (Web) server by specifying the file name in a special format. See the Uploading Output topic for more information.

Logging

Specify a log file for Report Commander to write messages to during report execution. Check Append to existing log file to add to the existing log file on each run, or uncheck the box to overwrite the log file on each run.

The default setting uses ${TEMP}\${Report.Name}.log as the log file name, which means the log file will be written to your TEMP folder and will have the same name as the report, with a ".log" extension. You could also use ${Report.Path}\${Report.Name}.log to write the log file to the same folder as the report, or enter any path and name you wish.

Because Report Commander is designed to run in an automated/unattended mode, it does not show a user interface when you execute reports. Therefore the only way you will be able to review error message if something goes wrong is to use a log file.

This field can contain variables and functions that are replaced at runtime. More... Click the {} button to display the text editor, which helps you insert variables and functions into the text. When you hover your mouse pointer over the field for a second, a preview of the "expanded" text will be displayed so you can confirm your variables and functions are working correctly.

Manage variables, distribution lists, and mail servers

This link opens the User Settings window, which allows you to manage variables, mail servers, and distribution lists that are available for all Report Commander projects/commands you run on this computer.