We are pleased to announce the release of the new version Stimulsoft Reports and Dashboards 2019.4 which is now available for download. This major release comes with the number of changes including the new installer, support for custom maps, HiDPI support, and critical fix with printing in Chrome77.
New installer
Starting with the release of 2019.4, you can install each Stimulsoft application as a separate distribution. Previously, to run the report designer, you had to download a Stimulsoft product entirely, install it, and then start designing reports and dashboards. Now, to begin creating reports and dashboards, install Stimulsoft Designer in the Windows operating system or Stimulsoft Designer.JS in the Windows and macOS operating systems.
You can also download the Stimulsoft Demo to familiarize yourself with our sample reports and dashboards. Also, you can download product packages from the website, in your account, from NuGet, npm, Maven file storages, or from the report designer dialog.
Printing reports from a web browser
In Google Chrome browser version 77, changes were made to the built-in PDF document viewer, because of which the automatic printing of the report from the menu of the Web viewer stopped working. We analyzed the situation and found a solution. In the new version of the product, report printing works correctly in any browser, on any operating system.
New CosmosDB Data Adapter
You can now retrieve data using the Azure CosmosDB server. To do this, select the CosmosDB type in the window for creating a data source and specify the connection string. After retrieving the data, you can design reports and dashboards based on them.
HiDPI support
The 2019.4 release adds HiDPI support in the standalone report designer. The designer automatically adapts to the scaling set in the system. You can define a scaling mode of 100 percent in the report designer settings. By default, the automatic zoom mode is used.
The Get Started window
When you run the report designer first time, you will see the Get Started window. From there, you can download and get access to other Stimulsoft applications, development packages, or help resources. You can disable popping up this window at every start of the designer. Just uncheck the
"Show 'Get Started' next time" option. You can call this window from the report designer by selecting the Get Started command from the File menu.
Sorting for dashboard elements
In the release 2019.4, you can specify the sorting of data for elements of the dashboards – Chart, Progress, Indicator, Gauge. You may change sorting data from the report designer or in the viewer. To do this, hover over an item, click the sort button, select a data field, and set the sorting direction. Sort settings apply only to the current element.
New chart functionality
In the new version, we added new features for the chart in dashboards. Now you can use Constant Lines, Markers, and Labels for values. To use the new features, you should select the Chart element and use the properties to determine their settings. Also, we added the conditional formatting of values for the chart. Thus, using markers, constant lines, and conditional formatting, you can create control charts.
Conditional formatting in dashboards
We added the ability to conditionally format dashboards elements – Indicator, Pivot Table, and Chart. Using conditional formatting, you can change the design settings of an element. To configure conditional formatting of an element, select the element in the dashboard and click the Conditions button on the Home tab of the Ribbon panel of the report designer. Add a condition and define conditional formatting options for the Pivot table.
New features of the Table element
We have added new functions for the Table element of dashboards. Now you can enable the display of totals in a column, select a table row, disable the detail mode of the table data when applying a filter. The settings for displaying totals are carried out in the editor of the Table element and enabling the row selection mode, and the disabling of the drill-down mode in the editor is the interaction of the current item.
New online map features
Now, when you create dashboards with an online map, you can display a chart of values or display an icon for values on this map. To change the display mode of the value on the online map, select the appropriate value of the View Mode parameter in the editor of the current element. To display a value chart, you should also specify a data field in the Arguments field. Also, in the current release, the online map supports a dark style. The style of the map depends on the style of the dashboard panel.
Custom maps
In the new version, you can use custom maps in reports and dashboards. To do this, you should create a map file and add this file to the report resources. After that, the map will be displayed in the map list of the Region Map element in dashboards or the Map component in reports. Select a custom map in the element (or component) editor and set values for the geographic objects of this map. Also, we improved the map selection window. Now you can select a category for a geographic region or use the search bar. Besides, in the current release, we added new types of maps - Scandinavia, Benelux countries and updated maps of Europe and the European Union.
New functionality for Image and Text
In the release 2019.4, we added new features for the Image and Text elements in dashboards. Now you can use the icons in the Image element. When you click on an image or text, you can open a hyperlink, display a drill-down dashboard panel, and when you hover over these elements, you may see tooltips. The Image component now can save previously loaded images.
Limit rows
When you create reports, you can specify the row limit for the Data Band on the current page or in the current column. The number of rows of the data band is determined by the numeric value for the Limit Rows property of this band.
Library version in the Publish wizard
When publishing a report or a dashboard, you can use the latest libraries or the current ones. To use the latest libraries, select the Use the latest versions of libraries option in the publication wizard. If this option is disabled, then when publishing a report or a dashboard, the current version of libraries will be used.
Support for CSV connections in the Publish wizard
Now when publishing reports and dashboards, you can specify a CSV data connection.
Export to Text
In the version 2019.4, in Reports.JS, we added the ability to convert a report to a .txt file. To do this, click the Save button and select the Text file... command in the viewer or the preview panel. After that, define the export settings and click the Ok button.
Support for ZUGFeRD v2.0
In our previous 2016.2 release, we added support for the ZUGFeRD electronic invoice format when exporting reports to PDF. The current version adds support for a new specification of this format - ZUGFeRD v2.0.
Displaying filters on dashboard elements
When viewing the dashboard, some elements are interactive. When you select a value, the data of all related items are filtered. Now, when using this type of filtering, the filter, and the selected value will be displayed on the element.
Compression when exporting to PDF
When you export reports to PDF from Reports.Java or Reports.JS, compression of the finished document is now available. When you export big reports, the size of the PDF document will be significantly reduced.
Data from other data sources in dashboards
When you design dashboards, you can now use data from other data sources. Create a virtual data source and design dashboards and reports based on it.
New installer
Starting with the release of 2019.4, you can install each Stimulsoft application as a separate distribution. Previously, to run the report designer, you had to download a Stimulsoft product entirely, install it, and then start designing reports and dashboards. Now, to begin creating reports and dashboards, install Stimulsoft Designer in the Windows operating system or Stimulsoft Designer.JS in the Windows and macOS operating systems.
You can also download the Stimulsoft Demo to familiarize yourself with our sample reports and dashboards. Also, you can download product packages from the website, in your account, from NuGet, npm, Maven file storages, or from the report designer dialog.
Printing reports from a web browser
In Google Chrome browser version 77, changes were made to the built-in PDF document viewer, because of which the automatic printing of the report from the menu of the Web viewer stopped working. We analyzed the situation and found a solution. In the new version of the product, report printing works correctly in any browser, on any operating system.
New CosmosDB Data Adapter
You can now retrieve data using the Azure CosmosDB server. To do this, select the CosmosDB type in the window for creating a data source and specify the connection string. After retrieving the data, you can design reports and dashboards based on them.
HiDPI support
The 2019.4 release adds HiDPI support in the standalone report designer. The designer automatically adapts to the scaling set in the system. You can define a scaling mode of 100 percent in the report designer settings. By default, the automatic zoom mode is used.
The Get Started window
When you run the report designer first time, you will see the Get Started window. From there, you can download and get access to other Stimulsoft applications, development packages, or help resources. You can disable popping up this window at every start of the designer. Just uncheck the
"Show 'Get Started' next time" option. You can call this window from the report designer by selecting the Get Started command from the File menu.
Sorting for dashboard elements
In the release 2019.4, you can specify the sorting of data for elements of the dashboards – Chart, Progress, Indicator, Gauge. You may change sorting data from the report designer or in the viewer. To do this, hover over an item, click the sort button, select a data field, and set the sorting direction. Sort settings apply only to the current element.
New chart functionality
In the new version, we added new features for the chart in dashboards. Now you can use Constant Lines, Markers, and Labels for values. To use the new features, you should select the Chart element and use the properties to determine their settings. Also, we added the conditional formatting of values for the chart. Thus, using markers, constant lines, and conditional formatting, you can create control charts.
Conditional formatting in dashboards
We added the ability to conditionally format dashboards elements – Indicator, Pivot Table, and Chart. Using conditional formatting, you can change the design settings of an element. To configure conditional formatting of an element, select the element in the dashboard and click the Conditions button on the Home tab of the Ribbon panel of the report designer. Add a condition and define conditional formatting options for the Pivot table.
New features of the Table element
We have added new functions for the Table element of dashboards. Now you can enable the display of totals in a column, select a table row, disable the detail mode of the table data when applying a filter. The settings for displaying totals are carried out in the editor of the Table element and enabling the row selection mode, and the disabling of the drill-down mode in the editor is the interaction of the current item.
New online map features
Now, when you create dashboards with an online map, you can display a chart of values or display an icon for values on this map. To change the display mode of the value on the online map, select the appropriate value of the View Mode parameter in the editor of the current element. To display a value chart, you should also specify a data field in the Arguments field. Also, in the current release, the online map supports a dark style. The style of the map depends on the style of the dashboard panel.
Custom maps
In the new version, you can use custom maps in reports and dashboards. To do this, you should create a map file and add this file to the report resources. After that, the map will be displayed in the map list of the Region Map element in dashboards or the Map component in reports. Select a custom map in the element (or component) editor and set values for the geographic objects of this map. Also, we improved the map selection window. Now you can select a category for a geographic region or use the search bar. Besides, in the current release, we added new types of maps - Scandinavia, Benelux countries and updated maps of Europe and the European Union.
New functionality for Image and Text
In the release 2019.4, we added new features for the Image and Text elements in dashboards. Now you can use the icons in the Image element. When you click on an image or text, you can open a hyperlink, display a drill-down dashboard panel, and when you hover over these elements, you may see tooltips. The Image component now can save previously loaded images.
Limit rows
When you create reports, you can specify the row limit for the Data Band on the current page or in the current column. The number of rows of the data band is determined by the numeric value for the Limit Rows property of this band.
Library version in the Publish wizard
When publishing a report or a dashboard, you can use the latest libraries or the current ones. To use the latest libraries, select the Use the latest versions of libraries option in the publication wizard. If this option is disabled, then when publishing a report or a dashboard, the current version of libraries will be used.
Support for CSV connections in the Publish wizard
Now when publishing reports and dashboards, you can specify a CSV data connection.
Export to Text
In the version 2019.4, in Reports.JS, we added the ability to convert a report to a .txt file. To do this, click the Save button and select the Text file... command in the viewer or the preview panel. After that, define the export settings and click the Ok button.
Support for ZUGFeRD v2.0
In our previous 2016.2 release, we added support for the ZUGFeRD electronic invoice format when exporting reports to PDF. The current version adds support for a new specification of this format - ZUGFeRD v2.0.
Displaying filters on dashboard elements
When viewing the dashboard, some elements are interactive. When you select a value, the data of all related items are filtered. Now, when using this type of filtering, the filter, and the selected value will be displayed on the element.
Compression when exporting to PDF
When you export reports to PDF from Reports.Java or Reports.JS, compression of the finished document is now available. When you export big reports, the size of the PDF document will be significantly reduced.
Data from other data sources in dashboards
When you design dashboards, you can now use data from other data sources. Create a virtual data source and design dashboards and reports based on it.
We are pleased to announce the release of the new version Stimulsoft Reports and Dashboards 2019.3.2 which is now available for download. This release comes with changes in the installation process. Now you may download the report designer for Win, MAC and JS separately; select packages of components and download only required ones as NuGet, npm, maven or ZIP archive.
In the release 2019.3.2, we have made changes in the installation process of Stimulsoft products. Now, from the Downloads page of our website, you can download the next files:
1. The Report Designer for creating, editing and viewing reports and dashboards on devices with installed Windows operating system.
2. The JavaScript Report Designer designed using the NW.js, HTML5, and JavaScript technologies.
3. The Report Designer for MAC designed for creating, editing and viewing reports and dashboards on devices with installed macOS operating system.
4. The Stimulsoft demo application with reports and dashboards samples.
Also, you can download packages of our components for specific platforms such as ASP.NET, ASP.NET MVC, .NET Core, WinForms, JavaScript, WPF, PHP, and Java. They are represented as NuGet, npm, maven packages or as separate ZIP archives.
The next enhancement is that after installing the report designer and login, you will see the Get Started window.
In this window, you can:
1. Download the demo application and report designer for JS. To do this, click the Show More button of the Apps block.
2. Install product packages by selecting a way of installing from NuGet, npm, maven, etc. or downloading a package as a zip archive. To do this, click the Show More button of the Develop block.
3. Open help resources such as documentation, videos, online samples of reports and dashboards and etc. To do this, click the Show More button of the Help block. The list of helpful resources can be found from the report designer File -> Help.
You can return to the Get Started window at any time from the report designer. You can do this from the File menu.
In the release 2019.3.2, we have made changes in the installation process of Stimulsoft products. Now, from the Downloads page of our website, you can download the next files:
1. The Report Designer for creating, editing and viewing reports and dashboards on devices with installed Windows operating system.
2. The JavaScript Report Designer designed using the NW.js, HTML5, and JavaScript technologies.
3. The Report Designer for MAC designed for creating, editing and viewing reports and dashboards on devices with installed macOS operating system.
4. The Stimulsoft demo application with reports and dashboards samples.
Also, you can download packages of our components for specific platforms such as ASP.NET, ASP.NET MVC, .NET Core, WinForms, JavaScript, WPF, PHP, and Java. They are represented as NuGet, npm, maven packages or as separate ZIP archives.
The next enhancement is that after installing the report designer and login, you will see the Get Started window.
In this window, you can:
1. Download the demo application and report designer for JS. To do this, click the Show More button of the Apps block.
2. Install product packages by selecting a way of installing from NuGet, npm, maven, etc. or downloading a package as a zip archive. To do this, click the Show More button of the Develop block.
3. Open help resources such as documentation, videos, online samples of reports and dashboards and etc. To do this, click the Show More button of the Help block. The list of helpful resources can be found from the report designer File -> Help.
You can return to the Get Started window at any time from the report designer. You can do this from the File menu.
We are pleased to announce the release of the new version Stimulsoft Reports and Dashboards 2019.3 which is now available for download. The new version comes with minor and major updates including the updated viewer, support for OData v4, significant changes in dashboards, etc.
Updated viewer
In the version 2019.3, we redesigned and updated the viewer.exe application. Now you may view reports and dashboards, and connect report collections from the local and cloud storage, create a list of favorite reports, call the report designer to design or modify reports and dashboards.
Variables for dashboards
In the new version, you can use variables when filtering data on dashboards. You can use variables with or without user selection or entry of values. Create a variable in the dictionary and add a filter for the dashboard items using this variable. When viewing the dashboard, the parameters panel will be displayed in the viewer if the user may select (enter) values.
Charts with drill down in the dashboard
In release 2019.3, you can create charts with drill down in dashboards. Specify the data fields in the chart arguments and set the drill down mode in the interaction editor. While viewing the chart, click the Drill Down button, select the chart values, and click the Drill Down Selected button to display the drill down of these values.
Interactive dashboard
Now, when selecting a value on a chart, map, or in a table of dashboards, you can display another panel with interactive data. Select an element, call the interaction editor, and define the Show Dashboard action. Also, you can transfer the data filtering parameter from the main panel of dashboards to another one.
Embed all data
Starting with release 2019.3, you can easily embed all created data sources into a report file. Each type of connection will be converted to a separate XML file and embedded in the report file as a resource. In that case, the connection of data sources will be redefined on this resource. To insert all data in a report file, select the Embed all data to resources command from the Actions menu of the data dictionary.
Saving a report with embedded data
In this new version, when you save a report or dashboard, you can embed all created data sources into a report file. In the Save as dialog, you should select the Report Template with Embedded Data. Each type of connection will be converted to a separate XML file and embedded in the report file as a resource. In this case, the relationship of data sources will be redefined on this resource. The report will be saved with this embedded data.
Snapshots of dashboards
We have added the functionality to save the dashboard with current data to the MRT file. In this case, the created data sources will be embedded in the report as resources. You may open this report both in the designer and in the report viewer.
Images by URL in the dashboard table
Now it is possible to display images received by URL in the Table element of the dashboard. By default, references from data fields are processed and displayed as text in the Table element. If you need to get images from these references and show them in the Table element, you should apply the Image() function to the expression of the current data field. If the link points to the SVG image, you can also determine the size of the image in the arguments of the Image (url, height, width) function. After that, the images will be obtained from the specified links and displayed in the Table element.
Export settings of a dashboard
In release 2019.3, for the dashboards and its elements, you can define export settings when exporting to PDF, Excel, image files, and data files. Select the required type of export and specify its settings.
OData v4 support
Starting with the release 2019.3, we support for the fourth version of OData. Now all the features of the new version of this protocol are available. The fourth version of OData is used by default. If necessary, you can use the previous version of the protocol.
Retrieving data from Google Sheets
In release 2019.3, you can get data from your Google Sheets repository. Create a connection from the report designer to your Google Sheets repository, retrieve the data and design reports and dashboards based on them.
The Azure Table Storage adapter
You may design reports and dashboards based on data obtained from the Azure repository. When creating a new data source, select the type of Azure Table Storage, get the data, design reports and dashboards based on them.
Updated Online map
We have made significant improvements in the Online map element, expanded the functionality of this element and optimized its work. Now you can display a geographical object not only by longitude and latitude but also by its location. Also, you can now specify a data field with the values of geographic objects, as well as adjust the color of geographic objects and culture.
New maps of Taiwan and China
We have updated the types of regional maps with Taiwan and China. Add a regional map component to a report or dashboard, and select the required map view.
Publishing to Angular
In release 2019.3, we added the ability to publish a report or dashboard for Angular 6 and 7. Call the Publish Wizard, go to the JavaScript tab, select the Angular platform, and change the version. Then save the package, unpack it, and integrate it into your application. The Publish wizard is used to embed a report or dashboard into your application in a few steps.
Change the element type of the dashboard
Starting with 2019.3, we have added the ability to change the type of an element of the dashboard without recreating it. Select an item in the dashboard panel, click the Change Type button, and select the type to which you want to convert the current element.
Data transformation in dashboards
We have added the ability for web report designers to convert data from the elements of the dashboard. Select the dashboard item; click the Browse button of the Data Transformation property to open the editor. In this editor, you will find the data fields used in the current item. You can define data sorting by fields, replace values, calculate a cumulative total, display a percentage, or apply a filter for this data.
Renaming pages and dashboards
Starting from this release, we have added the editor of the name and alias of the page or dashboard. Double-click on the title of the page or the dashboard and, in the window that opens change its name and alias.
New themes of dashboards
We have added two new themes to the dashboard panels. To change the design of the dashboard, select it, and select the desired theme in the menu of style change.
Updated viewer
In the version 2019.3, we redesigned and updated the viewer.exe application. Now you may view reports and dashboards, and connect report collections from the local and cloud storage, create a list of favorite reports, call the report designer to design or modify reports and dashboards.
Variables for dashboards
In the new version, you can use variables when filtering data on dashboards. You can use variables with or without user selection or entry of values. Create a variable in the dictionary and add a filter for the dashboard items using this variable. When viewing the dashboard, the parameters panel will be displayed in the viewer if the user may select (enter) values.
Charts with drill down in the dashboard
In release 2019.3, you can create charts with drill down in dashboards. Specify the data fields in the chart arguments and set the drill down mode in the interaction editor. While viewing the chart, click the Drill Down button, select the chart values, and click the Drill Down Selected button to display the drill down of these values.
Interactive dashboard
Now, when selecting a value on a chart, map, or in a table of dashboards, you can display another panel with interactive data. Select an element, call the interaction editor, and define the Show Dashboard action. Also, you can transfer the data filtering parameter from the main panel of dashboards to another one.
Embed all data
Starting with release 2019.3, you can easily embed all created data sources into a report file. Each type of connection will be converted to a separate XML file and embedded in the report file as a resource. In that case, the connection of data sources will be redefined on this resource. To insert all data in a report file, select the Embed all data to resources command from the Actions menu of the data dictionary.
Saving a report with embedded data
In this new version, when you save a report or dashboard, you can embed all created data sources into a report file. In the Save as dialog, you should select the Report Template with Embedded Data. Each type of connection will be converted to a separate XML file and embedded in the report file as a resource. In this case, the relationship of data sources will be redefined on this resource. The report will be saved with this embedded data.
Snapshots of dashboards
We have added the functionality to save the dashboard with current data to the MRT file. In this case, the created data sources will be embedded in the report as resources. You may open this report both in the designer and in the report viewer.
Images by URL in the dashboard table
Now it is possible to display images received by URL in the Table element of the dashboard. By default, references from data fields are processed and displayed as text in the Table element. If you need to get images from these references and show them in the Table element, you should apply the Image() function to the expression of the current data field. If the link points to the SVG image, you can also determine the size of the image in the arguments of the Image (url, height, width) function. After that, the images will be obtained from the specified links and displayed in the Table element.
Export settings of a dashboard
In release 2019.3, for the dashboards and its elements, you can define export settings when exporting to PDF, Excel, image files, and data files. Select the required type of export and specify its settings.
OData v4 support
Starting with the release 2019.3, we support for the fourth version of OData. Now all the features of the new version of this protocol are available. The fourth version of OData is used by default. If necessary, you can use the previous version of the protocol.
Retrieving data from Google Sheets
In release 2019.3, you can get data from your Google Sheets repository. Create a connection from the report designer to your Google Sheets repository, retrieve the data and design reports and dashboards based on them.
The Azure Table Storage adapter
You may design reports and dashboards based on data obtained from the Azure repository. When creating a new data source, select the type of Azure Table Storage, get the data, design reports and dashboards based on them.
Updated Online map
We have made significant improvements in the Online map element, expanded the functionality of this element and optimized its work. Now you can display a geographical object not only by longitude and latitude but also by its location. Also, you can now specify a data field with the values of geographic objects, as well as adjust the color of geographic objects and culture.
New maps of Taiwan and China
We have updated the types of regional maps with Taiwan and China. Add a regional map component to a report or dashboard, and select the required map view.
Publishing to Angular
In release 2019.3, we added the ability to publish a report or dashboard for Angular 6 and 7. Call the Publish Wizard, go to the JavaScript tab, select the Angular platform, and change the version. Then save the package, unpack it, and integrate it into your application. The Publish wizard is used to embed a report or dashboard into your application in a few steps.
Change the element type of the dashboard
Starting with 2019.3, we have added the ability to change the type of an element of the dashboard without recreating it. Select an item in the dashboard panel, click the Change Type button, and select the type to which you want to convert the current element.
Data transformation in dashboards
We have added the ability for web report designers to convert data from the elements of the dashboard. Select the dashboard item; click the Browse button of the Data Transformation property to open the editor. In this editor, you will find the data fields used in the current item. You can define data sorting by fields, replace values, calculate a cumulative total, display a percentage, or apply a filter for this data.
Renaming pages and dashboards
Starting from this release, we have added the editor of the name and alias of the page or dashboard. Double-click on the title of the page or the dashboard and, in the window that opens change its name and alias.
New themes of dashboards
We have added two new themes to the dashboard panels. To change the design of the dashboard, select it, and select the desired theme in the menu of style change.
Stimulsoft announces changes in system requirements for some products of Stimulsoft Reports and Stimulsoft Dashboards. Starting from the release 2019.2.2, you should have at least .NET Framework 4.5 and higher to work with our products.
We switched to the .NET Framework 4.5 due to significant enhancements in it. In particular, we are now able to support new data adapters. Also, migration to the latest version of the framework has enabled developers to improve support for sharing asynchronous and synchronous code.
If you want to continue using earlier versions of the .NET Framework, you can use previous versions of our software products.
We switched to the .NET Framework 4.5 due to significant enhancements in it. In particular, we are now able to support new data adapters. Also, migration to the latest version of the framework has enabled developers to improve support for sharing asynchronous and synchronous code.
If you want to continue using earlier versions of the .NET Framework, you can use previous versions of our software products.
We are pleased to announce the release of the new version Stimulsoft Reports 2019.2 which is now available for download. This release comes with the number of changes and updates which include the new product Dashboards.JS, a powerful, flexible data analysis tool for the JavaScript platform; our reporting tools now have Pareto chart, text in cells for JavaScript; dashboards are updated with the interaction functionality, Top N values and many more.
New product Dashboards.JS
We are glad to present a powerful, flexible and easily customizable data analysis and processing tool for the JavaScript platform. All that is needed is a JavaScript and HTML5 browser. Installing additional .NET, Java or Flash components is not required. Therefore, Dashboards.JS will work on most devices (from desktop computers to mobile devices). Dashboards.JS can work as a client-side solution, which means that there is no server side is required, as well as a server-side, can be used on the server side. The tool is perfectly compatible with Node.js. At the same time, the functionality of Dashboards.JS is no less than in other Stimulsoft products.
Pareto Chart
In the release 2019.2, when designing reports and dashboards, you will have the ability to create Pareto charts. This type of chart contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line.
Top N Values
In the new version, Chart, Indicator, Progress, Pivot elements for dashboards can display the top values. To do this, select an item in the dashboard panel, click the Browse button of the Top N property on the Property panel in the report designer. In the dialog, specify the number of top values and the mode above (top values) or below (low values). Also, other values that are not included in the list of top values can be summed up and displayed as a separate element as a chart, progress or indicator.
Disabling columns in Table
Starting with the release 2019.2, you can disable displaying the column in the Table element of dashboards. In order to apply this, select the data field in the element editor and uncheck the Visible option.
Hyperlinks in values of a table
In the new version, you can set hyperlinks, if the field type is defined as a Dimension, for data field values. To do this, select the data field in the Table element editor, select the Hyperlink checkbox and specify the address. Now in the report viewer, when you click on any value of this data field, you will be taken to the specified hyperlink. Each data field can specify its own hyperlink.
Interaction
We have added the ability to customize interactive actions when viewing the dashboard. Depending on specific user actions, a hint can be displayed, data filtering is applied, and transition by a hyperlink. Interactively actions can be defined for items such as the Chart, Regional Map, and Table. The setting of interactive actions is carried out in the interaction editor. For a chart and a map, you can open this editor by selecting the element and clicking the Browse button on the Interaction property on the Property panel. For the Table element, you can disable sorting and filtering in the Table headers in this editor. To configure the interactive actions of the data fields of the Table element, you should click the Edit button in the editor of this element.
Abbreviations in formatting
Starting with release 2019.2, you can use abbreviated numbers with numeric and currency formatting in reports or dashboards. For example, for thousands of values you may use the abbreviation K, for millionths - M, for billionths - B. To enable the use of abbreviations of values, set the checkbox next to Use Abbreviation in the format editor.
Negative red
In this version, you can highlight in red all negative numbers with numeric, currency, and percentage formatting. This functionality will work for both reports and dashboards. To do this, set the checkbox next to Negative in Red in the format editor. Now all numbers that are less than zero will be marked in red (see the picture below).
Export to JSON
Starting with the release 2019.2, we have added exporting a report to such a data format as JSON. To convert the report, click Save in the report viewer, select the item Data File... and select the JSON as the file type. You can export a whole report or only data or data with header and footers.
Exporting tables to Data
For the Table element of the dashboard, you now can export data of various types to files. To do this, when viewing the dashboard, click the Save button on the Table element and select the Data item. In the export settings menu, choose the type of data file (CSV, DBF, XML, JSON, DIF, SYLK) to which the contents of the Table element should be converted.
Export settings
In the version 2019.2, we have added the export settings when exporting dashboards or their elements to various formats. With these settings, you can change the page size, orientation, image quality, image type, scale. Export settings are displayed to the user in a pop-up dialog, after selecting the export command and before starting the process of converting dashboards or their elements.
Editing the rendered dashboard
We have added the Edit button in the dashboard preview. This button calls the report designer and opens the rendered dashboard in it. In the report designer, you can edit that dashboard and save the changes. You will these changes in the viewer. The editing mode of the rendered dashboard is possible only if you set the Calculation Mode property to Interpretation before the rendering.
Calculation of totals by condition
In the release of 2019.2, it became possible to use the functions of calculating totals with the condition in the elements of dashboards. The SumIf(,) function is used to sum the data field values by a condition, and the CountIf(,) function is used to count the number of values in a data field by a condition. The first argument in these functions is the data field, and the second is the condition for fetching values.
Text in cells in Reports.JS
A new component Text in Cells has been added to Reports.JS. Now you can use this component for designing reports. In order to add this component, select Text in cells on the toolbox or in the Insert tab, in the Components group and put it on the report page.
New product Dashboards.JS
We are glad to present a powerful, flexible and easily customizable data analysis and processing tool for the JavaScript platform. All that is needed is a JavaScript and HTML5 browser. Installing additional .NET, Java or Flash components is not required. Therefore, Dashboards.JS will work on most devices (from desktop computers to mobile devices). Dashboards.JS can work as a client-side solution, which means that there is no server side is required, as well as a server-side, can be used on the server side. The tool is perfectly compatible with Node.js. At the same time, the functionality of Dashboards.JS is no less than in other Stimulsoft products.
Pareto Chart
In the release 2019.2, when designing reports and dashboards, you will have the ability to create Pareto charts. This type of chart contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line.
Top N Values
In the new version, Chart, Indicator, Progress, Pivot elements for dashboards can display the top values. To do this, select an item in the dashboard panel, click the Browse button of the Top N property on the Property panel in the report designer. In the dialog, specify the number of top values and the mode above (top values) or below (low values). Also, other values that are not included in the list of top values can be summed up and displayed as a separate element as a chart, progress or indicator.
Disabling columns in Table
Starting with the release 2019.2, you can disable displaying the column in the Table element of dashboards. In order to apply this, select the data field in the element editor and uncheck the Visible option.
Hyperlinks in values of a table
In the new version, you can set hyperlinks, if the field type is defined as a Dimension, for data field values. To do this, select the data field in the Table element editor, select the Hyperlink checkbox and specify the address. Now in the report viewer, when you click on any value of this data field, you will be taken to the specified hyperlink. Each data field can specify its own hyperlink.
Interaction
We have added the ability to customize interactive actions when viewing the dashboard. Depending on specific user actions, a hint can be displayed, data filtering is applied, and transition by a hyperlink. Interactively actions can be defined for items such as the Chart, Regional Map, and Table. The setting of interactive actions is carried out in the interaction editor. For a chart and a map, you can open this editor by selecting the element and clicking the Browse button on the Interaction property on the Property panel. For the Table element, you can disable sorting and filtering in the Table headers in this editor. To configure the interactive actions of the data fields of the Table element, you should click the Edit button in the editor of this element.
Abbreviations in formatting
Starting with release 2019.2, you can use abbreviated numbers with numeric and currency formatting in reports or dashboards. For example, for thousands of values you may use the abbreviation K, for millionths - M, for billionths - B. To enable the use of abbreviations of values, set the checkbox next to Use Abbreviation in the format editor.
Negative red
In this version, you can highlight in red all negative numbers with numeric, currency, and percentage formatting. This functionality will work for both reports and dashboards. To do this, set the checkbox next to Negative in Red in the format editor. Now all numbers that are less than zero will be marked in red (see the picture below).
Export to JSON
Starting with the release 2019.2, we have added exporting a report to such a data format as JSON. To convert the report, click Save in the report viewer, select the item Data File... and select the JSON as the file type. You can export a whole report or only data or data with header and footers.
Exporting tables to Data
For the Table element of the dashboard, you now can export data of various types to files. To do this, when viewing the dashboard, click the Save button on the Table element and select the Data item. In the export settings menu, choose the type of data file (CSV, DBF, XML, JSON, DIF, SYLK) to which the contents of the Table element should be converted.
Export settings
In the version 2019.2, we have added the export settings when exporting dashboards or their elements to various formats. With these settings, you can change the page size, orientation, image quality, image type, scale. Export settings are displayed to the user in a pop-up dialog, after selecting the export command and before starting the process of converting dashboards or their elements.
Editing the rendered dashboard
We have added the Edit button in the dashboard preview. This button calls the report designer and opens the rendered dashboard in it. In the report designer, you can edit that dashboard and save the changes. You will these changes in the viewer. The editing mode of the rendered dashboard is possible only if you set the Calculation Mode property to Interpretation before the rendering.
Calculation of totals by condition
In the release of 2019.2, it became possible to use the functions of calculating totals with the condition in the elements of dashboards. The SumIf(,) function is used to sum the data field values by a condition, and the CountIf(,) function is used to count the number of values in a data field by a condition. The first argument in these functions is the data field, and the second is the condition for fetching values.
Text in cells in Reports.JS
A new component Text in Cells has been added to Reports.JS. Now you can use this component for designing reports. In order to add this component, select Text in cells on the toolbox or in the Insert tab, in the Components group and put it on the report page.