|
|
|
|
|
| a command line | |
| Windows Task Scheduler | |
| SQL Server Scheduler | |
| batch files | |
| your own application | |
| any program that can execute a command! |
Crystal Command comes with a user friendly Command Line Generator interface that allows you to quickly and easily generate the required command to run your existing Crystal Report (.rpt) file. The Command Line Generator will allow you to select a Crystal Report file and will then ask for any database connection information or parameters needed to run the report. You can then select options to export, print, email or view the report. Available export formats includes PDF, Excel, HTML, and XML. The Batch feature allows you to generate multiple Crystal Report commands into a single batch file.
Crystal Command also includes the Line Processor, an executable file that is responsible for decoding the command line and processing the report.

View a report with No Login
Information and No Parameters.
C:\CML\CML.exe C:\SourceReportFolder\MyReportName
Export to Excel format with No
Login Information and No Parameters.
C:\CML\CML.exe C:\SourceReportFolder\MyReportName /X 36
/D 1 /FN C:\TEMP\MyReportName.xls
Export to PDF
format with Login Information, encrypted password and 2 Parameters.
C:\CML\CML.exe C:\SourceReportFolder\MyReportName.rpt
/L1 MyODBCName,ReportDatabaseName,UserName,Password /P1 01/01/2002 /P2 MyParam
/X 31 /D 1 /FN C:\TEMP\MyReportName.pdf
Email a
Report (MAPI) in PDF format with No Login Information and 1 Parameter.
C:\CML\CML.exe C:\SourceReportFolder\MyReportName.rpt
/P1 MyParam /X 31 /D 2 /ETO ToEmailAddress /ECC CcEmailAddress /ESB Report
Subject /EMS New report message
Email a
Report (SMTP) in PDF format with No Login Information and 1 Parameter.
C:\CML\CML.exe C:\SourceReportFolder\MyReportName.rpt /P1
MyParam /X 31 /D 9 /ETO ToEmailAddress /ECC CcEmailAddress /ESB Report Subject
/EMS New report message
|