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.1 (213 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.
5,937 students enrolled
Free
Start Learning Now
  • Lectures 5
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course 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



What are the 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.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Understanding Microsoft Visual Studio 2012 GUI
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.

Section 2: Adding New Crystal Report to the project
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.

Section 3: Design & Format the Crystal report
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.

Section 4: Preparing a WebForm to handle our Crystal report
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.

Section 5: The last step of displaying our Crystal report in a browser
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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mansoor Bari, 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.

Ready to start learning?
Start Learning Now