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
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
The Report Designer provides rich user-friendly interface to easily transform your data into beautiful reports. The WYSIWYG user interface allows the report to be edited similar to the appearance of the UI when printed or displayed. Furthermore, you can easily edit a report with mouse, touchscreen, or keyboard interfaces.
Gridlines and snap-to-grid
The design area comes with gridlines and snap-to-grid to simplify positioning and aligning 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 when designing a report.
When multiple report items overlaps in the design surface, the layout ordering controls the report items that are to be at the top and 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
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 allow perfect positioning, sizing, and aligning of report items in a report.
All the selected report items can be aligned to the left, right, or center horizontally, or aligned to 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 and detail rows. 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.
option to preview the report and verify whether the
created report displays what you require. The reports
the RDL functionalities.
Run or preview a report, and export it to popular file formats such as PDF, Word, Excel, CSV, PowerPoint, and HTML.
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
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.
Globalization and localization
You can format the report contents to any language that helps your users from different locales.