SAP Knowledge Base Article - Public

2769676 - How to retrieve the user name used to connect to HANA in Crystal Reports?

Symptom

  • How ro display the user name used to logon the HANA database on the report?
  • The following SQL Query does not display the user name: Select session_context('APPLICATIONUSER') from DUMMY 
  • How to display the database user name used to connect to HANA in Crystal Reports?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
         
  • HANA database version: 1.00
  • HANA Client 1.00

Reproducing the Issue

  1. Create new report in Crystal Reports.
  2. Select ODBC connection to HANA database.
  3. Double click on "Add Command", and add the following SQL Query:
      
        Select session_context('APPLICATIONUSER') from DUMMY
          
  4. Refresh the report.
          
    Notice the report does not dispay the HANA User Name used to connect to the database on the report.

Cause

  • The HANA database user name does not display on the report because the specific HANA ODBC Driver version 1.00 does not return the user name. It is an ODBC driver issue.

Resolution

  • Use the HANA ODBC Driver version 2.00 and above.
             
  • Download and install HANA Client 2.03 from the following file: IMDB_CLIENT20_003_134-80002084.SAR in the SAP Software Download Center.

See Also

  2480232 - Crystal Reports crashes when selecting an existing ODBC connection to HANA

Keywords

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

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016