your database front-end

Server Outage Notice: dbFront.com will be transfering to a new Server on Friday 25th @ 7pm MST

Crystal Report Helper (FREE)

The Crystal Report Helper (CrystalReportHelper.exe) is a FREE command-line utility that can be used to automatically export specific Crystal Reports as either CSV, DOC, PDF, RTF, TSV or XLS.

We created this utility to support the Crystal Reports functionality within dbFront but are making it freely available here.

Crystal Report Helper

Commandline Arguments

The following Command-Line arguments are supported.  To see them used in context refer to the examples given below.

/Action Action [Inspect, Export, SavePassword, ClearConfig]
/Report Report file.
/Path Set Application Path.
/ReportParams Report Parameters.
e.g. /ReportParams="[param1:val1;param1:val1]"
/Output Output File. The file extension determines the output type. e.g. /Output=Books.pdf
/Server Specify the Server for the Password to be saved.
/Database Specify the Database for the Password to be saved.
/User Specify the User for the Password to be saved.
/Password Specify the Password to be saved.
/Help Returns this help.

Examples

The following represent some of the valid combinations.

  • Inspect a Report
    CrystalReportHelper.exe /Action=Inspect /Report=Books.rpt
  • Export a report as PDF with the given parameters
    CrystalReportHelper.exe /Action=Export /Report=Books.rpt /ReportParams="[par1:val1;par1:val1]" /Output=Books.pdf
  • Save a password for a specified database
    CrystalReportHelper.exe /Action=SavePassword /Server=localhost /Database=CompanyDB /User=Fred /Password=FredIsRed
  • Clear the saved passwords
    CrystalReportHelper.exe /Action=ClearConfig

Export Output Options

The file extension of the output file determines the export format.  For example, the following command will export the report as a PDF file.
CrystalReportHelper.exe /Action=Inspect /Report=Books.rpt

The available output formats are:

  • csv: Exports the report data in a structured format.  This is the only export format that only returns the data.
  • doc: The Microsoft DOC format creates an editable report document.  Some of the formatting and layout may have shifted.
  • pdf: The Portable Document Format (PDF) results in a file that should exactly match a printed report.
  • rtf: Similar to the DOC format, the RTF format creates an editable report document.
  • tsv: The TSV format is not an alternate version of CSV.  The TSV format is closer to a text-only version of the DOC or RTF exports.
  • xls: Similar to the DOC format, the XLS format creates an editable Excel document containing the full report including layout and data.

Operation

The Crystal Report Helper has four modes of operation.

  • Inspect: Inspect the report and generate suggested actions,
  • Export: Run the report and export the results,
  • SetPassword: Store/Update a set of credentials password,
  • ClearConfig: Clear any stored passwords and configuration.

The mode of operation is determined by the Action command-line option.

Crystal Report Helper

Inspect

The Inspect action tells the Crystal Report Helper to analyze the specified Crystal Report. This will test the Crystal Reports Runtime and retrieve the expected parameters for that specific report.

Once complete the Inspection returns a sample command line showing the proper means to call this report and extra details in an XML block.

  • Command
     CrystalReportHelper.exe /Action=Inspect /Report=Books.rpt
  • Result
     CrystalReportHelper.exe /Action=Export /Report=Report1.rpt /Output=Report.pdf /ReportParams="[clientID:0;invDate:2022-03-24]"

Export

The Export action tells the Crystal Report Helper to process the specified Crystal Report and generate the requested output. If you need help with the parameters you can use the Inspect action to have the Crystal Report Helper generate a sample command-line including the required report parameters.

The following is a sample command line:

  • CrystalReportHelper.exe /Action=Export /Report=Report1.rpt /Output=Report.pdf /ReportParams="[clientID:0;invDate:2022-03-24]"

SetPassword

Saving and managing multiple instances of database credentials in batch files is a dangerous practice.  To help with that, the Crystal Report Helper maintains a common encrypted credential store which it uses for all reports.  As the report is run the Crytal Report Helper will look up the appropriate credentials based on the database and username within the report and automatically connect.

If a single set of credentials is stored then that set of credentials will be used for all reports.  If multiple sets of credentials are stored then the most appropriate set of credentials will be used.

The SetPassword action tells the Crystal Report Helper to save a set of credentials.

The following is a sample command line:

  • CrystalReportHelper.exe /Action=SavePassword /Server=localhost /Database=CompanyDB /User=Fred /Password=FredIsRed

ClearConfig

The ClearConfig action tells the Crystal Report Helper to clear out all saved configuration and passwords.  The following is a sample command line:

  • CrystalReportHelper.exe /Action=ClearConfig

Installation & Setup

The Crystal Report Helper is automatically installed with the latest version of dbFront.  Please contact us to download the Crystal Report Helper as a stand-alone tool.

When the Crystal Report Helper is run it will validate that the Crystal Report Runtimes are installed.  If the runtimes are missing then it will generate an error specifying the needed runtime version (32 bit or 64 bit).

SAP Crystal Reports for Visual Studio (SP31) runtimes

Version Filename Source (Free Account Required)
SP31 runtime (32-bit) CR13SP31MSI32_0-10010309.MSI http://crystalreports.com/crvs/
SP31 runtime (64-bit) CR13SP31MSI64_0-10010309.MSI http://crystalreports.com/crvs/

With the correct runtime installed the Crystal Report Helper will be able to process the report requests.

Support

All support for the Crystal Report Helper is via the Crystal Report Helper Q&A.

Free trial

dbFront offers a 30-day free trial so that you can download, install and test it in your environment.  After the trial you can continue to use the FREE version of dbFront for up to 3 users.  Please review the video tutorials and plan to start a free trial today.  We believe you will be impressed.

Content you want the user to see goes here.
close