55118 Creating SAP Crystal Reports with Visual Studio for Developers
CLASS DATE(s):
7/1/2020 - 7/2/2020
9/8/2020 - 9/9/2020

COURSE LENGTH: 2 Days

COURSE COST: $895.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This two-day instructor-led course is intended for application developers who are interested in developing client side reports in Visual Studio 2013. In this course, students learn how to install and configure SAP Crystal Reports using Visual Studio 2013. Students then learn how to author a report and integrate with applications developed with Visual Studio 2013.

AUDIENCE AND PREREQUISITES

This course is intended for both programmers who have experience in developing applications with Visual Studio 2013. Experience with developing using Visual Studio 2013
Basic understanding of RDBMS
Basic understanding of application architecture
Basic understanding of .NET framework.

  

Course cost doesn't include the cost of the courseware/student manual. Course to run is subject to a minimum enrollment. For more information, please contact: learn@vtec.org or call 207.775.0244.

COURSE TOPICS:


At Course Completion
Install SAP Crystal Reports for developer for Visual Studio 2013
Create report with Visual Studio 2013
Integrate report with applications developed with Visual Studio 2013
Integrate report wth different kind of data source

Module 1: Preparing Visual Studio for Reporting
What is SAP Crystal Reports for Visual Studio
Connecting to SQL Server data sourc
Lab 1: Preparing Visual Studio for Reporting
Installing SAP Crystal Reports for Visual Studio
Connecting to a SQL data source

Module 2: Authoring a Report
Create basic report
Create table
Create Chart
Create Grouping
Report formatting
Use Section
Lab 1: Authoring a Report
Create Basic Report
Create Crosstab Report

Module 3: Integrating Report with Applications
Using Web Report Viewer
Lab 1: Integrating Report with Applications
Using Report Viewer in ASP.NET
Generating Report in Code

Module 4: Advanced Report Authoring
Use filtering and parameter
Use formula fields
Use Subreport
Use Summary
Use Running Total
Use Sorting
Use Barcode
Lab 1: Advanced Report Authoring
Using Summary and Running Total
Using Subreport
Using Formula
Using Parameter and Filtering

Module 5: Advanced Data Access
Using Dataset
Using SQL Command
Using LINQ
Using Web Services
Using Link Tables
Lab 1: Advanced Data Access
Using Dataset
Using SQL Command
Using LINQ
Using Link Table

Module 6: Exporting Data
Exporting Data with Crystal Report
Export Using Report Viewer
Exporting with Code
Lab 1: Exporting Data
Export to HTML with Options

Module 7: Troubleshooting and Debugging Report
Troubleshooting Field and Text
Troubleshooting Record Selection Formulas
Lab 1: Troubleshooting and Debugging Report
Disable Field Clipping
Enhance Formula for Selection