After upgrade to SV5.1 Rev A, including upgrade of Crystal Reports to CR 2008 SP3 FP3.3, the interface in Crystal Reports cannot see the PDL Tables/Views.
After upgrade to SV5.1 Rev A, the interface in Crystal Reports cannot see the PDL tables. The table information that is available under 'localhost' > 'OPS$OCSHIS' shows none of the PDL table/view selections.
The Tables & Views that are available do not provide access to the correct objects required to build new reports.
Existing reports that were built prior to the upgrade function correctly.
Symptoms:- PDL Tables & Views cannot be accessed when building report templates with Crystal ReportsConfiguration of Crystal Report Database Options incorrect.New reports cannot be configured by selecting objects from the PDL Tables & Views
Answers
The following is the solution to the configuration of the setup in Crystal Reports for the problem where the PDL Tables and Views were not visible. The Options/Settings for the Database Expert connection may appear as in Figure 1 below.
Figure 1
The corrected configuration of these settings are as shown in Figure 2 below. When the settings have been changed, close the Options window by selecting 'OK', then close and re-open Crystal Reports. The PDL Tables and Views should now be available.
Figure 2
Add new comment