Skip to main content

Advanced Features

Crystal Reports

Crystal Reports is an application from SAP for creating reports. This application requires Crystal Reports and must therefore be downloaded from SAP.

Here you can download the official documentation for Crystal Report:

💡
A license is required to create reports in Crystal Reports

Import CRDataSet.xml

To have all fields in the Crystal Report available for selection, we must first add the G_DATA\RPT\CRDataSet.xml:

  1. Open Crystal Reports
  2. In Field Explorer, right-click on Database Fields and select Database Wizard
  3. Create a new connection and select ADO.NET (XML)
  4. Enter the path to CRDataSet.xml and press Finish
  5. Now there should be a new object called NewDataSet under My Connections
  6. Select this object and select all (move to the right)
  7. Click OK and then all fields should be visible under Database Fields (in Field Explorer)
  8. Place fields on the report
Open Database Wizard
Create new DataSet

Reimport CRDataSet.xml

If there are problems with the report or new fields are added in CRDataSet.xml, then you should add and place all fields again:

  1. Remove all fields
  2. Delete all existing data sets
  3. Link new CRDataSet.xml
  4. Select current data set and add fields

To link images to the report with a variable from CRDataSet.xml, you can do the following:

  1. Select the graphic and right-click and select Format Graphic
  2. Then go to Image and select Formula Format Editor under Storage Location
  3. Insert the variable that contains the path to the image
Edit Image

Test Report

Here you can download a test report to start creating the report: