SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports.
The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
To create a query in Universe you can choose both OLAP and Relational data sources.
First step in a query design is to define objects that you want to add in your query. You can also refine your query by applying sorts and query filters. Query panel is divided into multiple panes
Time based query filters are used to filter the value of specific objects between certain periods of time. When you add a date dimension to query filter, you can use between operators from drop down list to specifically mention to and from date.
Field objects controls are used to edit the object in the report. To edit the object, you can right click on the object name and select Format result Object Element or Conditional Formatting option as shown in the following image.
Open Section expert at the top and select the section you want to delete → enter Delete.
You can only delete the section if they are lettered. You cannot delete sections originally provided by Crystal Reports.
When you need to separate the data into groups in order to make it easily understood, grouping option can be used.
You can also customize grouping for a single value or multiple values by using the customize option inside the grouping tab.
You can use the following 3 options while customizing a group in Crystal Reports −
Discard everything else
Group everything else in a single group with a group name
Include everything else without changing the group name
Instead of creating a report from scratch, you can also use inbuilt templates from the report repository. These report templates provide predefined layout for common documents like purchase orders, invoices, letter templates, etc.
Cross tab is used to display the data that is grouped or totaled in two directions. It shows data in a compact format, which makes it easier to understand and see the trend in the data. For example, if you want to see the quantity sold by the customer in a particular region, without cross tab, it shows the data in a spwatch-out form.
Formulas are used to insert data in the report that does not exist with any of the objects. If there is a need to perform some calculations or to add specialized data in the report, you can use formulas
To write a conditional formatting formula, right-click the report and click Format Result Object element → select the property on which you want to apply conditional formula → click and it will open formula workshop.
A Variable is used to assign different values to an object unlike constant which is fixed. When you assign a value to a variable, it maintains that value till you assign a new value to it. Before using variables, it is necessary to define them in a report.
Parameters are used to take user inputs before the report is generated. User has to answer the prompt before the report is generated and the report output depends on the response of the user for the parameter value.
While creating parameters, two types of prompt options can be used.
Prompt to user will create a prompt for the user to enter the value of parameter.
Hidden Prompt will be used to pass some initial values or values by formula and not by the user.
Subreports allow you to combine unrelated reports into a single report. It is a report within a report. You can combine data that cannot be linked and present different views of the same data in a single report.
Finished Crystal Reports can be exported to a number of formats like XML, HTM, PDF, spwatchsheets and word processors and other common data interchange formats. This allows Crystal Report to use and distribute in an easy way
Microsoft Excel (97-2003) Data-Only is a record-based format that concentrates on the data. This format does export most of the formatting, however, it does not merge cells, and each element is added to only one cell.