This blog post is for those who are interested in learning how to develop reports with the Crystal Reports (CR) desktop designer (e.g. CR 2013) against the SAP HANA database. If you already have a copy of Crystal Reports then you can start using the SAP HANA Cloud Platform (HCP) Development Edition, as a development platform and database, for free. If you don’t have a copy of CR and just want to try this out anyway, there’s still the 30 day free trial for Crystal Reports here.

 

Using HCP you can have your own free and secure SAP HANA schema that is located on a shared environment. Since it is a shared environment and your schema is secured you don’t need to worry about any maintenance or security tasks and can focus on learning things like HANA SQL instead. You can also use the same HCP developer account to create and run web applications.

 

Untitled.jpg

 

To get started you need to register for an HCP developer license (free) here. Afterwards there’s some setup of the tools (also free) to connect to HCP including HANA Studio. The Eclipse-based Studio will be the management tool that you will use to load your data into your HANA database schema. Below is a video on getting set up.

 

 

Once you’ve got the HCP tools and HANA Studio set up, you will want to access and then add some data to your HCP development schema.

 

 

In order to get connected from your Crystal Reports designer to your schema via ODBC, you’ll need to download and install the 32 bit HANA Client.

 

  • Go to go.sap.com and then choose Developer > Trials Downloads > which should take you to here https://www.sap.com/developer/trials-downloads.html
  • Scroll down until you see SAP HANA Client Software Packages and click on the Download link
  • Click on the large Trial Version button and you’ll be taken to a dialogue to fill in your company info
  • You’ll receive a link in your email that will take you to download location on the sap store and there you can get the version of the Client that you want

 

After you’ve downloaded and installed the Client you will need to tunnel into your schema via the SDK Command Line Tool.

 

 

Now there’s just one last task in connecting to your HCP schema via a ODBC. Please see the video below.

 

 

Now that you’ve got your free license for HCP, installed the tools, added some data and connected to your schema, you can now start to develop reports against SAP HANA. Here are some more resources to get you started and keep you going on this activity:

 

  1. For a playlist of HANA Basic SQL to help you write your Command objects in Crystal please see here.
  2. For a playlist of HANA SQL Functions, also to help you write your Command objects, please see here.
  3. For more videos on using Crystal Reports against SAP HANA as a data source please see this playlist.
  4. For further information or questions on the HANA Cloud Platform please see the SCN forum for HCP.
  5. For a guide on HANA SQL please visit SAP’s help site for HANA and scroll down to Reference Information and then SAP HANA SQL and SQLScript References or click here. Please note though that the latter link is subject to change.
  6. Check out my other blog posts that feature some HANA SQL some with sample reports against HANA.
  7. For even more HANA videos on many different topics please visit the SAP HANA Academy.

 

If you would like to see some further content using Crystal Reports with SAP HANA please contact the SAP HANA Academy.hanaacademy@sap.com

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. anitha ediga

    Excellent  ,Great Job Jamie.

    Would love to see more on SAP HANA and Crystal  related to  multiple DB for Banking.

    Thanks for sharing .

    (0) 
  2. Matt Rhoades

    The link to download the 32-bit HANA Client as referenced above does not work and I can’t find it anywhere else.  Can someone please update this page with valid links, or just tell me where I can download the 32-bit HANA Client?

    (0) 
  3. Matt Rhoades

    The link seems good, by when I click the “Agree and Download” button, it briefly says “Please be patient, your download will start in a few seconds”,  then it just jumps to the SAP Store home page.   Tried it in IE, Chrome and Firefox.  It does the same thing in all 3 browsers…

    (0) 
  4. Jamie Wiseman Post author

    hello all, if you’re looking to get the ODBC driver for HANA (via the Client Tools) then they’re available by following these steps:

    • Go to go.sap.com and then choose Developer > Trials Downloads > which should take you to here https://www.sap.com/developer/trials-downloads.html
    • Scroll down until you see SAP HANA Client Software Packages and click on the Download link
    • Click on the large Trial Version button and you’ll be taken to a dialogue to fill in your company info
    • You’ll receive a link in your email that will take you to download location on the sap store and there you can get all of the options of the Client

     

    (0) 

Leave a Reply