Crystal Reports

Introduction:

What’s new in SAP Crystal reports 2011.

·         Has a new read only format with RPTR format, which can be opened via Crystal reports viewer only.

·         Support export to Excel 2007 workbook format.

·         Crystal reports integration with Visual studio is separated into a new product.

Crystal report is divided into five section on Design tab, where we can design the report and also called as report design canvas, where it displays the structure of the report.

·         Report Header: report title, charts, pictures

·         Page Header: Column names at each page

·         Details: data

·         Report Footer: grand totals

·         Page Footer: Page numbers

 Preview tab display data as per the structure designed.

Repository explorer is used to explore the repository for bitmaps, text object, universes, LOV, SQL commands to avoid the manual distribution on changes to these objects.

Semantic layer: to remove underlying Db technical stuff for the user

Corporate DB (id,name,revenue,dt ) à Semantic layer (PID, person name, person revenue generated, Date)->  Reports.

Universe design tool  is used in semantic layer to classify the data for reporting needs. And save the file as universe.

·         Char data and Date  data -> Dimensions

·         Numeric -> measures

Reports -> Universe-> Corporate DB

ð  Report -> Corporate DB

How to create a report.

ð  Connect to data source: Universe, OLAP cube, relational DB

ð  Add fields: from tables such as customer/ORDERS/SALES tables

ð  Sort/group/summarize data :  filter, sort , Group , summarize the records/data

ð  Add field if required using formuals

ð  Format data : work on look and feel, fields to mark threshold.

ð  Add graphs/charts: work on look and feel

ð  Distribute the report: BI platform, email, pdf