Release Notes › Known Issues › Reporting › Generating User Accounts Fails if More than 20,000 Records Exist

Generating User Accounts Fails if More than 20,000 Records Exist

If over 20,000 records exist, generating a user accounts report fails.

Workaround

1. Open the Business Objects Central Management console.
2. Click Servers and select servername.pageserver.
3. Select Unlimited records for the entry Database Records To Read When Previewing Or Refreshing a Report.
4. Using Crystal Reports designer, open the user accounts report.
5. Using Database, Set Datasource Location, set the database location to your snapshot database.
6. Save this change.
7. Using Database, Datasource Expert, right click Command on the right side window.

   It shows the SQL syntax on the left-hand side and the Parameter List.

8. Enter the parameter name as you find it in the Parameters Fields in the report template.
9. Change the query in the left-hand side and add that parameter in the query.

   For example, if you have reportid parameter, the query will be:

   Select *  from endPointAttributes, endpointview, imreport6
   where endPointAttributes.imr_endpointid = endpointview.imr_endpointid and endPointAttributes.imr_reportid = endpointview.imr_reportid 
    endpointview.imr_reportid = imreport6.imr_reportid and imreport6.imr_reportid = {?reportid}
   

10. Save the report.