cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
While Sisense provides powerful analytics and simple report printing, if pixel perfect report printing is required, additional tools like SAP Crystal Reports must be used.
Purpose/Benefit
Pixel Perfect reports can be designed which use data from a Sisense Elasticube. These reports contain all Crystal Reports features including exact control of size and position of report elements, headers, footers, etc.
Prerequisites
Sisense and Crystal Reports have been installed. Knowledge of how to design Crystal Reports.
Steps

Step 1 - Set up ODBC Connection to an existing Elasticube

Follow these instructions to set up an ODBC connection to one of your Elasticubes. For our purposes, we will create a connection to our Sample Healthcare Elasticube (Included with Sisense install). We will name the connection "Sisense Healthcare Sample".
Note: You must install the 32-bit driver since Crystal Reports uses 32-bit architecture. When setting up your connection, you must do this in ODBC Data Sources (32-bit).

Step 2 - Create a new blank report in Crystal Reports and pull in data

In the Database Expert dialog box expand the "Create New Connection" selection.
Expand the "ODBC (RDO)" section. A dialog box should pop up.
Select the Sisense Sample Healthcare data source and click finish.
Select the tables you will be using for your reports and click the '>' button to add them to the Crystal Reports data model (you may only need a couple tables for a particular report).
Link the tables needed for your report and click OK.

Step 3 - Build your report

You can now access data from the Elasticube to build a Crystal Report!

Step 4 (optional) - Embed Crystal Report into Sisense Dashboard

Referring to the following links, you may embed a crystal report into a Sisense Dashboard or export a pixel perfect reprt to PDF from a dashboard:
ReCrystallize Pro - Allows viewing of Crystal Reports in a web browser
Jump To Dashboard Plugin - Includes different configurable options for pop ups or links
 
Attached is the sample Crystal Report which loads from the included Sample Healthcare Elasticube.
Download:
Version history
Last update:
‎03-02-2023 09:45 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy