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

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

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

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.
     

• This issue has been tracked under SAP Note 2010107

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

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