About Me/Legal Notice 
 Home   T-SQL Data Scripts   Export to Text/CSV   Text/CSV to SQL   Export to PDF/Excel   Command Line   Reporting Services   Download     Buy     History 


Advertisement

Prerequisites
The reports are generated using Microsoft Report Viewer, which is not part of .NET Framework 2.x. In order to use the report and export functionalities, you have to install Microsoft Report Viewer first. Installation and usage of Microsoft Report Viewer is free.

Download Microsoft Report Viewer
How to check if Microsoft Report Viewer is already installed?

Source Data
The source for your report could be a table, a view or your own SQL.
 
Advertisement
 
Look & Feel
Example of first appearance using the report engine.
  • Select font, color and size
  • Use the order by options
 
Row Style
Select the row style to separate the records
 
Column Header
  • Show column headers
  • Color and Size
  • Description
  • Width
 
Advertisement
 
Report Header and Footer
Header and Footer Text Options
 
Data Format Options
Choose your format options for date, number and boolean values.
 
Export to PDF or Excel
Use the Save button to export the report to PDF/Excel.

Question: Does xls export require Excel to be installed?
Answer: No. The xls export feature is independent of Excel. Excel is only required to view the xls file.
Question: Does PDF export require an Adobe license?
Answer: No. The ReportViewer control does not use any Adobe code to generate PDF files. PDF is an open format, and anyone can create PDF files without requiring a special license.
 
Result Examples
Result examples for Excel and PDF.
 
How to check if Microsoft Report Viewer is already installed?
Use Windows Explorer to open the assembly folder (located in Windows\assembly, for instance C:\Windows\assembly). When the list appears, scroll through the list of installed assemblies. If you see Microsoft.ReportViewer.WinForms listed, the required version is already installed and you do not need to install it again.