SQLReportViewer

SqlReportViewer is an advanced and feature-rich report viewer control designed for Microsoft SQL Server 2008 Reporting Services. It renders SSRS reports with identical layout and appearance as the report design and supports most report items available in SSRS such as TextBox, Line, Image as well as comprehensive support for Matrix, Table and List (Tablix).

Live Demo Gallery Watch Video

SQLReportViewer

Blazing-fast Performance

Designed for performance, SqlReportViewer is capable in handling large SQL report without performance bottleneck, thanks to the innovative background loading feature. Background loading allows pages to be preloaded in the background during application's idle time. This means that the background loading will pause the process when it detects user's activities such as mouse movement or key press.

Back to top

Streaming Loading Mode

SqlReportViewer supports three loading strategies for the most demanding reporting requirements. Among the most advanced mode is the streaming loading mode which displays only the pages visible in the client. This means that only the displayed pages are sent to the client and rendered. The streaming option also allows caching for 15 minutes or user-configurable, in which within the duration the resulted XAML does not require re-processing from the reporting service. The streaming mode dramatically improves application performance and greatly enhances user experiences.

Back to top

Pixel-perfect Report Rendering

SqlReportViewer is powered with sophisticated rendering engine that draws every reporting element in pixel-perfect page layout. It supports most report items available in the SQL Server Reporting Services such as TextBox, Line, and Image – as well as support for advanced items like Matrix, Table and List (Tablix). Beyond static table display, SqlReportViewer also supports complex Tablix layout that requires automatic layout adjustment (grow/shrink) depending on the available data.

Live Demo Gallery

Back to top

Report Interactivity

SQL Server Reporting Services is well known for its unique interactive reporting which allows users to interact with the report at runtime. SqlReportViewer is thoughtfully designed to support all those interactivity features, such as the toggle item, data drill-down, external hyperlinks and sub report navigation as well bookmark and page-level navigation. These interactive features give users the power to analyze their report and make the most out of their data.

Back to top

Report Navigation

SqlReportViewer leverages many of the key features available in SQL Reporting Services to deliver the best reporting solution for your Silverlight and WPF applications. It includes built-in reporting navigation which allows users to browse the available reports in the Reporting Services right from the report viewer. This time-saving feature empowers your IT team to deploy powerful a reporting solution that grows and scales with your business. This means that new reports deployed to the Reporting Services will be automatically visible and accessible to the users. And of course, you can opt to disable the feature if not applicable.

Back to top

Report Parameters

Report parameter is one of the common requirements in report viewers which is well supported in SqlReportViewer. When a report with parameters is loaded, SqlReportViewer automatically displays the parameter panel which sits on the top of the viewer interface. The caption and data type of the parameters are automatically dispatched by the viewer so you don’t have to write a single line of code. And better yet, SqlReportViewer automatically validates against the parameter options such as whether it requires user input.

Live Demo Gallery

Back to top

Report Exporting

SqlReportViewer allows data exporting which supports many popular formats available in the SQL Server Reporting Services such as HTML, Excel, Word and PDF. The support for wide range of popular formats enable users to extract the report data and process it further in their favorite spreadsheet applications. By default, the data exporting is enabled in SqlReportViewer, accessible from the toolbar button in the report viewer interface.

Back to top

Extensible Data Visualization Rendering

Beyond basic table and text, SqlReportViewer also supports the rendering of more advanced data visualization elements thanks to the extensible rendering architecture. It allows you to create your own custom renderer that maps each element such as chart, gauge and sparkline to the data visualization interface of your choice – whether it's the free data visualization interface from Silverlight toolkit, or other third party data visualization suite.

Live Demo Gallery

Back to top

Close window
back back back forwardforwardforward