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: http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp
Main settings tab
This is the path to the report. If located on a network drive you need to specify the Source Credential)
If report file is on network drive you need to select a Credential.
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.
A range of output formats exist when you select File destination type option.
If the output file is on a network you need to specify a Credential.
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.
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.
Check this if your database requires a Windows user for logon. When checking this the username and password needs to be a Windows user.