How To Add a SQL Report to a remiCrystal Task

To add a SQL Report to an existing or new remiCrystal task:

1. Open remiCrystal and go to the Reports & Actions tab
2. Click on the SQL Report button
3. When the new SQL Report window opens, in the Report tab you can specify the following options
   1. Report Name: the name of the report
   2. Description: the description for the report (optional)
   3. Ignore if no data is returned: whether or not the report will be ignored when the query doesn't return any records 
   4. Enabled: whether the report will be run as part of the task or not
   5. Vital: whether the entire task should be stopped if this report fails
4. Under the Query Options tab, the following options are available:
   1. You can select to use an ODBC DSN to connect to your database or a custom connection string (the ODBC DSN must be created under the System DSNs of the 32-bit ODBC Admnistrator control panel). 
   2. Select the ODBC DSN from the dropdown or enter your connection string
   3. Provide the ODBC DSN username and password if required
   4. Hit the Connect button
   5. Once connected, you can use the query builder to construct your SQL query or paste in a custom one
   6. Hit OK when completed
5. From the Output Format tab, you can specify the format that you would to export the query results to as well as the name of the output file.