Reporting with Visual Studio and Crystal Reports

The simplest way to learn Crystal Reports and Visual Studio is to follow the hands-on exercises in this tutorial. In no time you’ll be producing stunning charts and be able to create a reporting application from scratch.
Preview in Mapt
Code Files

Reporting with Visual Studio and Crystal Reports

Mahmoud Elkoush

The simplest way to learn Crystal Reports and Visual Studio is to follow the hands-on exercises in this tutorial. In no time you’ll be producing stunning charts and be able to create a reporting application from scratch.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $23.99
Save 58%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$39.99
$29.99 p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Reporting with Visual Studio and Crystal Reports Book Cover
Reporting with Visual Studio and Crystal Reports
$ 23.99
$ 10.00
Learn To Program Tic-Tac-Toe with C# and Visual Studio [Video] Book Cover
Learn To Program Tic-Tac-Toe with C# and Visual Studio [Video]
$ 42.99
$ 10.00
Buy 2 for $20.00
Save $46.98
Add to Cart

Book Details

ISBN 139781782178026
Paperback148 pages

Book Description

Reports are documents that present focused, salient content to a specific audience. Crystal Reports is a business intelligence application that will help you design and generate reports from a wide range of data sources. It helps you summarize a good deal of information in a visually appealing manner.

"Reporting with Visual Studio and Crystal Reports" is a practical, hands-on guide that will provide you with a number of clear, step-by-step exercises, and help you take advantage of the real power of Crystal Reports. This book will not only help you create effective reports, but also teach you how to create a reporting application.

"Reporting with Visual Studio and Crystal Reports" will guide you through the installation of Crystal Reports and Visual Studio. As you progress from one chapter to the next, you will gradually build a reporting application. You will also learn how to select the right data, and enhance your report by grouping and sorting data. This book will also help you create chart reports to improve your report design. With this book, you will learn how to create a complete reporting application and a wide variety of reports.

Table of Contents

Chapter 1: Setting Up the Requirements
Installing Microsoft Visual Studio 2012
Installing Crystal Reports for Visual Studio 2012
Installing Microsoft SQL Server 2008
Installing Northwind database in Microsoft SQL Server 2008
Summary
Chapter 2: Designing a Sample Application
Creating a new application
Adding controls to the form
Validating form data
Sketching your reports on paper
Summary
Chapter 3: Selecting the Data
SQL queries in Microsoft Visual Studio
Add database diagram
Populate the ComboBoxes with data
Summary
Chapter 4: Creating First Report
Preparing a report data
Adding a report to the application
Working with lines and boxes
Using special fields
Adding the report to a form
Summary
Chapter 5: Enhancing Reports
Using parameter fields
Working with formula fields
Working with subreport
Grouping and sorting data
Summary
Chapter 6: Working with Cross-Tab Reports
Creating our report
Customizing the Cross-Tab appearance
Performing page setup
Summary
Chapter 7: Working with Charts
Creating the reports data source
Creating the first report – bar chart
Creating the second report – pie chart
Creating the third report – gauge chart
Creating the fourth report – all in one
Summary

What You Will Learn

  • Set up Microsoft Visual Studio, Crystal Reports, and Microsoft SQL server
  • Create a new reporting application
  • Design the application GUI
  • Connect to a database and use a dataset and table adapter
  • Add Crystal Reports to the application
  • Add database fields to the report and format them
  • Group and sort report data using parameter fields and special fields

Authors

Table of Contents

Chapter 1: Setting Up the Requirements
Installing Microsoft Visual Studio 2012
Installing Crystal Reports for Visual Studio 2012
Installing Microsoft SQL Server 2008
Installing Northwind database in Microsoft SQL Server 2008
Summary
Chapter 2: Designing a Sample Application
Creating a new application
Adding controls to the form
Validating form data
Sketching your reports on paper
Summary
Chapter 3: Selecting the Data
SQL queries in Microsoft Visual Studio
Add database diagram
Populate the ComboBoxes with data
Summary
Chapter 4: Creating First Report
Preparing a report data
Adding a report to the application
Working with lines and boxes
Using special fields
Adding the report to a form
Summary
Chapter 5: Enhancing Reports
Using parameter fields
Working with formula fields
Working with subreport
Grouping and sorting data
Summary
Chapter 6: Working with Cross-Tab Reports
Creating our report
Customizing the Cross-Tab appearance
Performing page setup
Summary
Chapter 7: Working with Charts
Creating the reports data source
Creating the first report – bar chart
Creating the second report – pie chart
Creating the third report – gauge chart
Creating the fourth report – all in one
Summary

Book Details

ISBN 139781782178026
Paperback148 pages
Read More

Read More Reviews

Recommended for You

Mastering SQL Queries for SAP Business One Book Cover
Mastering SQL Queries for SAP Business One
$ 32.99
$ 10.00
Mastering C# and .NET Framework Book Cover
Mastering C# and .NET Framework
$ 35.99
$ 10.00
Oracle SQL Developer Book Cover
Oracle SQL Developer
$ 43.99
$ 10.00
Python Tools for Visual Studio Book Cover
Python Tools for Visual Studio
$ 16.99
$ 10.00
Learning Google Apps Script Book Cover
Learning Google Apps Script
$ 31.99
$ 10.00
The Microsoft Outlook Ideas Book Book Cover
The Microsoft Outlook Ideas Book
$ 14.99
$ 10.00