View RDL or RDLC reports that are local or embedded in an application without using SSRS server.
Supports responsive UI and touch in mobile devices and touch screen monitors.
Print and export to PDF, Excel, CSV, Word, PowerPoint, and HTML.
The ASP.NET Report Viewer is a web reporting tool that displays SSRS, RDL, and RDLC reports within web applications. It empowers your application with all major capabilities of RDL reporting such as parameters, variables, expressions, code modules, calculated fields, sorting, grouping, filtering, paging, report linking, drill down (toggle item), drill through, hyperlink and more. You can export the report to PDF, Excel, CSV, WORD, PowerPoint, and HTML formats. Reports rendered using HTML5 provide an optimal user experience across phone, tablet, and desktop form factors.
SSRS server reports
ASP.NET Report Viewer can render RDL reports published or deployed on SQL Server Reporting Services (SSRS) server.
Local RDL and RDLC reports
You no longer require SSRS Report Server to render RDL reports. View RDL and RDLC reports that are local or embedded in an application without using SSRS Report Server.
Connect to any report data source
Retrieves data from a wide variety of data sources that are in local or server data bases.
- Built-in data sources: Microsoft SQL Server, Microsoft SQL Azure, SQL CE, XML, Microsoft Access, Oracle, OLEDB, and ODBC.
- Business object data source: IList, DataSet, and DataTable.
- Custom data processing extension: MySQL, SQLite, PostgreSQL, etc.
Enables users to view stylish and interactive reports created with RDL reporting standard data visualization, data region, and reports basic items efficiently:
- Basic items: Text box, image, line, and rectangle.
- Data region items: Table, matrix (pivot table) and list.
- Data visualization: Charts, sparklines, databars, gauges, indicators, and maps.
- Custom report items.
Custom parameter layout
Supports SQL Server 2016 parameter layout that enables you to render report parameters the way you want.
Has support to preview report with query parameters that filters data from the data source. It limits the amount of data based on the run-time parameter user input or allows it to be set in report as default values.
Filter, group, and sort data
Data values of data region report items are organized using grouping, sorting, and filtering. It supports items such as tables, pivot tables, lists, charts, spark lines, data bars, gauges, indicators, and maps.
Supports grouping to visualize data in an organized way. Groups data in tables, charts, gauges, maps and indicators, and organizes data based on a dataset field, group expression, or other values.
Controls the order in which data is displayed in a data region item of the report (either as ascending or descending).
Filtering allows data compaction. Renders report with filters that are applied to shared or embedded data set, table, chart, or data region group.
Drill through, drill down, interactive sort, and hyperlink
You can work with reports at run-time through RDL reporting features like drill through, drill down, hyperlink, and interactive sorting.
Renders reports with simple and complex SQL Server Reporting RDL specification expressions that specify or calculate values for report item properties, parameters, queries, groups, sorting, code module, filters, fields, collections, functions, etc.
Print and export
Supports printing previewed reports by clicking the print option from the toolbar. Property settings allows you to view and print from the same tab or a new tab.
Clicking print layout option on the toolbar shows the report in printable output format.
Export RDL and RDLC reports
Export displayed reports into popular file formats such as PDF, Word, Excel, CSV, PowerPoint, and HTML. In addition, provides property options to change the export format version and settings.
Report preview settings
Fit to page
Options are available to fit the page content relative to the control size by page width or whole page size.
Customize your report page design by selecting options like paper size, orientation, and margins in the Page Setup dialog. Clicking print preview option shows the changes applied to the report page in Report Viewer.
Customize toolbar icons and element’s appearances using templates. Hide the component toolbar design and show customized user interface using Report Viewer properties.
Custom parameter block
Supports customizing the default left-to-right parameter block’s appearance using templates. Hide default Report Viewer parameter block and show custom user interface.
Theme and API's
The ASP.NET Report Viewer is shipped with themes such as Material, Bootstrap, Office 365.
Developer friendly APIs
You have control over all UI elements (toolbar, parameter block, page, and dialogs) and behaviors of the ASP.NET Report Viewer. You can provide the best experience to your end users through a rich set of developer-friendly APIs.
Globalization and localization
You can format the report contents to any language that helps your users from different locales.
Users can localize all static text of the ASP.NET Report Viewer to any preferred language.
Responsive and browser compatibility
Report Viewer will adaptively render itself with optimal user interfaces for phone, tablet, or desktop form factors. This helps your application to scale elegantly on all form factors with ease.
Works in all modern browsers on all devices as the ASP.NET Report Viewer is rendered using HTML5 elements.