9 4 Crystal Reports

LANSA Client

9.4 Crystal Reports

Error message "Failed to load database information" is displayed when you try to run an existing query that outputs results to report

If the report has been created using an older version of Crystal Report, then this message indicates that Crystal Report hasn't installed the driver that is needed. The following steps will rectify the problem.

1.  In the LANSA Client main window, select the Results menu and then choose Report designer

2.  In Crystal Report, open the report file that you tried to execute.

3.  Select the Database menu, then Verify Database, and Crystal Reports will trigger the installation program to install the required driver.

     If the installer is not invoked, you can run a custom Crystal Report setup and elect to install the Data Access features.

Error message, "Logon failed'" is displayed when you try to run an existing query that outputs results to report

This can happen when the report was created using an older version of Crystal Reports - it is believed that this issue only arises for reports created in Crystal Reports versions before version 8.5 (version 8.5 of Crystal Reports was supplied with LANSA Client version 10.0).

In that case, this message may indicate that the database related to that Crystal Report file cannot be found. Please perform the following steps to rectify the problem:

1.   Start Crystal Report.

2.  Open the Crystal Report file that caused the error.

3.  Select the Database menu and choose Set Datasource Location.

4.  Locate the correct database file and press Update.

5.  Save the Crystal Report file.

6.  Re run the query.

The data displayed in the report does not match the data returned from the query

If you select the Save data with report option in Crystal Report's File menu, Crystal Reports will save the report together with the data. The next time you run the report, it will contain the saved data regardless of whether you have run your query again.

To ensure that your report contains the latest data, when you save a report format, ensure that this option is off, so that the Report looks for the latest query results to report.

If the "Save data with report" option is ticked, you can still refresh the data in your report by selecting the Refresh button (i.e. the lightning bolt).

Your Crystal report is showing incorrect data when the query is run

1.  Press the refresh data button (the lightning bolt).

2.  Open the report using Crystal Reports and check that the "Save Data with Report" (under File) menu option is NOT checked.

3.  Check that the dBASE or MDB file from which Crystal is getting its data is the file that you want to use. Do this by selecting the Set Location (under Database) menu option and check the name of the file in the Location section of the dialogue window.

Your Crystal report is showing incorrect data when query is run in a generated application

A generated application executes and stores its data in the LANSA Client Applications Directory. By default this directory is called LANSA\APPS.

When a report is part of a generated application, make sure that the report gets its data from the LANSA Client Applications directory.

You can check this by selecting the 'Set Location' command from the Database menu in Crystal Reports.

Further Information

Ý 9. Troubleshooting