Issue:
When printing your Crystal report, the data is blank or the data is pulling from another company.
Cause:
Cause 1:
In the Connection tab of the Crystal report in Dynamics Report Manager, the checkbox for the Switch Data Source to use SQL Company Database option is not marked. (See Resolution 1.)
Cause 2:
In Crystal reports, the Save Data with Report option is marked on the File menu. (See Resolution 2.)
Resolution:
Resolution 1:
You can either update the Connection Settings in the Dynamics Report Manager System Settings window for all Crystal Reports:
- Go to Microsoft Dynamics GP | Tools | Setup | Dynamics Report Manager | System Settings.
- Click the Crystal tab.
- Select the correct DSN Name.
- Mark the Switch Data Source to use SQL Company Database checkbox.
- If you need to override report credentials, mark the Override Report Credentials checkbox, and then enter the appropriate Username and Password.
Or, you can update the Connection Settings per Crystal Report:
- Go to Reports | Dynamics Report Manager | Dynamics Report Manager Explorer.
- Select the report, and then click the Edit Report button.
- In the Report Maintenance window, click the Connection tab.
- Mark the Override Global Connection checkbox, and then select the correct DSN Name.
- Mark the Switch Data Source to use SQL Company Database option.
- If you need to override the report credentials, mark the Override Report Credentials checkbox, and then enter the appropriate Username and Password.
Resolution 2:
- Open the Crystal report in Crystal.
- Click File, and then click Save Data with Report to unmark the option.
- Click File, and then click Save.
Note: If the report in Crystal continues to have the Save Data with Report option marked, try the following and then repeat the first three steps in Resolution 2:
- Click File, and then click Options.
- Click Reporting.
- Unmark the Save Data With Report checkbox.
- Click OK.