Implementation Guide › Implementing Enterprise Reporting › How to Set Up Reporting Service Server Components › Configure BusinessObjects for Large Deployments

Configure BusinessObjects for Large Deployments

To run CA ControlMinder reports on large deployments, you need to change the BusinessObjects default configuration. You change the maximum number of concurrent connections that the BusinessObjects page server can create (the default is 20,000). You also change the maximum number of values that are shown in input parameters selection lists.

To configure BusinessObjects for large deployments

1. Change the number of concurrent connections that the BusinessObjects page server can create:
   1. On the Report Portal computer, click Start, Programs, Crystal Enterprise, Central Configuration Manager (CCM).

      The BusinessObjects Configuration Manager opens.

   2. Right-click Crystal Page Server and select stop.
   3. Right-click Crystal Page Server and select Properties.
   4. Verify that the following text appears after -restart in the Path to Executable field:

      -maxDBResultRecords 0
      

   5. Restart the BusinessObjects page server.
2. Change the maximum number of values that are shown in the input parameters selection lists for reports:
   1. Open the Windows Registry Editor.
   2. Navigate to the following registry key:

      HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\CrystalReports\DatabaseOptions
      

   3. Click Edit, New, DWORD Value.

      A new registry entry of type REG_DWORD appears.

   4. Rename the entry to QPMaxLOVSize.
   5. Double-click the entry and edit its Value data to 1000.

      The new registry entry is set.

   6. Open BusinessObjects Central Management Console (CMC).
   7. Navigate to the Servers management area.
   8. Click the Web Intelligence Report Server whose settings you want to change.

      The Web Intelligence Report Server page opens in the Properties tab.

   9. Modify the following values to more than 1000 or as required:
      • List of Values Batch Size
      • Maximum Size of List of Values for Custom Sorting

      Click Apply to submit changes and restart the server so that the changes take effect immediately.