55118: Creating SAP Crystal Reports with Visual Studio for Developers Training

This module explains how to install and configure SAP Crystal Report for Visual Studio in Visual Studio 2013 and create first report.

What is SAP Crystal Reports for Visual Studio

Connecting to SQL Server data sourc

Lab1: Preparing Visual Studio for Reporting

Installing SAP Crystal Reports for Visual Studio

Connecting to a SQL data source

After completing this module, students will be able to:

Describe the key feature of SAP Crystal Reports for Visual Studio

Describe the integration with Visual Studio 2013

Connecting to a data source from Visual Studio

This module explains how to create a report using core functionalities of SAP Crystal Reports for developer with Visual Studio 2013.

Create basic report

Create table

Create Chart

Create Grouping

Report formatting

Use Section

Lab1: Authoring a Report

Create Basic Report

Create Crosstab Report

After completing this module, students will be able to:

Describe the key features for creating report with SAP Crystal Reports for developer

Using table, chart, grouping for reporting

Formatting a report

This module explains how to integrate report using Report Viewer with Windows, ASP.NET and WPF applications.

Using Web Report Viewer

Lab: Integrating Report with Applications

Using Report Viewer in ASP.NET

Generating Report in Code

After completing this module, students will be able to:

Using Report Viewer

Integrate reports with ASP.NET applications

Integrate reports with MVC applications

This module explains how to enhance report with advanced functionalities in SAP Crystal Reports for developers and Visual Studio 2013

Use filtering and parameter

Use formula fields

Use Subreport

Use Summary

Use Running Total

Use Sorting

Use Barcode

Lab1: Advanced Report Authoring

Using Summary and Running Total

Using Subreport

Using Formula

Using Parameter and Filtering

After completing this module, students will be able to:

Using Parameter in report authoring

Using Drilldown in report authoring

Using Subreport in report authoring

Using Cross Tab in report authoring

Using Barcode in report authoring

This module explains how to connect report to dfferent kind of data source using different methods that fit the need of the applications

Using Dataset

Using SQL Command

Using LINQ

Using Web Services

Using Link Tables

Lab: Advanced Data Access

Using Dataset

Using SQL Command

Using LINQ

Using Link Table

After completing this module, students will be able to:

Describe connecting report to different data sources

Using Stored Procedure in report

Using LINQ objects in report

Using web services in report

Using Link Table

This module explains how to data report to different kind of format.

Exporting Data with Crystal Report

Export Using Report Viewer

Exporting with Code

Lab: Exporting Data

Export to HTML with Options

After completing this module, students will be able to:

Describe export report to different data sources

This module explains how to troubleshoot some of the common report authoring issues.

Troubleshooting Field and Text

Troubleshooting Record Selection Formulas

Lab1: Troubleshooting and Debugging Report

Disable Field Clipping

Enhance Formula for Selection

After completing this module, students will be able to:

Describe common issues in report authoring