Crystal Command 9.0

Now Available

You can now run Crystal Reports from a Command Line. 

This product will allow you to View, Export, Print and Email your existing Crystal Report file (.rpt) without using Crystal reports.  Crystal Command enables you to run a command line from an   Event Scheduler, Task Scheduler, SQL Server Scheduler, a windows command line or from any application that requires a command line.   You can also run this command line from your own application without costly and time-consuming programming.

The Batch feature allows you to generate multiple Command Lines into a sing Batch file.   This batch file can then also be run form a command line.

Crystal Command comes with a user friendly Command Line Generator interface that allows you to generate a command line from your existing report (.rpt) file.  The Line Generator will allow you to select one of your existing Crystal Report files and then step you through the process to automatically generate a command line. You will be prompted for any database connection information as well as parameters that your report contains.  You can then select the option to Export, Print, Email or just View the report.  There are many Export formats available to you such as PDF, Excel, HTML, XML etc.

Crystal Command also includes the Line Processor that will decode the command line and process the report.  The Line Processor (CML.exe) is an executable file that is followed by the formatted command line.

 

 

Here are some Command Line Examples

These samples were all generated automatically by the Crystal Command - Line Generator

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