SAP - BI
What is Write Optimized DSO in SAP? How to Create One?
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
SAP Crystal Reports is a BI tool for generating analytical reports from SAP and other non-SAP data sources like Oracle, SQL Server, MySQL, XML Data Source, Microsoft Excel, etc. The knowledge of this tool helps businesses to develop advanced level reports and take accurate and profitable business decisions based on these reports.
In this SAP Crystal Reports tutorial for beginners, you will learn Crystal Reporting basics:
Here, are benefits/pros of using SAP Crystal Reports:
Now in this Crystal Reports Tutorial, we will learn about components of Crystal reports:
The Report Design Canvas helps you to design the structure of your report. You can include different elements like charts, test, data objects in the reports.
Rules option displays a rule above the report canvas. However, the tool allows you to change the unit of measurement by changing the unit option on the design canvas tab.
Structure mode and Page mode helps you to define the layout of the reports. Each object in the structure mode is represented by a frame.
Important components of structure mode are given below:
Component Name | Details |
Report Header | It is used for adding Report title at the top or any other information you want to add at the starting of the report. |
Page Header | Page header is used to present information at the top of each page. Header section generally includes document heading, chapter name, etc. |
Page Footer | Use to present page numbers or any other information at the end of each page. |
Body | This section displays the body of the report. All report data should be included in this section. |
Page Mode | Page mode view represents the actual data in the report when the report will be published or printed. |
Crystal Report helps you to connect to multiple data sources, which include:
Step 1) How to connect to the Data source,
Go to File -> New -> From Data Source
To select a data source, you must connect to the SAP Business Objects platform server.
File -> New -> From Data Source -> Choose a data source connection dialogue box appears -> Browse Repository -> Data Source Type list -> Select data source you want to connect -> Next.
SAP Crystal Reports is used to extract custom analytical reports from various data sources. Crystal Reports also help businesses for creating a database reporting environment to access data, format data, view the data, and integrate the reports with various applications to make it available for all the users in the organization.
Crystal Reports for enterprise offers an interface which allows you to create, format, and publish effective reports. The menu bar of crystal reports provides wide ranges of features shown in the following image.
The insert tab helps you to insert an object into your reports like text, line, box, groups, sections, pictures, and charts.
The Format tab helps you to use functions for formatting the selected file like changing the size or font and background color, alignment of text to center, left, right, etc.
Crystal reports support conditional formatting, like highlighting values above or below a particular value in the report.
When selecting a conditional formatting option at the top right corner, select the formatting box. In this box, you can give condition under which you want conditional formatting to appear.
Here, are drawbacks/cons of using Crystal report.
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
What is Sequence? A sequence is a database object that automatically generates the incremented list of...
Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data...
What is an Instance? Sap Instance is a group of resources such as Memory Work Processes Dispatcher...
A standard DSO has three transparent tables on the database. Activation Queue : Holds the records...
There are two types of goods movement against production order which impacts the inventory of the...