We continue to tell you about the new version of Stimulsoft Reports and Dashboards 2022.1 and about new features and improvements, which are already available for our users. Before, we wrote about 3D Pie chart, and new barcodes. Today, we will tell you about new features of data transformation.

What is data transformation

The Data Transformation is a tool in the report designer, which is intended to create a new data description in a table. The thing is that data in the dictionary is contained in a structured view, more often in tables. When creating reports you should combine data from various tables to group, filter them, and calculate totals, etc. To do that, you can write a sql query with suitable parameters or for example, change data structure in a source. The Data transformation allows you to make such actions using visual methods.

New features of the 2022.1 version

Since the 2022.1 version, a new feature was added to the Skip and Limit Rows action and in the Data Transformation tool. Apart from such values as Apply till data transformation and Apply after grouping data, Apply after grouping and sorting data value was added. In this case, limit rows will be applied after grouping data according to the specified sorting.

New Features of Data Transformation

How it works

Let's look at the example of work of this new feature.

In case of using the Apply till data transformation, limit and skip rows will be applied to original data, i.e data in the order where they are placed on the storage.

In the Apply after grouping data mode skip and limit of rows will be applied to data, which are already grouped by some reason in transformation. It's worth noting, that when grouping data are sorted from A to Z. Custom sorting, which is set in data transformation will not be considered.

In the Apply after grouping and sorting data mode, limit and skip rows will be applied as well as in the mode of applying after grouping, only considering custom sorting in data transformation. In other words, firstly data will be grouped, then sorted and limit and skip rows will be applied.

Watch a video about this new feature of data transformation. If you have any questions, contact us.

We continue our story about the new version of Stimulsoft products 2022.1, which was released on December 8. Earlier, we have already talked about a three-dimensional pie chart and showed the principle of its design. Next in line are new barcodes in Stimulsoft report and dashboard tools.

Introduction

Barcode is one of the best ways to store and read information. They are also widely used in reporting tools.

Barcodes are of two types: linear (1D) and two-dimensional (2D). Linear barcodes are a series of parallel black and white stripes of varying widths, and information is read-only horizontally and in small quantities. 2D barcodes, on the other hand, contain information both horizontally and vertically to encode large amounts of data - up to several pages of text. Two-dimensional barcodes include, in particular, DataMatrix, Maxicode, and, perhaps, the most famous QR code today.

In the Stimulsoft reporting tool

you can create the documents, which contain a barcode:
  • Checks;
  • Labels;
  • Various contracts and others, including postal documents, which are designed using barcodes.

On labels, barcodes are used to quickly check the goods against the database, on receipts - for control, and so on. In addition, the report designer provides work with postal barcodes. The main difficulty here lies in the fact that each country has its standards for its design.
Kinds of Barcodes

Kinds of barcodes in Stimulsoft

The report designer contains 5 basic barcode categories:
  • Two-Dimension;
  • EAN/UPC;
  • GS1;
  • Post;
  • Others.

Additionally, each of them has many subcategories.

Here is the visual example of using a two-dimensional barcode one when creating a report with Invoice and with labels:

Switzerland Invoice
Labels

New barcodes in the version 2022.1

We added new types of barcodes: Intelligent Mail USPS 4-State and Aztec to version 2022.1 of Stimulsoft Reports and Dashboards.
  • Intelligent Mail USPS 4-State is used to sort mail in the US Mail Service automatically;
  • Aztec is used in railways, airlines, government documents, and automatic data recognition.

Let's figure out how to work with the new barcodes in our reporting tool.

New Barcodes

The editor contains the following options:


Type

It allows you to change one type of barcode to another.

Code

Using this option, you will be able to type a value, which will be encoded by a barcode. You can type a value as text, number, or expression.

Angle

This option allows you to set the barcode rotation angle. It has 4 tilt levels - 0 degrees, 180 and 270. With each tilt, your barcode will change.

Auto scale

The option allows you to stretch a graphic code within the barcode component, respecting its aspect ratio.

Fore color and Back color

The option is applied to change the barcode text color and its background.

Font

It sets a font for a barcode and defines its style and size.

Show Label Text

Having activated the option, you will be able to display some signature for your barcode.

Show Quiet Zones

Quiet Zones is the empty space to the left and right of the barcode and is the conditional start and end of the barcode for readers. This option enables or disables the Quiet Zones barcode.
We have prepared a video about the new barcodes for you. It is available on our YouTube channel - watch, leave comments, subscribe.

We hope that this article was helpful for you and now you know a little more about the new barcodes of the last version of Stimulsoft products. If you have any questions, contact us – we are glad to help you!

2021 was a hectic and productive year for our company. This year we have released two new products:


Reports.Blazor

Stimulsoft Reports.Blazor is a cross-platform tool designed to integrate applications using the Blazor framework. Our components support all the main features of Blazor, and can work both on the server-side and the client-side using WebAssembly technology. In Reports.Blazor, you may connect SQL, NoSQL, REST data sources and retrieve data from Google, Azure, Data.World, Quickbooks. All you need to work with the product is any modern browser.
Reports.Blazor

Dashboards.PHP

Stimulsoft Dashboards.PHP is a new product in the line of tools for creating dashboards. You may use it to integrate seamlessly into your applications and as a standalone solution. At the same time, no complex configuration or third-party modules are required - the complex can be easily integrated into almost any PHP application.
Dashboards.PHP

Blockly in Stimulsoft Tools

Blockly is a visual programming tool from Google integrated into our reporting tools for scripting events. With its help, you can create various scenarios visually without writing any code. The event script created using Blockly will be universal for all our software, and, accordingly, the generated report will work in both WinForms and JS report designers.
Blockly

Blockly Components




Several charts in one

For the Chart element in dashboards, you can specify up to 5 views. Each view is a separate type of diagram, and their switching is carried out in the viewer. The views are configured in the editor of the Chart element on the additional parameters panel.
Several Charts in One

Pie chart now in 3D

A new feature you will like is a 3D pie chart - just look at it. The new type of chart has all the same capabilities. The appearance allows you to expand the visualization of data series and visualize the necessary data more clearly and visually.
3D Pie Chart

Straight ahead

We are constantly keeping up with the times, so our products:

  • support work under Windows 11;
  • tested and work under .NET 6.0;
  • support all current versions of the Angular platform - 10, 11, 12, 13;
  • and the source codes are fully compatible with Visual Studio 2022.
Windows 11, .NET 6.0, Angular 13

Math formulas in reports

By the way, you can use mathematical formulas in reports. They are arranged in groups in the editor, where each group is presented on a separate tab. You can also specify a formula using LaTeX syntax.
Math Formula




New data adapters

We also have new data adapters - Google Analytics, Azure SQL, and Azure Blob Storage. With their help, you can build complex and functionally rich reports and dashboards, including web analytics reports. Also, we added support for PDO data adapters for PHP.
Data Adapters

New functionality

A few more new things will make your work with our products even more convenient and fast. Reports can now be built and sent by schedules; you may add watermarks, transparency of elements to dashboards; variables have new capabilities; optimization of JS scripts (the total volume of code reduction is about 20 percent) affected Reports.JS, Dashboards.JS, Reports.PHP, and Dashboards.PHP.
JS Optimization

Thank you for being with us! See you in 2022!


See you in 2022!
The security of software and personal and commercial information safety is the most critical issue in the modern world.
Log4j

What is Log4j?

Log4j is a popular Java-based logging utility used to write logs. The library is part of the Apache Registration Project.

What happened?

On December 9, 2021, it became known about the critical vulnerability of Log4j – CVE-2021-44228. It may execute arbitrary code, which can lead to data leaks. The vulnerability affected a massive number of projects - from iCloud to Steam.
Security

How does this concern you as a Stimulsoft client?

The problem related to the Log4j vulnerability can affect users of only one product - Stimulsoft Reports.Java. However, our product does not directly use the Log4j library.

To work with SVG images, we use the Apache ™ Batik SVG Toolkit library, which uses commons-logging, which, in turn, can interact with Log4j (if your system is configured for this).

What do you have to do?

The vulnerability has already been fixed in Log4j 2.12.2 and Log4j 2.17.0. If you are running Java 8 (or later), please update Log4j to version 2.17.0. Users requiring Java 7 should upgrade Log4j to release 2.12.2.

Otherwise, remove the JndiLookup class from the classpath:
zip -q -d log4j-core-*.jar org/apache/logging/log4j/core/lookup/JndiLookup.class

Please note that this vulnerability impacts only the log4j-core JAR file. This vulnerability does not impact applications using only the log4j-api JAR file without the log4j-core JAR file.
A week ago, a new version of Stimulsoft products 2022.1 was released. In this version, we realized many new features and improvements. Some of them were presented here and here. Today it's high time to tell you about a new type of chart – 3D Pie chart.

Introduction

A 3D or three-dimensional pie chart is a separate type of chart. It is available in the report designer in the chart selection menu and has all features of a pie chart.
3D Pie Chart - Menu

3D Pie chart in the report designer

So, let's figure out how this type of chart works in our product. Data for this chart is specified as well as for a basic 2D chart. In this article, we will consider how to set the appearance of the chart. However, first of all, let's check out how the element looks like:

3D Pie Chart

Chart appearance is set using the 3D Options property group

The following 3D options are presented on the properties panel - Distance, Height, Lighting and Opacity. Using them you can set a 3D Pie chart. Let's briefly go over all the options.
3D Pie Chart - Options

Distance

It regulates the distance between chart segments, that first of all changes chart appearance.
Distance

Height

The Height property allows you to change the thickness of chart segments, having added visual volume to them.
Height

Lighting

Setting of chart fill. Three options of filling are available: no (no fill), solid (one color fill), and gradient (transition from one fill color to another).
Lighting

Opacity

This option changes the transparency of chart segments.
Opacity

We prepared several samples of reports for you, where a 3D pie chart is used



3D Pie chart interaction

The functionality of the basic pie chart was transferred to the 3D version. Now it has the same properties of interaction:

Filters

This functional feature allows you to filter element data by related fields. This way, chart elements interact in dashboards, and related data are displayed.

Tooltips

In this case, tooltips are additional information displayed when hovering the cursor over some elements. The following tooltips are available for dashboards: hyperlink, value, text, and their combinations.

TopN

The option is used to filter data of chart elements by displaying a certain number of maximum and minimum values.

Open hyperlink

To open a hyperlink, you should click the left mouse button on a chart segment.

Drill-down

Drill-down in dashboards is the process of going to the lower or upper level in the hierarchy of chart data elements. This feature is applied to call a drill-down template page or an external report.
In addition, please watch a video on our YouTube channel, where the process of working with a 3D pie chart in reports and dashboards is described in detail.

We hope that this article was helpful for you, and now you are able to use a 3D pie chart in reports and dashboards. If you have any questions, contact us – we are glad to help you!
By using this website, you agree to the use of cookies for analytics and personalized content. Cookies store useful information on your computer to help us improve efficiency and usability. For more information, please read the privacy policy and cookie policy.