Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Reporting with Visual Studio and Crystal Reports
Table of Contents
Reporting with Visual Studio and Crystal Reports
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. Setting Up the Requirements
Installing Microsoft Visual Studio 2012
Getting the source
Installation
Installing Crystal Reports for Visual Studio 2012
Getting the source
Installation
Installing Microsoft SQL Server 2008
Getting the source
Installation
Installing Northwind database in Microsoft SQL Server 2008
Getting the source
Installation
Summary
2. Designing a Sample Application
Creating a new application
Adding controls to the form
Employees
Beginning your design process
Products and orders
Beginning your design process
Employees and orders
Beginning your design process
Validating form data
Sketching your reports on paper
Summary
3. Selecting the Data
SQL queries in Microsoft Visual Studio
Connecting to our database
Add database diagram
Test queries
Populate the ComboBoxes with data
Add DataSet to the application
Populate the cbEmpTitle ComboBox
Populate the cbEmpCity ComboBox
Populate the cbEmpCountry ComboBox
Populate the cbProductsCategory ComboBox
Populate cbOrdersCountry ComboBox
Summary
4. Creating First Report
Preparing a report data
Selecting the report data
Creating a TableAdapter
Adding a report to the application
Working with lines and boxes
Using special fields
Adding the report to a form
Summary
5. Enhancing Reports
Using parameter fields
Working with formula fields
Working with subreport
Grouping and sorting data
Summary
6. Working with Cross-Tab Reports
Creating our report
Customizing the Cross-Tab appearance
Performing page setup
Summary
7. Working with Charts
Creating the reports data source
Creating the first report – bar chart
Removing the legend
Removing the chart's title
Changing the chart's appearance
Creating the second report – pie chart
Removing the legend
Removing the chart's title
Changing the chart's appearance
Creating the third report – gauge chart
Removing the legend
Removing the chart's title
Changing the chart's appearance
Creating the fourth report – all in one
Summary
Index
← Prev
Back
Next →
← Prev
Back
Next →