Modern web-based ASP.NET Report Designer
ASP.NET Report Designer is a jQuery
based web reporting tool to design RDL
reports using a rich set of data region, visualization, and basic report items with reporting features such as parameters, expressions, sorting, grouping, filtering and more .
Supports creating SSRS RDL standard reports, rich in data visualization.
Modern and easy-to-use design to create reports in minutes.
Supports jQuery, Angular
The ASP.NET Report Designer is a jQuery based web reporting tool used to create and edit simple to complex RDL reports. The web-based report designer makes it easy to integrate an intuitive run-time RDL report editing and customization into your web application. It lets you create reports with reporting features such as parameters, expressions, sorting, grouping, filtering, report linking, hyperlink, and more. You can preview and export the report to PDF, Excel, CSV, WORD, PowerPoint, and HTML formats.
Connect to any report data source
Explore your data from any of the local or server data bases. Create an embedded or shared data source by connecting to the most common data sources by using the following data providers.
- Built-in data sources-Microsoft SQL Server, SQL CE, Oracle, XML, OLEDB, and ODBC.
- Custom data processing extension–SASS, WebAPI, MySQL, PostgreSQL, etc.
Create data model with query builder
Data query preparation can take most of your time, but with Report Designer, data query generation can be done with a few clicks. Query builder provides a convenient user interface that helps both technical and non-technical users to create and view relationships between tables.
Enables users to create stylish and interactive reports using a rich set of data region, visualization, and basic report items efficiently:
- Basic Items—Text box, image, line, and rectangle.
- Data Region Items—Table, matrix (pivot table) and list.
- Data Visualization—20+ chart types.
- Custom report items.
Rich user interface
Provides rich user-friendly interface to easily transform your data into beautiful reports. The WYSIWYG user interface allows report to be edited in a form that resembles its appearance when printed or displayed. Furthermore, you can easily edit a report with mouse, touchscreen, or keyboard interfaces.
The ASP.NET Report Designer comes with a design surface that allows perfect positioning, sizing, and aligning of report items in a report. This is the main work area to design reports and you can add header or footer to it. This allows you to increase or decrease the report page sizes with simple resizing helpers.
Gridlines and snap-to-grid
The design area comes with gridlines and snap-to-grid to simplify positioning and aligning of report elements. It provides improved flexibility in report designing.
Users can easily arrange report items on the design surface using the simple drag-and-drop operation to design a report.
When multiple report items overlaps in the design surface, the layout ordering controls which report item is at the top and which is at the bottom.
Supports creating report parameters manually or based on a data set query. Parameters are used to interactively provide user inputs at run-time to vary report presentation based on it. Parameters can also be used in expressions to control report data.
Data set query parameters
Allows creating an embedded or a shared dataset with parameter to filter or limit data. A data set can contain user-defined parameters for internal calculations or report parameter to get run-time inputs from users.
Users can add cascading parameters to the report to allow one parameter that limits the values for the next parameter. It greatly reduces the number of choices to a manageable number.
Filter, group and sort data
ASP.NET Report Designer supports to add filtering, grouping and sorting for data region items such as table, matrix (pivot table), charts and for data sets. It organizes the data values of the data region report items.
User can add grouping to display data in a hierarchy view by organizing nested, adjacent, and recursive hierarchy groups. You can use a dataset field, expression or other values to group data.
Supports adding sort expressions to chart category and series groups and pivot table groups. It controls the order in which data is displayed in a data region item of the report (either as ascending or descending).
Provides support to add filters to an embedded data set or shared data set, data regions, and data region groups, including detail groups. The filter equation includes a dataset field or expression, an operator, and a value used to compare.
The web-based Report Designer toolbar has enhanced alignment options that allows perfect positioning, sizing, and aligning of report items in a report.
All the selected report items can be aligned at the left, right, or center horizontally, or aligned at the top, bottom, or middle vertically in the design surface.
Use sizing options to equally size selected report items in the design surface.
Allows users to create a report with SQL RDL reporting’s extremely powerful interactive features like drill through, hyperlink, drill down and interactive sorting to display data and information in detail.
Drill through reports
An action property is available to specify the drill through report path. It allows end users to click on a data value in the report to view related data information in the child report. A separate child report can have detail/summary data. Also, users can add parameters to filter data based on user selection.
Provides property options to set hyperlink actions to text boxes, images, charts, and tables. The hyperlink can contain data field, static or dynamic URL value expression.
Drill down reports
Drill down option lets users to view sections of a report by expanding or collapsing it at run-time. Show or hide static rows and columns that are associated with groups in a table or matrix (pivot table). You can set the details to be hidden until a user clicks to view it. You can use the subreport or nested data region report items to show detailed records.
Table report items are displayed with sort icons on a column header or group header cell. It enables a user to sort or reverse the sort order of a column. You can specify a sort for the group rows or columns, for the detail rows or columns. You can also combine fields into a single group expression.
Report Designer provides an expression builder that allows you to create simple and complex RDL expressions. Expressions are used throughout the report definition to vary the content or appearance of a report. The following are some usages of expression.
- Use expressions to set dynamic value to many properties, including color, font, and borders.
- Used to create additional operations such as mathematical computation, conditional formatting, conversions, and more.
- Support to use constants, built-in fields,
parameters, fields, datasets, variables,
operators, common functions, etc.
Editing a report and its report items is simple with the support of basic editing operations such as cut, copy, paste, undo, and redo.
The ASP.NET Report Designer provides an
option to preview the report and verify whether the
created report displays what you require. The reports
are displayed using ASP.NET Report Viewer with all
the RDL functionalities.
Run or preview a report, and export it to popular file formats such as PDF, Word, Excel, CSV, PowerPoint, and HTML.
Supports printing previewed reports by clicking the print option from the ASP.NET Report Viewer toolbar.
Clicking print layout option on the ASP.NET Report Viewer toolbar shows the report in a printable output format.
Users can open and edit any report that is already created using SQL RDL specification. The edited report can be previewed and saved to the same location or to a different location.
Save and share report
The ASP.NET Report Designer allows you to save a report to Syncfusion Report Server or SSRS Report Server and to your computer. Publishing a report to the server allows other users (who have permission to access the server) to view it.
Theme and API's
Developer Friendly APIs
Options are available to fit the page content relative to the control size by page width or whole page size.
The ASP.NET Report Designer is shipped with themes such as material, bootstrap, fabric (office 365), high contrast, and more. Users can create new themes to have their own desired look and feel by using the Theme Studio application with ease.
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 Designer to any preferred language.
The ASP.NET Report Designer 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 Designer is rendered using HTML5 elements.