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.

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
$16.80
RRP $23.99
Save 29%
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
$16.80
$39.99
$29.99p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

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

JavaScript and JSON Essentials Book Cover
JavaScript and JSON Essentials
$ 17.99
$ 12.60
Learning SQL Server Reporting Services 2012 Book Cover
Learning SQL Server Reporting Services 2012
$ 32.99
$ 23.10
Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 21.00
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Practical Data Science Cookbook Book Cover
Practical Data Science Cookbook
$ 29.99
$ 21.00
Object-Oriented JavaScript - Second Edition Book Cover
Object-Oriented JavaScript - Second Edition
$ 29.99
$ 21.00