SAP Knowledge Base Article - Public

2754121 - In Query Builder, how to return the list of reports created in Crystal Reports for Enterprise only, or Crystal Reports only?

Symptom

  • How to get the list of all the reports created in Crystal Reports only?
       
  • How to obtain the list of the reports created in Crystal Reports for Enterprise, that are stored on the SAP BI Server?
         
  • On the SAP BusinessObjects BI Server, how to use Query Builder to return the list of all the reports created in Crystal Reports for Enterprise only, or a list of all the reports created in Crystal Reports only?
          
  • In Query Builder, a query that uses the filter: SI_KIND = 'CrystalReport' returns all the reports created in Crystal Reports, and in Crystal Reports for Enterprise. How to only return the report that were created in Crystal Reports for Enterprise, or only the reports that were created in Crystal Reports? 

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
      
  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2

Resolution

  • To return the list of all the reports stored on the SAP BusinessObjects Business Intelligence Platform that were created in Crystal Reports only, or all the reports that were created in Crystal Reports for Enterprise only, filter the query on the property: SI_REPORT_ENGINE_TYPE
       
    1. Login to Query Builder.   ( http://<SAP BusinessObjects BI Host Server>:<Port Number>/AdminTools )
            
    2. In Query Builder, to return the list of all the reports saved on the SAP BusinessObjects Business Intelligence Platform, use the following query:
         
      • For Crystal Reports for Enterprise:
           
        SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND= 'CrystalReport' and SI_REPORT_ENGINE_TYPE = 0
             
          
      • For Crystal Reports:
             
        SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND= 'CrystalReport' and SI_REPORT_ENGINE_TYPE = 1

Keywords

CR, CRFE, CR4E, CR for Enterprise , KBA , BI-RA-CRE , Crystal Reports for Enterprise , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016