{"id":54126,"date":"2019-04-19T14:46:38","date_gmt":"2019-04-19T09:16:38","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=54126"},"modified":"2021-12-05T21:29:26","modified_gmt":"2021-12-05T15:59:26","slug":"connect-crystal-reports-with-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/","title":{"rendered":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps"},"content":{"rendered":"

SAP Crystal Reports is a windows-based tool used for creating reports<\/em> for the purpose of printouts and publishing such as sales invoice, sales orders report, etc.<\/p>\n

In this tutorial, we will learn the process to directly connect SAP Crystal Reports with the SAP HANA database using appropriate drivers. Then, we will use the data in Crystal Reports to create our reports.<\/p>\n

We assure you that by the end of this article, you will understand the process thoroughly and will become a master in connecting crystal reports with SAP HANA.<\/p>\n

\"Steps<\/a><\/p>\n

Crystal Reports and SAP HANA<\/h3>\n

SAP Crystal reports is popular because of its crystal clear and pixel perfect visuals. It uses JDBC\/ODBC connectors<\/strong> and SQL as interaction language<\/strong> to connect to the SAP HANA database.<\/p>\n

Now, let’s jump to the process to connect Crystal Reports 2011\/2013\/16 with\u00a0SAP HANA. The nature of the connection is a direct OLAP connection.<\/strong><\/p>\n

Steps to Connect Crystal Reports to SAP HANA<\/h3>\n

Step 1:<\/strong> Launch SAP Crystal Reports<\/em> 2011\/13\/16 in your system.<\/p>\n

The main page of SAP Crystal Reports will open.<\/p>\n

Step 2:<\/strong> Now, you can either use an available connection to connect to SAP HANA or you can create a new connection. We will create a new one.<\/p>\n

Creating Reports in Crystal Reports<\/h4>\n

Step 3:<\/strong> If you are creating a new connection, you can select from different connection options i.e. an ODBC connection, JDBC connection, OLAP, OLE DB, Excel, Salesforce.com or can connect through a Universe. Select your preferred connection method and click on Next<\/strong>.<\/p>\n

In the next dialog, select the option \u201cSelect Data Source<\/strong>\u201d and choose your data source from the drop-down list of Data Source Name. Click Next.<\/p>\n

Step 4:<\/strong> Enter the User ID<\/strong>\u00a0and password<\/strong>. Click on Finish<\/strong>.<\/p>\n

Step 5: Data Sources<\/strong><\/p>\n

Once the connection is established, a Standard Report Creation Wizard will open.<\/p>\n

Here, you will find a list of available data sources (schemas in SAP HANA<\/strong>) having tables, views, stored procedures<\/strong><\/em>\u00a0from the selected data source.<\/p>\n

Select the schema of your choice by clicking on its name. This will expand the node and show contents within that schema such as Tables, Views, Stored Procedures, etc.<\/p>\n

If you want to select tables then open the Tables<\/strong> node and select the tables of your choice. Add them by clicking on the table name and then clicking on > icon.<\/p>\n

This will add the tables in the\u00a0Selected Tables<\/strong> section in the Standard Report Creation Wizard<\/em>. Click Next<\/strong> when you have selected all the required tables and views from the schema.<\/p>\n

You can select a table from the list of tables.<\/p>\n

Step 6: Linking<\/strong><\/p>\n

Here, we see the fields of the tables and the nature of join between them.<\/p>\n

You can also change the join type by clicking on the join made between the selected tables. A tab named Link Options will open from where you can select the Join Type, Link Type and the option of Enforced Join. Then click on OK<\/strong>.\u00a0<\/strong><\/p>\n

Step 7: Fields Selection<\/strong><\/p>\n

Next, you have to select fields from the available table or the tables that you selected from the data source. The names of all the fields are provided under the\u00a0Available Fields<\/strong> section.<\/p>\n

Click on the fields that you want to add. Add them into Fields to Display<\/strong> section by using ><\/strong> icon. You can also rearrange the order of the fields from the up and down arrows.<\/p>\n

Click on Next<\/strong> once you are done with selecting all the fields to be displayed.<\/p>\n

Step 8: Grouping<\/strong><\/p>\n

Next, you can apply a grouping criterion on the selected fields. You can select a number of fields as the basis of grouping. Add the fields from Available Fields<\/strong> to Group By<\/strong> area using ><\/strong> icon.<\/p>\n

You can also browse the data from the selected field and select whether to group and display the values in ascending or descending order.<\/p>\n

Click on Next<\/strong> to continue.<\/p>\n

Step 9: Summaries<\/strong><\/p>\n

The next window gives you a default list of summarized fields which are mostly integer fields. You can add or remove fields at this step.<\/p>\n

Click Next<\/strong> if you don\u2019t wish to make any changes.<\/p>\n

Step 10: Group Sorting<\/strong><\/p>\n

You can sort your grouped data based on three conditions; None<\/strong>, Top 5 groups<\/strong> and Bottom 5 groups.<\/strong><\/p>\n

Also, you have an option for Comparing summary values for the Top or Bottom groups.<\/p>\n

Step 11:<\/strong>\u00a0\u00a0Chart<\/strong><\/p>\n

In the final step, you get to select from three standard chart types<\/strong> in which you wish to visualize the data. The available chart types are line chart, pie chart and bar chart.<\/strong><\/p>\n

You can also go with No chart<\/strong> option. You also get to manage the chart from the options Chart title, On change of<\/strong>\u00a0and Show summary<\/strong>.
\n<\/strong><\/p>\n

Click on Finish.
\n<\/strong><\/p>\n

Step 12:\u00a0<\/strong>We finally have our report ready with the charts and tables we selected to be displayed. You can perform a range of manipulations and analytical operations on the dataset from the reporting interface.<\/p>\n

You can apply more advanced features and make different types of visualizations using the data.<\/p>\n

Summary<\/h3>\n

We hope our explanation to connect Crystal Reports with SAP HANA was helpful. In the next tutorial, we will discuss connecting Crystal Reports Enterprise 4.x to SAP HANA. If you have any queries or feedback for us, you can enter in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

SAP Crystal Reports is a windows-based tool used for creating reports for the purpose of printouts and publishing such as sales invoice, sales orders report, etc. In this tutorial, we will learn the process...<\/p>\n","protected":false},"author":6,"featured_media":54698,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19513,19514],"class_list":["post-54126","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-connect-crystal-reports-to-sap-hana","tag-crystal-reports-and-sap-hana"],"yoast_head":"\nHow to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn to connect Crystal Reports 2011\/2013 with SAP HANA through direct OLAP connection using JDBC\/ODBC connectors and SQL as query language. Explore now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn to connect Crystal Reports 2011\/2013 with SAP HANA through direct OLAP connection using JDBC\/ODBC connectors and SQL as query language. Explore now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-19T09:16:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T15:59:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps - DataFlair","description":"Learn to connect Crystal Reports 2011\/2013 with SAP HANA through direct OLAP connection using JDBC\/ODBC connectors and SQL as query language. Explore now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps - DataFlair","og_description":"Learn to connect Crystal Reports 2011\/2013 with SAP HANA through direct OLAP connection using JDBC\/ODBC connectors and SQL as query language. Explore now!","og_url":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-19T09:16:38+00:00","article_modified_time":"2021-12-05T15:59:26+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps","datePublished":"2019-04-19T09:16:38+00:00","dateModified":"2021-12-05T15:59:26+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/"},"wordCount":879,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg","keywords":["Connect Crystal Reports to SAP HANA","Crystal Reports and SAP HANA"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/","name":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg","datePublished":"2019-04-19T09:16:38+00:00","dateModified":"2021-12-05T15:59:26+00:00","description":"Learn to connect Crystal Reports 2011\/2013 with SAP HANA through direct OLAP connection using JDBC\/ODBC connectors and SQL as query language. Explore now!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Connect-Crystal-Reports-with-SAP-HANA.jpg.jpg","width":802,"height":420,"caption":"Steps to Connect Crystal Reports with SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/connect-crystal-reports-with-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"How to Connect Crystal Reports (2011\/2013) with SAP HANA in 12 Steps"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=54126"}],"version-history":[{"count":28,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54126\/revisions"}],"predecessor-version":[{"id":105062,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54126\/revisions\/105062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/54698"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=54126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=54126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=54126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}