Learn to create, format, and customize reports using SAP Crystal Reports 2011 / 2013 in this comprehensive tutorial series. Master connecting to various data sources, including SAP HANA, SAP ERP, OLAP, Excel, and text files. Explore techniques for sorting, grouping, and filtering data, as well as creating formulas, variables, and conditional formatting. Discover how to design visually appealing reports with charts, crosstabs, and graphics. Practice sharing and publishing reports to the BI platform, and learn to use advanced features like cascading prompts, subreports, and alerts. Gain proficiency in optimizing report performance and leveraging the semantic layer for efficient report design.
Overview
Syllabus
Create a connection to SAP HANA using ODBC drivers: Crystal Reports 2011.
Connect to an SAP ERP Data Source: Crystal Reports 2011.
Connect to an OLAP Data Source and Create an OLAP Grid Report: Crystal Reports 2011.
Connect to an Excel Spreadsheet or a Text File: Crystal Reports 2011.
Create a Hyperlink to Open a Document on the BI Platform: Crystal Reports 2011.
Concept - What's New in SAP Crystal Reports 2011.
View the data for a field: Crystal Reports 2011.
Sort records using a sort control: Crystal Reports 2011.
Use variables in a formula: Crystal Reports 2011.
Position objects using guidelines: Crystal Reports 2011.
Create a summary report: Crystal Reports 2011.
Show the top or bottom N records: Crystal Reports 2011.
Sort the records: Crystal Reports 2011.
Share report objects using the Repository Explorer: Crystal Reports 2011.
Change the data source location: Crystal Reports 2011.
Select groups based on a summary: Crystal Reports 2011.
Select the data that appears: Crystal Reports 2011.
Save a Crystal report to the BI platform: Crystal Reports 2011.
Save a snapshot of a Crystal report: Crystal Reports 2011.
Save a Crystal report: Crystal Reports 2011.
Resize, move, and align fields: Crystal Reports 2011.
Refresh the data in Crystal Reports: Crystal Reports 2011.
Publish an object package to the BI platform: Crystal Reports 2011.
Prompt for a value to select records: Crystal Reports 2011.
Prompt for multiple values to select records: Crystal Reports 2011.
Group records based on a prompt value: Crystal Reports 2011.
Prompt for a DateTime range to select records: Crystal Reports 2011.
Create a cascading prompt to select records: Crystal Reports 2011.
Preview a Crystal report: Crystal Reports 2011.
Link data source tables: Crystal Reports 2011.
Add a line or box to a Crystal report: Crystal Reports 2011.
Group records based on data: Crystal Reports 2011.
Group records based on a custom definition: Crystal Reports 2011.
Change the formatting of a subreport: Crystal Reports 2011.
Change the formatting for a report section: Crystal Reports 2011.
Format fields: Crystal Reports 2011.
Customize an existing formatting style: Crystal Reports 2011.
Change the formatting of a crosstab: Crystal Reports 2011.
Change the formatting of a chart in Crystal Reports: Crystal Reports 2011.
Export a Crystal report: Crystal Reports 2011.
Embed database fields into a text object: Crystal Reports 2011.
Edit the formula for record selection: Crystal Reports 2011.
Add document information fields: Crystal Reports 2011.
Display the prompt value used to select records: Crystal Reports 2011.
Create a project in the Workbench: Crystal Reports 2011.
Create a report template without a data source: Crystal Reports 2011.
Create a subsection: Crystal Reports 2011.
Create a running total: Crystal Reports 2011.
Create a formula to change text: Crystal Reports 2011.
Create a formula to calculate a time interval: Crystal Reports 2011.
Create a formula to calculate numbers: Crystal Reports 2011.
Create a formula: Crystal Reports 2011.
Create a crosstab using the Crosstab Wizard: Crystal Reports 2011.
Create a crosstab: Crystal Reports 2011.
Create a conditional formula: Crystal Reports 2011.
Create a chart for summary data: Crystal Reports 2011.
Create a chart for detail data: Crystal Reports 2011.
Create a Boolean formula: Crystal Reports 2011.
Create an alert: Crystal Reports 2011.
Copy the formatting of an object: Crystal Reports 2011.
Connect to an XML data source: Crystal Reports 2011.
Connect to a web service: Crystal Reports 2011.
Connect to a universe: Crystal Reports 2011.
Connect to an SAP BW data source: Crystal Reports 2011.
Connect to an ODBC data source: Crystal Reports 2011.
Conditionally format data using the Highlighting Expert: Crystal Reports 2011.
Conditionally format a report section: Crystal Reports 2011.
Conditionally format data using the Format Editor: Crystal Reports 2011.
Conditionally format cells in a crosstab: Crystal Reports 2011.
Concept - Share report objects with other designers: Crystal Reports 2011.
Concept - Describe how the semantic layer works: Crystal Reports 2011.
Concept - Navigate the interface: Crystal Reports 2011.
Concept - Create a Crystal report: Crystal Reports 2011.
Change the layout of the interface: Crystal Reports 2011.
Change the grouping order: Crystal Reports 2011.
Calculate totals and subtotals for data: Crystal Reports 2011.
Apply a report template: Crystal Reports 2011.
Add a watermark: Crystal Reports 2011.
Add text: Crystal Reports 2011.
Add a Flash object to a report: Crystal Reports 2011.
Add a hyperlink to a report: Crystal Reports 2011.
Add a graphic to a report: Crystal Reports 2011.
Add fields to a report: Crystal Reports 2011.
Add an existing report as a subreport: Crystal Reports 2011.
Add a dynamic graphic: Crystal Reports 2011.
Add a calculation to a crosstab: Crystal Reports 2011.
Taught by
SAPAnalyticsTraining
