SAP Knowledge Base Article - Public

1218540 - Only up to 100 reports or folders display in Crystal Reports when navigating the Enterprise repository

Symptom

  • Missing reports or folders.
  • When opening or saving a report from Crystal Report to the Enterprise folder, not all the reports are listed. It is missing reports.
  • In SAP BI LaunchPad, and in the Central Management Console (CMC), when navigating to the same folder, it shows all the reports.
  • In Crystal Reports, you can open a report using the 'Enterprise' folder option.  However, when you click 'Enterprise' from the 'Open' dialog box, only the first 100 reports are listed. All other reports are missing.
  • Why does this behavior occur, and how do you view more than 100 reports, or folders in Crystal Reports?
        
         
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, under the menu "File", select "Open..."
  2. In the Open window, in the left pane, select "Enterprise"
  3. Logon to SAP BusinessObjects Enterprise.
  4. When navigating to a folder that contains more than 100 objects, it only display the first 100.
      
    Next_Batch_02.png

Cause

  • In order to improve end user experience when browsing the repository, Crystal Reports does not retreive all the objects at once, but it instead only fetch the first batch of 100.

Resolution

  •  To view the other reports in Crystal Reports, select "Next Batch"
       
    1. In Crystal Reports, in the "Open" window, right click on the folder, and select "Next Batch"
       
      Next_Batch_03.png
       
       
    2. It will then display the next batch of 100 objects. If you have more than 200, then select the "Next Batch" again, until you find the desired objects.

Keywords

CE10 CR10 LIMITATION FOLDERS LISTING ONE HUNDRED C2013703 Crystal Reports Crystal Enterprise 10 Opening report Folder list , c2017457 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020