black
We are pleased to announce the release of the new version Stimulsoft Reports and Stimulsoft Dashboards 2021.1, which is now available for download. This major release comes with the .NET Core compilation, the ability to get data from Google BigQuery and use PDO drivers for PHP, a new robust Table of Contents component, and many new features for Table, Pivot, List Box, and other components.

Compilation in .NET Core
In the new version, when using the .NET Core framework, we have added support for compilation for reports. Now you can use all the reporting tool features like compilation at runtime, functions, publishing reports as classes. Compilation for .NET Core 3.1 is only available on Windows systems, and .NET 5.0 is available on all supported systems.

compilation in net core

The new component - Table of Contents
In the 2021.1 release, we added a new report component - Table of Contents. This component will help you create an interactive table of contents for your report without writing any code or scripts. Just add it to the template and mark the report component for which you want to generate content. When the report is rendered, a table of contents with navigating the report will be generated.

The new component - Table of Contents

The new adapter - Google BigQuery
Starting with this release, directly from the report designer, you can connect to the online service - Google BigQuery. To do this, in the data source creation window, select the BigQuery type, fill in the data storage access fields or use an authorization file. Once you have the data, you can create reports and dashboards from it.

The new adapter - Google BigQuery

Cross-filtering of elements
Starting with release 2021.1, you can define whether to filter data from other elements to the current element. Each dashboard item now has the Cross-Filtering property. If this property is set to False, then filters from other elements will not affect the current element.

Cross-filtering of elements

Horizontal filtering
The List Box filtering element is available in the report designer since the first release of dashboards. It is a vertical list of values on the dashboard panel by which you can filter dashboard data. Starting with release 2021.1, you can display the values of a List Box item as a horizontal list of values. Open the element editor and set the Orientation parameter to Horizontal.

Horizontal filtering

The new functionality for Table
Starting with version 2021.1, we have expanded the capabilities of the Table element in the dashboard. For the Table element, you can specify the required number of fixed columns that will not change their width. For each column of the table, you can set its width or range of width and enable the ability to wrap words in the column. Besides, when viewing a dashboard with a Table element, you can change the columns' order by simply dragging the column to the required location.

The new functionality for Table

The new functionality for Pivot
Now, when using the Pivot element on the dashboards, you can flexibly customize it. First, as for the Pivot element, you can specify the column width and enable wrapping the words. Second, you can disable displaying totals for columns or rows of the Pivot element, and, if necessary, you can change the header of the summary column or row.

The new functionality for Pivot

Support for PDO data adapters for PHP
The new version comes with support for PDO drivers for all data adapters available in PHP. To use them, it is enough to specify the correct DSN prefix in the connection string, for example, "mysql:" or "sqlsrv:", and the data adapter will define the connection type.

Support for PDO data adapters for PHP

Team management from the designer
Now you can manage your user team directly from the report designer. Open the File menu, select Account, and the Team tab. Here you can add, edit, and remove your team members. The Account item also includes other settings and commands for managing the current account, which you may find on separate tabs.

Team management from the designer
Flash to HTML5
We have decided to completely end support for Flash in our components. Starting with version 2020.3.1, all components using Flash technology have been deprecated. We offered some recommendations on how to replace those components with HTML5 and JavaScript components. In the next release 2020.5.2, all Flash components will be removed.
white
We are pleased to announce the release of the new version Stimulsoft Reports and Stimulsoft Dashboards 2020.5.1, which is now available for download. This release comes with several improvements including .NET 5.0 compatibility, ability to connect to Google Firebase, support for the Box and Whisker chart, etc.


Expressions in properties

Starting with version 2020.5.1, you can use expressions as values for some properties of report components and dashboards. Depending on the result of calculating the expression, the component property will be set to a specific value. By using expressions as a property value, you can customize the condition of printing a component, the style of its content, and more.

Expressions in properties

.NET 5.0 compatibility

We are glad to announce that starting from version 2020.5.1 we have added support for the .NET 5.0 RC1 framework for our WinForms and WPF components. Also, the minimum required .NET Core version was increased from 3.0 to 3.1; the minimum version for the .NET Framework remained 4.5. Our Web components support .NET Standard 2.1, which is backward compatible with the .NET 5.0 framework. We closely follow the development of the .NET platform and do our best to ensure that our reporting and analytical components are compatible with the latest technologies.


Bubbles

For the Table element on the dashboard, we added a new column type - Bubbles. Each value in the data column will be represented as a separate bubble, the size of which depends on the value that you set. Bubble colors for positive and negative values can be specified in the style of the current element or by the user in the element editor.

Bubbles

Sharing reports on Facebook and Twitter

In the 2020.5.1 release, we added the Share command. Sharing your report or dashboard is not as easy as ABC! Also, now you can publish it directly to a social network - Facebook or Twitter.

Sharing reports on Facebook and Twitter

The new chart - Box and Whisker

In the 2020.5.1 release, we have added a new Box and Whisker chart. You may use this type of chart to display groups of numeric data using quartiles. Just add a diagram to your report or dashboard and analyze your data.

The new chart - Box and Whisker

The new adapter - Google Firebase

Starting with the 2020.5.1 release, you can get data from Google Firebase. When creating a new data source, select the connection type - Firebase, specify the Data URL and Database secret. After that, all data from the specified data storage will be converted into tables, based on which you may design reports and dashboards.



The new data source - GIS

In the last release, we added the ability to display graphical information on an online map. In the new release 2020.5.1, we decided to go further and developed the ability to create a GIS data source based on WKT or GeoJSON files. You can use the obtained data in online maps to display graphical information.

The new data source - GIS

The new functionality for GIS

In release 2020.5.1, we have improved the GIS map, and now you cannot only display primitives on an online map but also define their color and size. To do this, in the online map editor, you should specify the data columns with the color and size encoding in the appropriate fields. Also, for Point primitives, you can display tooltips as additional information. To make this work, you should specify the data column with the description text in the Description field of the editor. Then, when you hover the cursor over a point on the map, you will see the additional information in the tooltip.

The new functionality for GIS

The updated Image element

Starting with the 2020.5.1 release, we have improved the Image element for dashboards. This dashboard element has changed from static to dynamic. Now you can get images from data columns, variables, and files using hyperlinks.

The updated Image element

Conditional formatting

In this release, we have expanded the data analysis capabilities for the Table and Progress elements of the dashboard. You can now apply conditional value formatting to these elements.

Conditional formatting

Sparkline styles

In the previous release, we added a new component for reporting - Sparkline. In this version, you can apply styles to this component. Create a style of the Indicator type, configure it, and use the Component Style property to assign this style to the sparkline.

Sparkline styles

Sparkline colors in dashboards

You can use sparklines in dashboard tables from the first release of the product. By default, the colors for table sparklines are assigned from the element style. In the 2020.5.1 release, we added the ability to customize table sparkline colors from the element editor. Open the Table editor, select the sparkline column, set the Color parameter to Custom, and specify the colors for the values of this column.

Sparkline colors in dashboards

The new map - Oceania

In the release 2020.5.1, we have added a new type of a regional map - Oceania. Now you can use this map for designing reports and analytical panels.

The new map - Oceania

ZUGFeRD v2.1 support

Since 2016, Stimulsoft components support the ZUGFeRD format when exporting to PDF. In the 2020.5.1 release, we added support for the new specification of this format - ZUGFeRD v2.1.
black
Conditional formatting of components is very often used when designing reports and dashboards. Conditional formatting implies changing the appearance settings of components, depending on the specified condition. This functionality allows you to efficiently perform visual data analysis, track data trends, exclude specific values in the report, and yon the dashboard.

Expressions in properties

In the 2020.5.1 release, we simplified the ability to apply conditional formatting to report components. Now you can specify an expression in the values of some properties of a report component or dashboard item. As a result of calculating this expression, some appearance settings will be applied to the component.

Expressions in properties
In the new version, using expressions as property values, you can specify a condition:
  • to apply a style to the report component, and for the Data bands, you can set the conditions for applying the styles for even/odd lines;
  • to change the settings of the Brush and Text Brush properties for report components;
  • to change the settings of the Fore Color and Back Color properties for dashboard elements;
  • to change the settings for vertical and horizontal alignment properties for text components in reports;
  • to apply the Dock Style to the component;
  • to change the rotation angle of the content for the Image component.

Besides, we have added support for expressions in properties such as Enabled and Printable. Now you can specify a condition for enabling and disabling a report component or dashboard item. And also, set up the condition for printing report components.
Dear users of Stimulsoft software and readers of our blog! We are improving our reporting software and business analytics tools and are pleased to announce the upcoming release 2020.5 of Stimulsoft software.

The new version will contain multiple updates and enhancements. We are going to unveil some of them on pages of our blog. If you have some questions, please contact us, we are glad to help you.

Conditions in Progress element

Competent business analytics gives an opportunity to make rational decisions. With the help of data analytics many companies can track their performance: for instance they can calculate the number of produced product, build sales funnels, analyze financial performance, compare current results with last years results and on the basis of this engage strategic marketing.

Day in and day out, we work on the tools for dashboard and reports development and constantly improve our products. Today we are glad to introduce you a new Progress element`s feature – Conditions, which will be available in the next release 2020.5 version.

This feature has a wonderful property, depending on a chosen condition you can change a current element`s font style, color of its meaning, and track`s color. This is an excellent feature for business analytics and KPI tracking.

Conditions