2293335 - Current CE User Name not passed to the Stored Procedure parameter BOUSER, when refreshing a report in Crystal Reports

SAP Knowledge Base Article - Public

2293335 - Current CE User Name not passed to the Stored Procedure parameter BOUSER, when refreshing a report in Crystal Reports

Symptom

  • User name not sent to the stored procedure.
  • The name of the user logged to the SAP BI Repository, not passed to the stored procedure parameter.
  • When refreshing a report in Crystal Reports and the user is logged in to the SAP BusinessObjects Repository, the Current CE User Name is not passed to the stored procedure parameter: BOUSER.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. In Crystal Reports, create a Stored Procedure with a string parameter called: BOUSER   
    Note: BOUSER is a reserved name in Crystal Reports to pass the Current CE User Name.
      
  2. Create an ODBC connection to the database where the stored procedure is created.
       
  3. In Crystal Reports, logon to the SAP BusinessObjects Repository.
       
  4. Create a new report off the stored procedure created in step 1, using an ODBC connection.
       
  5. When refreshing the report, it will not prompt for the parameter BOUSER, which is expected, but it will not pass the name of the user logged on the SAP BusinessObjects Repository.
      

Cause

  • This issue has been tracked under SAP Note 2010107

Resolution

  • The issue has been resolved in the following product updates:
         
    • Crystal Reports 2008:
      • Service Pack 6 - Fix Pack 5
      • Service Pack 7 - Fix Pack 2
      • Service Pack 8 and above
              
    • Crystal Reports 2013:
      • Support Pack 05 and above
           
             
  • To workaround this issue, create a subreport off the stored procedure, and link the Current CE User Name, to the subreport stored procedure parameter:
         
    1. In Crystal Reports, create a new report off any data source that returns at least one record.
        
    2. Suppress all the sections except the Page Header, Report Footer, and Page Footer.
                   
    3. Create a formula to capture the name of the user logged in to the SAP BusinessObjects Repository. The formula will be:
                
          CurrentCEuserName
               
    4. Insert in the Report Footer of the main report, a subreport off the stored procedure to which you will like to pass the current user name to it's parameter.
             
    5. Link the subreport stored procedure parameter, to the main report formula created in step 2. This will be passing the name of the user currently logged in to the SAP BusinessObjects Repository to the stored procedure parameter.

Keywords

CR, Stored Proc, CR BOUSER, bouser parameter  , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013