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: http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp

 

 

Main settings tab

 

clip0sdfgdggfgffg049

 

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

 

crparameters

 

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

 

cr_recordfilter

 

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

 

cr_printer

 

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

 

The Crystal Reports Connection

 

 

clipsdfdsffddsf0049

 

Address

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.

 

 

cliasdfsdfdsfdsp0049

 

Username

Username to the database source in the Crystal report.

 

Password

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.