The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

Creating SAP Crystal Reports with Visual Studio for Developers

  • Tuition USD $981 Save $109
  • Reviews star_rate star_rate star_rate star_rate star_half 531 Ratings
  • Course Code 55118
  • Duration 2 days
  • Available Formats Classroom

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.

Skills Gained

  • 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

Who Can Benefit

This course is intended for both 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.

Course Details

Outline


Module 1: Preparing Visual Studio for Reporting
This module explains how to install and configure SAP Crystal Report for Visual Studio in Visual Studio 2013 and create first report.
Lessons

  • 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
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
This module explains how to create a report using core functionalities of SAP Crystal Reports for developer with Visual Studio 2013.
Lessons
  • Create basic report
  • Create table
  • Create Chart
  • Create Grouping
  • Report formatting
  • Use Section

Lab 1: 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

Module 3: Integrating Report with Applications
This module explains how to integrate report using Report Viewer with Windows, ASP.NET and WPF applications.
Lessons
  • Using Web Report Viewer

Lab 1: 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

Module 4: Advanced Report Authoring
This module explains how to enhance report with advanced functionalities in SAP Crystal Reports for developers and Visual Studio 2013
Lessons
  • 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
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
This module explains how to connect report to dfferent kind of data source using different methods that fit the need of the applications
Lessons
  • 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
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
This module explains how to data report to different kind of format.
Lessons
  • Exporting Data with Crystal Report
  • Export Using Report Viewer
  • Exporting with Code

Lab 1: Exporting Data
  • Export to HTML with Options
After completing this module, students will be able to:
  • Describe export report to different data sources

Module 7: Troubleshooting and Debugging Report
This module explains how to troubleshoot some of the common report authoring issues.
Lessons
  • Troubleshooting Field and Text
  • Troubleshooting Record Selection Formulas

Lab 1: 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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Fantastic and great training. Tons of hands-on labs to really make you understand the material being thought.

I was familiar with some knowledge on AWS Cloud, however the instructor Lopez explained stuff that made it easy to understand. He was very knowledgeable with the information he provided during class

Excellent course. Ruben Lopez is an outstanding instructor. Learned tons of information. Would recommend ExitCertified to anyone!

Very thorough and well-presented class. Pace of the class was perfect and labs offered great opportunity to practice material.

The instructor was proficient in his subject and overall, it was presented well

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward