Book Image

Reporting with Visual Studio and Crystal Reports

By : Mahmoud Elkoush
Book Image

Reporting with Visual Studio and Crystal Reports

By: Mahmoud Elkoush

Overview of this book

<p>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.</p> <p>"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.</p> <p>"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.</p>
Table of Contents (14 chapters)
Reporting with Visual Studio and Crystal Reports
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Preface

Reports are of paramount importance for a developer who wants to create successful software. Crystal Reports is an amazing reporting tool because it is compatible with Visual Studio and other developing tools. Crystal Reports is compatible with a lot of databases and is easy to use. It is a powerful reporting tool and can be used to create any report with the least amount of effort. This book is different from other technical books because it not only describes the tools and features in Crystal Reports and Visual Studio, but also contains a sample application with eight reports. Every report has a new idea and teaches the reader a new tool. The reader not only learns to create reports but also learns how to display these reports in Microsoft Visual Studio applications.

What this book covers

Chapter 1, Setting Up the Requirements, will show how to install the tools that we will use.

Chapter 2, Designing a Sample Application, contains a description of the sample application that we will create.

Chapter 3, Selecting the Correct Data, will show how to connect to a database and run SQL queries using Microsoft Visual Studio and also talk about dataset and TableAdapter.

Chapter 4, Creating Your First Report, will show how to create a simple report and display this report in our application.

Chapter 5, Enhancing the Report, will show how to enhance the report using grouping, filters, and subreports.

Chapter 6, Working With Cross-Tab Reports, covers what cross-tab is and describes how to use it.

Chapter 7, Working with Charts, covers the different types of charts in Crystal Reports and describes how to use them.

What you need for this book

You will require the following softwares to be installed on your system to run the examples in this book:

  • Microsoft Visual Studio 2012

  • Crystal Reports for Visual Studio 2012

  • Microsoft SQL Server 2008

  • Northwind Database

Who this book is for

This book is for developers who are 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).

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "After downloading the source, extract it, and double-click on the vs_premium.exe file to begin the installation."

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Click on the OK button to save the changes and run the application to test the new appearance."

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to , and mention the book title via the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.