Overview of Reporting with Visual Studio and Crystal Reports

Overview of Reporting with Visual Studio and Crystal Reports

8026EN

Being one of the reviewers of the book ‘Reporting with Visual Studio and Crystal Reports’ I would like to introduce you this book as a very good guide for those who want to create a reporting application from scratch using Visual Studio and Crystal Reports.

It is a step-by-step guide that goes beyond theory covering following points:

  • 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.

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).

Web URL

If you want to view more details about the book or want to place an order, please Click Here

Report Viewer: Export to Excel in One Sheet

When you group your report based on some column, and then try to export to excel, it inserts a page break after certain records.

If you want to export complete data in one sheet of excel workbook. Do the followings

1. Right Click on Rdlc file

2. Select Open With

3. Select “XML (Text) Editor”

4. Add this tag <InteractiveHeight>0in</InteractiveHeight> inside <Page> tag

5. Save the file

6. Open the report

7. Remove all other page breaks from the reports

8. Remove the group page break as show in the attached image

9. Remove the report viewer height

Run the report, it will show results in one window as well as it will export the data in a single sheet of excel workbook