Crystal Report Masterclass

Crystal Report Masterclass course is designed to provide all the essential understanding and skills to plan and build sophisticated Crystal reports. With the help of the training, the delegates willble to work with cross-tab reports. The training enables the delegates to create visual reports from available data.  At the end of the training, the delegates will able to create effective reports, presentations, integrate reports in a website or application and link multiple data sources using Crystal Reports.

Crystal Reports is a Business Intelligence Application which is used by professionals to design and build business reports efficiently. With the help of Crystal Report Masterclass training, the delegates will able to understand how to work with Crosstabs and Sections.

Start with the Reports

• Introduction to Crystal Reports
• Learning sample data
• Reports and Databases
• Report creation wizard
• Quick start for new users
• Customise the Report settings

Report Design Concepts

• Overview of basic report design
• Deciding the content of the report
• Developing a prototype on paper

Report Creation

• Choosing a Report Creation Method
• Connecting to Data Sources
• Navigating in the Design Environment
• Inserting Objects in a Report
• Previewing a Report
• Saving a Report
• Setting the Position and Size of Objects
• Formatting Objects

Introducing Reporting

• Report creation options
• Selection of data sources and data fields
• Report design environment
• Creating a new report
• Exploring reports
• Working with multiple reports

SAP Business Objects Enterprise Repository

• What is SAP Business Objects Enterprise Repository?
• Repository Explorer toolbar
• Adding items
• Modifying objects
• Updating connected repository objects
• Deleting items from the repository
• Using undo in the repository

Record Selection

• Selection of records
• Formula template usage
• Suppressing Record selection to the database server
• Troubleshooting record selection formulas

Designing optimised Web Reports

• Key strategies for optimising
• Scaling with intelligence platform
• Making the right design choices
• Streamlining reporting environment
• Record selection formula usage

Sorting, Grouping and Summarizing

• Sorting data
• Grouping of data
• Summarizing grouped data
• Subtotaling of data
• Calculating Percentages
• Grouping headers

Multiple Section Reports

• Understanding sections
• Working with sections
• Splitting and resizing sections
• Using multiple sections in reports
• Creating Form letters

Formatting concepts

• Using and applying templates
• Report design environment
• Property formatting
• Working with absolute formatting
• Working with conditional formatting

Running Totals

• Understanding running totals
• Creating running totals
• Using formulas while creating totals

Mapping

• Concept of mapping
• Creation of maps
• Working with maps

Charting

• Concepts of charting
• Creation of charts
• Editing and formatting charts

Integrating Business Development Application with Crystal Reports

• Integrating with SAP
• Integrating with Oracle
• Integration with Siebel
• Integration with PeopleSoft
• Integration with JD Edwards