PT Sterling Tulus Cemerlang

+62 (21) 580-6055


Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

SAP Table as Crystal Report Data Source on HANA Version

SAP Tables as Data Source on SAP HANA

Everyone usually knows a common method for crystal report data source is using “Add command” feature.

Now, we’ll explain another method to do the same thing on HANA version, so if you want to know a SQL version, please read our previous article here.

These steps are how to get Table, View, or Stored Procedure as Data Source just like in SQL Database.
Picture  1:

  • Step 1 :
    Choose ODBC (RDO) as New Connection
  • Step 2 :
    Choose Enter Connection String ( Click on the button, default is Select Data Source on upper side picture)
  • Step 3 :
    Enter Connection String, with this format
    DRIVER={B1CRHPROXY32};SERVERNODE=SERVER_NAME:30015;DATABASE=DB_NAMESERVER_NAME can be replace with Server Name or Server IP, and DB_NAME replace with Database Name or Schema Name.

Picture 2:

Step 1 : Fill the Server field with server name and port :30015, with format SERVERNAME:30015
Step 2 : USER ID field, must be filled with SYSTEM
Step 3: Password field must be filled with SYSTEM’s Password

Finally click Finish to Finalize, if there’s no error popped up then proceed to Picture 3.

Picture 3:

After succesfully create the connection command, new connection will be appeared as of the connections.

Picture 4:

Proceed to choose Tables, View, or Stored Procedures as one of your Data source for Report or Form Layout. The rest of the step to use tables as Data source totally the same as in SQL Database.

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, , , ,