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

Course Modality

Instructor-led (classroom)

Course Level

Beginner

Course Time

90 MINUTES

Course Language

English

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.

Prerequisites

Experience with developing using Visual Studio 2013

  • Basic understanding of RDBMS
  • Basic understanding of application architecture
  • Basic understanding of .NET framework.

Intended Audience

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

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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

Get In Touch

Course Curriculum

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 source

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

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

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

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

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

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 : Exporting Data

  • Export to HTML with Options

After completing this module, students will be able to:

  • Describe export report to different data sources

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 : Troubleshooting and Debugging Report

  • Disable Field Clipping

  • Enhance Formula for Selection

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure