You are previewing Reporting with Visual Studio and Crystal Reports.
O'Reilly logo
Reporting with Visual Studio and Crystal Reports

Book Description

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.

  • A step-by-step guide that goes beyond theory, letting you get hand-on experience

  • Utilize a dataset and table adapter as data sources for your report

  • Learn how to add reports to forms and pass parameters dynamically

  • In Detail

    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

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