Show/Hide Toolbars


The Crystal Reports Task allows you to output Crystal reports in various formats like PDF, Excel and to printer. With this Task you can specify in-parameters and record filter. The record filter can further narrow down the report query.


This Task requires that you have installed the runtimes for Crystal Reports - .NET 4.0 edition. You can download these here:



Main settings tab




Report file

This is the path to the report. If located on a network drive you need to specify the Source Credential)


Source Credential

If report file is on network drive you need to select a Credential.


Connection details

Select one ore more Connections here depending on how many database connections your report uses.


Destination file type

You can choose to output to file or printer.


Output format

A range of output formats exist when you select File destination type option.


Destination Credential

If the output file is on a network you need to specify a Credential.



Parameters tab




Your report might include required or optional parameters. If parameters are already defined you can click on "Import parameters". This will import and list your parameters. You can then edit any parameter by double clicking on it (or press Edit). Import parameters button require that you have setup your Connection settings in the Task before pressing - otherwise VisualCron will not be able to query for parameters.



Record filter tab




The record filter allows you to choose from existing columns in the report and specify filters - similar like WHERE in a SQL query. This way you can filter the report.


You can manually write the query in the Record filter text box or click "Reload" to load all existing columns, choose a condition, write a value and then press Add.



Printer tab




The printer tab lets you control various printer settings if you have chosen Printer as output type.


The Crystal Reports Connection






Address can be different things depending on the context. When using a ODBC source in your Crystal report, then the address is the name of the ODBC connection. What is also important is that the ODBC connection you use in the Crystal report must be resided in SYSTEM DSN and not USER DSN - otherwise it will not be seen by other users - like the user that runs the VisualCron service.






Username to the database source in the Crystal report.



Password to the database source in the Crystal report.


Integrated security

Check this if your database requires a Windows user for logon. When checking this the username and password needs to be a Windows user.