Owner Statements Showing Up Blank - No Data Displays

Index
Article ID#: KWin0186
Added: 01/30/12

Issue

When previewing an owner statement, the statement report shows up blank and no data displays on the report. This issue occurs when the report is not setup as with an ODBC connection to the data.    

Solution

1. Update the Datasource to use ODBC.

   1. Open Crystal and select a report to open in Design view.  Crystal Reports Version 10.0.0.553 for CR Developer was used for these examples.
      
      Note:  Reports that use the Totals, OTotals, Journal or Forecast files should not be converted.  These files are not ODBC compliant.
      

      

   2. From the Database main menu, select Set Datasource Location.
   3. Expand the History and Current Connections folders.
   4. When an ODBC connection in History or Current Connections is not present: 
   1. Expand the Create New Connection folder.
   2. Expand the ODBC (RDO) folder within the Create New Connection folder to open the ODBC (RDO) screen.
      

      

   3. Select the "Enter Connection String" radio button.
   4. Enter the connection string as Driver=Pervasive ODBC Client Interface;ServerName=xxx;dbq=rdp01 where xxx is your computer name).
      

   

   5. Click Finish.
   5. In the "Current Data Source" section of the screen, highlight "..\..\file.ddf", and in the Replace With section, select the "Driver=Pervasive ODBC Client Interface;ServerName=xxx;dbq=rdp01" just defined in the ODBC folder.
      

      

   6. Click Update.
   7. Repeat Step 5 and 6 for each "..\..\file.ddf" in the Current Data Source section.
      

      

   8. Close the Set Datasource Location screen.
   9. Save and close the report.
2. When the subreport is updated, the Mapped Field screen appears.  The Tx-MPkgFlagDate in the upper quadrant has changed names.
3. Select TxMPkgFlagDate in the right upper quadrant and click the Map button.
4. Click OK.
5. Click Database main menu --> Verify Database.
6. File --> Save and retry the statement in RDPWin.