PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

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.

Also read:

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.

Also read:

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

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , ,