55118: Creating Report with SAP Crystal Reports for Developer with Visual Studio

55118: Creating Report with SAP Crystal Reports for Developer with Visual Studio

Audience

This course is intended for programmers who have experience in developing applications with Visual Studio 2013.

Prerequisites

  • Experience with developing using Visual Studio 2013
  • Basic understanding of RDBMS
  • Basic understanding of application architecture
  • Basic understanding of .NET framework

Duration

2 days. Hands on.

Course Objectives

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.

After completing this course, students will be able to:

  • 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

Course Content

Module 1: Preparing Visual Studio for Reporting
What is SAP Crystal Reports for Visual Studio
Connecting to SQL Server data source
Lab : Preparing Visual Studio for Reporting
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

Module 2: Authoring a Report
Create basic report
Create table
Create Chart
Create Grouping
Report formatting
Use Section
Lab : Authoring a 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

Module 3: Integrating Report with Applications
Using Web Report Viewer
Lab : Integrating Report with Applications
After completing this module, students will be able to:
• Using Report Viewer
• Integrate reports with ASP.NET applications
• Integrate reports with MVC applications

Module 4: Advanced Report Authoring
Use filtering and parameter
Use formula fields
Use Subreport
Use Summary
Use Running Total
Use Sorting
Use Barcode
Lab : Advanced Report Authoring
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

Module 5: Advanced Data Access
Using Dataset
Using SQL Command
Using LINQ
Using Web Services
Using Link Tables
Lab : Advanced Data Access
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

Module 6: Exporting Data
Exporting Data with Crystal Report
Export Using Report Viewer
Exporting with Code
Lab : Exporting Data
After completing this module, students will be able to:
• Describe export report to different data sources

Module 7: Troubleshooting and Debugging Report
Troubleshooting Field and Text
Troubleshooting Record Selection Formulas
Lab : Troubleshooting and Debugging Report
After completing this module, students will be able to:
• Describe common issues in report authoring

Virtual Courses

ALL of our courses can be delivered virtually! Our Bath public schedule courses are available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...