PacktLib: Reporting with Visual Studio and Crystal Reports

Reporting with Visual Studio and Crystal Reports

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

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

Designing a Sample Application

Creating a new application

Adding controls to the form

Validating form data

Sketching your reports on paper

Summary

Selecting the Data

SQL queries in Microsoft Visual Studio

Add database diagram

Populate the ComboBoxes with data

Summary

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

Enhancing Reports

Using parameter fields

Working with formula fields

Working with subreport

Grouping and sorting data

Summary

Working with Cross-Tab Reports

Creating our report

Customizing the Cross-Tab appearance

Performing page setup

Summary

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

Index