1419692 - Row security filtering based on CurrentCEUserName is not working in Crystal Reports

SAP Knowledge Base Article - Public

1419692 - Row security filtering based on CurrentCEUserName is not working in Crystal Reports

Symptom

  • Report returns no data.
  • In Crystal Reports, report connected to a Business View with row-level security based on the CurrentCEUserName does not return any data. 

Environment

  • Crystal Reports 2008
  • Business Objects Enterprise XI 3.1
  • Business View Manager XI 3.1

Reproducing the Issue

  1. In the Central Management Console, create a new username with a short username (3 characters long)
  2. Add the username to Administators Group
  3. In the Business View Manager, create a Data Connection for XTREME database, "Customer" table
  4. Add a data Foundation based on Data Connection above.
  5. Add a "BOUser" formula to the Data Foundation as following: CurrentCEUserName
  6. Create a new Business Element add some fields like CustomerName and add BOUser formula
  7. Create a Business View
  8. Open Crystal Reports, login to Enterprise as "Administrator" and connect to the Business View created above
  9. Add some fields including BOUser
  10. Refresh the report
  11. BOUser truncates the value and shows "Adm" instead of "Administrator"

Cause

  • The Business View filter was created while logged in to Enterprise with short user name, and causes any other user name to truncates.
    For example: If the user name is 3 characters long, then all CurrentCEUserName values get truncated to 3 characters length.
  • This is a known issue that has been tracked under ADAPT01343741

Resolution

  • There is no product update that resolves this issue.
  • To workaround the issue, follow the steps below: 
    1. Login as "Administrator" while applying a filter and it will reserve at least 13 characters long CE username; or
    2. Create an Enterprise user with the longest possible length and use it when applying row security.  

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03