Reporting with Visual Studio and Crystal Reports


Reporting with Visual Studio and Crystal Reports
eBook: $23.99
Formats: PDF, PacktLib, ePub and Mobi formats
$20.39
save 15%!
Print + free eBook + free PacktLib access to the book: $63.98    Print cover: $39.99
$39.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 148 pages [ 235mm x 191mm ]
Release Date : October 2013
ISBN : 1782178023
ISBN 13 : 9781782178026
Author(s) : Mahmoud Elkoush
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise

Table of Contents

Preface
Chapter 1: Setting Up the Requirements
Chapter 2: Designing a Sample Application
Chapter 3: Selecting the Data
Chapter 4: Creating First Report
Chapter 5: Enhancing Reports
Chapter 6: Working with Cross-Tab Reports
Chapter 7: Working with Charts
Index
  • Chapter 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
    • Chapter 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
      • Chapter 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
        • Chapter 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
              • Chapter 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

                Mahmoud Elkoush

                Mahmoud Elkoush has over six years experience in software development. He has used many technologies throughout his career such as Microsoft Visual Studio, Microsoft SQL Server, Oracle database, Crystal Reports, and so on. He has worked as a Project Manager in the Kingdom of Saudi Arabia for nearly two years, and currently works as the Chief Information Officer of Geomeric. This is the first book that Mahmoud has written, and he hopes it will be the first of many.

                Submit Errata

                Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                Sample chapters

                You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                Frequently bought together

                Reporting with Visual Studio and Crystal Reports +    Microsoft Dynamics GP 2013 Cookbook =
                50% Off
                the second eBook
                Price for both: £27.05

                Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                What you will learn from this book

                • 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

                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.

                Approach

                A fast-paced, example-based guide to learn how to create a reporting application using Visual Studio and Crystal Reports.

                Who this book is for

                "Reporting with Visual Studio and Crystal Reports" is for developers new to Crystal Reports. It will also prove useful to intermediate users who wish to explore some new techniques in Crystal Reports using Microsoft Visual Studio. Readers are expected to have basic knowledge of C#, Microsoft Visual Studio, and Structured Query Language (SQL).

                Code Download and Errata
                Packt Anytime, Anywhere
                Register Books
                Print Upgrades
                eBook Downloads
                Video Support
                Contact Us
                Awards Voting Nominations Previous Winners
                Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                Resources
                Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software