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!
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!
We continue to tell you about innovations of the latest release of Stimulsoft Reports and Stimulsoft Dashboards 2021.4. This time we will tell you about Scheduler.

What is Scheduler for?

Using Scheduler, you can automize the process of report export, report saving to the local storage and sending the result by email according to a schedule.
In the Stimulsoft Designer application, Scheduler of Windows operating system is used to automate processes.Let`s figure out, how this tool works in our designer.

How to use Scheduler in the report designer

First of all, you should create a new report and save it. In case of automating work on a previously created report, you shouldn`t save it again, if you didn`t make any changes.

After, you should go to the Scheduler control tab. To do that, you should select the Schedule in the File menu.

Schedulers List
Schedulers are controlled here: you can create a new one, edit an existing one and view triggering logs.

In this case, a log is an extended history of a scheduler, where all processes of running and forced stopping of the tool will be displayed. Besides, each scheduler has an indicator on this tab, green color means that triggering without failures, red color informs you about violations in the work of the tool.

In addition, except a set schedule, any scheduler can be run forcibly using a special command.

To create a scheduler, you should click the New Scheduler. After, you should define its type and parameters of your schedule.

Scheduler Monthly

Scheduler actions

However, the process of automating will not be complete if a scheduler is not assigned a task to perform. Scheduler`s tasks are defined by its actions and can be of two types:

  • Run a report;
  • Send by Email.

One scheduler can do up to 15 actions. The number of schedulers is not limited. This way, the process of automating can be quite global.

The Run Report action requires you to specify a local place to save the result of its transformation. If a report contains parameters, which require user`s values, you can define them using the menu of parameters.

The Send by Email task allows you to send the result of the Run a report to a specific list of contacts by Email with an ability to specify theme and text of your letter. Moreover, in one such action, more than one result from different actions Run a report can be attached.

Scheduler Send Email
Please, note that to send some emails, you should specify settings of smtp-server in the report designer parameters.More detailed information about each type and settings of Scheduler, you may find in the documentation.
Also, we offer you an overview video lesson on the topic.



We hope, that this article was useful for you and now you will be able to use Scheduler and without any problems send your reports and dashboards by email when you want to. If you have any questions, contact us – we will be glad to solve your problem.
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.