Turn information from almost any data source into a sophisticated, interactive report – with report design software, SAP Crystal Reports. This powerful, user friendly application can help you deliver key insights for smarter operational and strategic decision making.
- Design formatted reports with Flash integration, interactive charts, and flexible export options
- Deliver reports via the Web, email, Microsoft Office, or embedded in applications
- Empower end users to explore reports with on-report sorting and parameters
- Minimize ongoing IT and developer involvement with interactive reports
About Crystal ReportsCrystal Reports is designed to work with your database to help you analyze and interpret important information. Crystal Reports makes it easy to create simple reports, and, it also has the comprehensive tools you need to produce complex or specialized reports.
Sample dataA sample database, Xtreme.mdb, is available for you to use while you are learning Crystal Reports. Xtreme.mdb is a Microsoft Access database and all of the necessary drivers are included. You should be able to open the database directly and begin designing reports. Virtually all of the examples in this manual are based on Xtreme.mdb data. Xtreme.mdb is located on the Business Objects Technical Support web site
The sample data has been designed to illustrate various reporting concepts in a training environment, not to teach database design.
Report Creation WizardsIn this tutorial you will learn how to build a report from scratch. As a complement or an alternative, however, you may want to use the Report Creation Wizards available on the Start Page. There are four Report Creation Wizards:
- Mailing Label
StandardThe Standard Report Creation Wizard is the most generic of the wizards. It guides you through choosing a data source and linking database tables. It also helps you add fields and specify the grouping, summarization (totals), and sorting criteria you want to use. Finally, the Standard Report Creation Wizard leads you through chart creation and record selection.
The Templates screen contains predefined layouts for you to apply to your report to give it more impact.
Cross-TabThe Cross-Tab Report Creation Wizard guides you through the creation of a report in which your data is displayed as a cross-tab object. Two special screens (Cross-Tab and Grid Style) help you create and format the cross-tab itself.
Mailing LabelThe Mailing Labels Report Creation Wizard lets you create a report that is formatted to print on any size mailing label. You can use the Label screen to select a commercial label type, or you can define your own layout of rows and columns for any multi-column style report.
The OLAP Report Creation Wizard lets you create a report in which your OLAP data is displayed as a grid object. Although similar to the Cross-Tab Report Creation Wizard in several ways, the OLAP Report Creation Wizard appears to be different due to the requirements of working with OLAP data sources. You first specify the location of your OLAP data, and then you choose the dimensions you want to include in the grid. Next you filter the report data and choose the style of the grid object, which you can also customize. Finally, you can define labels for your grid and insert a chart, if you wish.