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.