Please wait
Contact
Contact

Contact us

Start now!

Please mail to info@cloudiax.com or call us +49 2822 7131 600

The personal information you send us is important to us. Therefore we take the protection of this data very seriously. The data transmitted here will be used by our sales team to contact you. We will use this data only for this purpose and delete it after the end of the contact, unless higher rights preclude this. Everything what we do to protect your data can be found in our privacy policy.

Please check the Captcha

Register here to receive more
information about Cloudiax!

hello, how can we help?

Please search only in English

Print version

Change data source location of Crystal Reports

Change the location of the data source location of Crystal Reports in HANA by selecting or choosing the database.

Category: Crystal Reports,

1. Start  SAP Crystal Reports.

2. Click on „Set datasource location“.

Set Datasource Location

3. Select in the lower section below „Create new connection“ and click on the plus sign next to the ODBC (RDO) folder.

Create New Connection

4. In the window “ODBC (RDO)” click into the field next to “Connection String” and enter following string:

DRIVER={B1CRHPROXY32};UID=XXX_USERNAME;PWD=XXX_PASSWORD;
SERVERNODE=XXX_HANA_SERVER:30015;DATABASE=XXX_DBNAME

If you want to add your db, you have to edit the string and replace xxx_DBNAME with your Number and name of the Database.

Afterwards click on “Finish”.

Connection String

5. In the new login window please enter the provided credentials of the database user.

Provided Credentials

6. Select the new created Connection, select the connection of the Current Data Source e.g. sv-ger-phana12:30015 and click “Update”.

Current Data Source

7. After a few seconds the “Current Data Source” will be get update, afterwards click on “Close”.

Data Source

8. Click Save.

Click Save

9. Confirm Operation as succeeded in Crystal Reports.

Confirm Operation

10. Test report e.g. AR Invoice.

Test Report

Share