1764318 - 'No items found.' when trying to create a report off an SAP InfoSet from Crystal Reports

• No items found.
• No Info Sets listed.
• Unable to create a new report off Info Sets in Crystal Reports.
• When attempting to create a report off an SAP InfoSets or SAP InfoSets Query in Crystal Reports, it does not display any InfoSets to report from.
  It is simply written: "No items found."
    
      
• 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.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
      
• SAP ECC
• SAP ERP

1. In Crystal Reports, create a new report.
      
2. In the "Database Expert" window, under "Create New Connection", double click on "SAP Info sets"
     
3. Select an SAP System, and enter the SAP User Name and Password.
       
4. When expending the "Classic InfoSet" or "SAP Query", notice it does not list anything. It instead displays: "...no items found..."
     
   

• SAP User is not assigned to the User Group the SAP InfoSets is assigned to.

• To be able to report off an SAP InfoSets, assign the SAP User, to the appropriate InfoSets Group on the SAP System:
     
1. Start the SAP GUI, and logon to the SAP System. ( SAP ECC, SAP ERP,... )
      
2. Go to the InfoSets User Groups screen, by typing transaction: SQ03
     
     
           
              
3. Verify if the InfoSet you want to report from is a assigned to a specific Group.
   To do so, enter the name of the InfoSet under "User group assignment", and click "Change" 
         
   ( In the example below, the InfoSet name is: DEMO_JOIN)
     
     
        
        
4. If the InfoSet is not assign to any Group, assign the InfoSet to one of the groups in the displayed list by adding a check mark, then click the "Save"' button.
     
    ( In the example below, we selected the group "DEMO_GROUP" )  
       
     
        
      
5. Click the Back button in the toolbar. 
      
6. Back to the User Groups screen, under "User group assignment", enter the SAP User name, and click "Change"
    
   ( In the example below, the SAP User is: DEMO_USER )
     
     
     
     
7. Assign the user to the same Group as the one the InfoSet was assigned to, and click "Save"
     
    ( In the example below, we assign the user to the Group: DEMO_GROUP )
    
    
        
     
8. Click the Back button in the toolbar, and you have now assigned an InfoSet and a User to a Group.
      
9. In Crystal Reports, when creating a new report using the InfoSets connection, it will now list the InfoSet.
           
   ( In the example below: We can now see the InfoSet: DEMO_JOIN )
     
   
          
                 
   
   
• Note: If you need to create a User Group, where you assign users and InfoSets, follow the steps below:
  
  
1. Go to transaction: SQ03
       
2. For "User Group", enter the name of the group to be created and click "Create"
     
3. Enter a description for the user group.
      
4. Click 'Assign Users and InfoSets'.
     
5. Enter the User name assigned to the Group and click 'Return'.
     
6. Repeat step 4 for every user that you want to be a member of the group.
     
7. Click 'Assign InfoSets'
     
8. Choose the desired InfoSets from the list by selecting the checkboxes on the left.
     
9. Click the 'Back' icon.
       
10. Click 'Back' again and click 'Confirm to Save' when prompted.

CR, InfoSets , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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