SAP Crystal Reports with ASP.Net (Step by step)
4.2 (295 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,322 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP Crystal Reports with ASP.Net (Step by step) to your Wishlist.

Add to Wishlist

SAP Crystal Reports with ASP.Net (Step by step)

A very easy and simple method to design and display SAP Crystal Reports, in Microsoft Visual Studio using C# short code.
4.2 (295 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,322 students enrolled
Created by Mansoor Bari
Last updated 3/2015
English
Price: Free
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand and familiar with MS-Visual Studio 2012 GUI
  • Create & configure a DataSet Object
  • Add a blank Crystal report to asp.net project
  • Bind the Crystal Report with MS SQL Server Database
  • Design & Format the Crystal report
  • Understand the sections of the Crystal Report
  • Add a WebForm to the project
  • Drag & drop a Button & a CrystalReportViewer control on the WebForm
  • Add some C# code behind the Button Click event to display the report in browser
View Curriculum
Requirements
  • Microsoft Visual Studio 2012 (any edition)
  • SAP Crystal Reports for MS-Visual Studio 2012 (any version)
  • Not necessary to be familiar with C# programming, as it is going to be your first C# programming coding.
  • No need to be familiar with Visual Studio or Crystal Report Software/s.
Description

Course Description:

Learn the easiest and basic method to work with SAP Crystal Reports 2013 in Microsoft Visual Studio 2012 connected to MS SQL Server 2008 Database.

Let's make the first move to design & display one simple Crystal Report for the professional presentation of data in a web browser, in a manner that could be used for decision making by the management.

Course Specialty:

This course will help software developers to get rid-off writing complex & lengthy code for displaying Crystal Report in a web browser. This course demonstrates a "Developers-Friendly" method of:-

  • adding Crystal Reports to Microsoft Visual Studio Project,
  • Connecting the report to the Database.
  • working with the layout interface of Crystal Report Designer and
  • using the "Crystal Report Viewer Control" in ASP.Net.

Software/s and their versions used in this course:

  1. Software: SAP Crystal Reports 2013, Developers Version
  2. Platform: Microsoft Visual Studio 2012
  3. Framework: ASP.Net 4.5
  4. Language: C #
  5. Database: Microsoft SQL Server 2008


Contents and Overview:

In only one hour duration with only five videos this course covers most of the SAP Crystal Reports essentials, fundamentals and terminologies along with the best practice of passing structured Query to retrieve data from the database.

In this course you will see how easy it is to use the Graphical User Interface of SAP Crystal Report for placing data chunks into proper sections of the report.

You will also learn to summarize data by inserting "running-total" fields into the report.

In order to display the report, this course provides a short programming code written in C#, which is easy, tested and error free.

Upon completion you will be able to design any type of report on your own and will be working independently with both Microsoft Visual Studio and SAP Crystal Reports.

What are the requirements?

  • Basic knowledge of programming in C#
  • A familiarity of Microsoft Visual Studio
  • Concepts of database tables & views
  • General knowledge of Web Applications

At the end of this course you will be able to:

  • Create & configure a DataSet Object in Microsoft Visual Studio 2012
  • Add a blank Crystal report to the project
  • Bind the Crystal report with the DataSet
  • Design & Format the Crystal report
  • Add a WebForm to the project
  • Drag & drop a Button & a CrystalReportViewer control on the WebForm
  • Add C# code behind the Button Click event to display the report in browser


What is the target audience?

  • Students of Software Engineering
  • University students who are working on their final year project
  • Database Applications Developers, Internees and students
  • Web Developers
  • E.R.P Developers
  • Database Administrators
  • IT professionals and managers whose job is to implement SAP ERP systems in their organizations



Who is the target audience?
  • This Course is meant for Web Developers who never worked with SAP Crystal Reports.
  • For those software developers who are at their entry level, and scared of Crystal Report.
  • For the students of B.S and M.S (Computer Science/ IT) who are preparing their final year university project.
  • For the IT Professionals whose job is to implement ERP Systems.
  • For the programmers of MS-Excel, who want to upgrade their complex Excel reports to a professional, user friendly and secure approach of displaying data through SAP Crystal Reports Technology.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Understanding Microsoft Visual Studio 2012 GUI
1 Lecture 06:57

In this very first step we will gather organised data into one place from the Database. This place is called a DataSet. Our Crystal Report reads the data from this place. The DataSet object acts as a bridge between the Crystal Report and the physical Database. The physical Database could be any type, such as MS-SQL Server, Oracle or Access etc.

How to Create & configure a DataSet Object
06:57
+
Adding New Crystal Report to the project
1 Lecture 05:09

There are several ways of working with Crystal reports in web applications, but most of them are complicated and lengthy. Here I am introducing the one and only shortest and the best way of adding and connecting a Crystal Report with the Database using a simple Dataset Object concept.

How to Add a blank Crystal report and connect it with the database
05:09
+
Design & Format the Crystal report
1 Lecture 13:27

As it is your first Crystal report, you will learn how to add and format data into the different sections of the Crystal report. The design panel of Crystal report is divided into some sections; such as Report Header, Page Header, Page Footer etc. The placement of data into these sections is our main objective in this lecture.

How to design our new Crystal report from the scratch
13:27
+
Preparing a WebForm to handle our Crystal report
1 Lecture 06:20

Till now, our new Crystal report has been designed and ready to be displayed. Microsoft Visual Studio 2012 and later provide a specific Control "CrystalReportViewer" control that handles the properties and methods. You will see how simple it is to drag & drop controls on the webform.

How to configure a webform to display our Crystal Report
06:20
+
The last step of displaying our Crystal report in a browser
1 Lecture 22:06

A simple, concise and concrete C# code that creates a Connection with the database, tells the application where the database is, defines the SQL query to select and retrieve desired data from the database, and finally displays the data on Crystal Report in a browser.

What C# code to write behind the Button's Click event
22:06
About the Instructor
Mansoor Bari
4.2 Average rating
295 Reviews
7,322 Students
1 Course
Web Development Manager at WEBONSIVE Software House

I am a Microsoft Certified Professional since 2002 and holding Degrees in Computer Science, Business Administration and General Management. I entered into the field of IT in 1994 with a diploma in computer science from Pakistan and then went to England where I continued my studies and acquired diploma in Computer Networking and Information Management in 1998. As a software developer, my career started when i became MCP in 2002 and developed a complete ERP System software by the end of 2004. I worked a lot in Crystal Reports in the ERP system with integration in both Desktop & Web Applications. I designed several complex Crystal Reports during the journey of various versions of Crystal Report from versions 8.0 to 2013. My expertise are

  • Visual Basic
  • C#
  • ASP.Net
  • AJAX
  • MS SQL Server
  • SAP Crystal Reports

During my career of research and study i went to the following universities & colleges:

  • PETROMAN, Pakistan
  • N.E.D University, Pakistan
  • Sir Syed University, Pakistan
  • Federal Urdu University, Pakistan
  • KeyPlan Training College, London, UK
  • Roxbourgh College, London, UK
  • Shah Abdul Latif University, Pakistan

My worldwide projects are successfully running in organizations which include:

  • ERP system,
  • Financial Accounting Software,
  • Sales Management,
  • Human Resource Management,
  • Biometric Attendance and Payroll system.

Currently I am working in WEBONSIVE Software house in Pakistan as a Web Development Manager where i am designing & developing Web based SAP Crystal Reports in ASP.net 4.5, AJAX, C# on Microsoft Visual Studio 2012 environment.

My tutorials are online on youtube and DailyMotion. I am also solving critical issues of SAP Crystal Reports Developers through my facebook group "SAPCrystalReports" to more than 280 global members which are increasing day by day.