Administration Guide › Reporting › Troubleshooting › Generating User Accounts for over 20,000 Records

Generating User Accounts for over 20,000 Records

If over 20,000 records exist, some extra steps are necessary to generate user accounts report.

To generate a user accounts report for over 20,000 records

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 a 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 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 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.