By using this site you agree to the use of cookies for analytics and personalized content.
I agree Learn More

Halloween Spooky Sale. 20% Off.

News
Published on 30 October 2018

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
Halloween is just around the corner! We love Halloween, and we love that feeling: the cold air, the spooky dangers lurking around the corner.

We have prepared a fantastic Halloween offer for you. You may buy a license or upgrade your current subscription with 20% discount. The Spirit Halloween promo code is HW2018. It will be applied automatically. If you do not see the code applied, please enter it  manually in the coupon code field.

Go to the online store and use this special offer! It’s no apparition, but it will disappear...
The Halloween sale begins now and ends at nightfall November, 02.

BOO!

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
We are pleased to announce the release of the new version Stimulsoft Reports 2018.3 which is now available for download. We have prepared a number of changes that you will be able to immediately use in your projects. The most important changes are the brand new products Dashboards.WIN and Dashboards.WEB, the Data Transformation tool etc.

The new product Dashboards.WIN
In the release of 2018.3, we are glad to announce the release of the first version of a full-featured tool for transforming, analyzing, grouping, filtering, sorting and displaying data for the .NET Framework. For data processing and their display, you may use various types of charts, embedded and online maps, indicators, progress, table, joined tables, gauges. Also, the elements of design and additional information text, images, various shapes can be placed on the dashboard. The data processing elements can be relative in the dashboard or they can be separate groups of relative elements. Integration of the dashboards elements into the user application is quite easy and can be done in a few steps.

The new product Dashboards.WIN

The new product Dashboards.WEB
Also, in the version 2018.3, we added the powerful, flexible and easily customizable data analysis tool for ASP.NET, ASP.NET MVC, .NET Core platforms. The server side performs all the necessary actions for transforming, analyzing, grouping, filtering, sorting data, using .NET 4.0 or higher. The client side receives the finished result from the server and represents it in the form of interactive HTML5 elements on the viewer page. The dashboards are created in the HTML5 report designer, and they are displayed in the HTML5 viewer. When editing dashboards, HTML5 designer requests only the necessary information on the server side, which allows you to optimize editing of dashboards and speed up the work with its elements.

The new product Dashboards.WEB

The new Data Transformation tool
Starting with release 2018.3, you can use the Data Transformation tool to create a virtual data table. Using this tool, you can combine data tables from various sources, group, filter, sort, aggregate these data, change their type, replace values in the columns of the new table, specify the range of rows in the new table. The converted data table can be used in reports and dashboards. To call the data transformation editor, in the data dictionary, select the New Data Transformation command from the context menu or the New Item menu.

The new Data Transformation tool

The updated New Relation editor
Now, when creating a relation between data sources in the dictionary, the updated link editor will be used. In this editor, the main and subordinate data sources are selected, as well as the data columns which will be used for the connection between these sources are specified. The new Active Relation parameter is added to the New Relation editor. This parameter is used to define the relationship that will be used when creating a new data transformation and dashboards. Besides, the editor of relations has built-in checks, and in case of non-compliance with the restrictions on building a relationship, a message will be displayed to the user. Multiple columns are selected using the Ctrl key.

The updated New Relation editor

Updated Map component
In the 2018.3 release, we have completely redesigned the Map component. The geographic map items and their attributes, as well as the editor of the Map component, have been optimized. Besides, we added a new type of map – Online. Now you can display any objects by coordinates, using the online Bing map. Put the Map component on the report page, go to the Online tab in the editor and specify the data columns with the coordinates of the objects.

Updated Map component

Updated Gauge editor
In the release of 2018.3, we significantly simplified and optimized the editor of the Gauge component. In the editor, you can select the type of a gauge, circle, semicircle, column, and also define the range of values. You can switch to the old Gauge editor in the report settings.

Updated Gauge editor

Line spacing
Now, when working with text components, you can set the line spacing. You can do this using control commands in the menu on the Ribbon panel by selecting a predefined value, or you can set any interval value using the Line spacing property that you may find on the Property Panel.

Line spacing

Saving and opening a report page
Now in JS Designer you can save and open a report template page. The commands for saving and opening the report template page are located in the context menu of the page header in the report designer.

Saving and opening a report page

Excel formulas in Reports.JS

Now when exporting reports to Excel, you can use Excel formulas to calculate the values of text components. To do this, select the text component in the report designer and specify the Excel formula in the Excel Value property of this component. When building a report, for each text component, some copies of this component are created equal to the number of values in the source. When exporting the report to Excel, for each copy, the value will be calculated using the specified formula.

Excel formulas in Reports.JS

Maps in .NET Core
Now, when designing reports in .NET Core, you can use the Maps component. Using this component, you can display a value for a specific geographic element or specify a geographic object by coordinates using the online Bing map.

Maps in .NET Core

Custom fonts for Java and .NET Core
In release 2018.3, we added the ability to use custom fonts in the report. To do this, drag the font file (TTF, OTF) to the report Data Dictionary. Custom fonts will be added to the font collection that can be applied to the text components of the report.

Custom fonts for Java and .NET Core

We Update Our Privacy Policy

News
Published on 28 May 2018

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
We have made some improvements and updates to our Privacy Policy and Terms of Use to make it easier for you to understand what information we collect, why we collect it, and how we use it. These changes were made according to the new General Data Protection Regulation (GDPR) that came into effect in the European Union on May 25th 2018.

By continuing to use the Stimulsoft website and its services on or after May 25, 2018, you indicate that you have read, understand and accept the Privacy Policy and Terms of Use. If you have any questions about these changes, please send your questions to info@stimulsoft.com.

If you are not subscribed to the Stimulsoft newsletter but want to receive the latest email news, like our major release notes, subscription renewal reminders, marketing promotions and discounts, please kindly use the form below to confirm your consent on this.

Please fill out this form the get
news from Stimulsoft


 
I read the privacy policy and agree to subscribe to the news

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
We are pleased to announce the release of the new version Stimulsoft Reports 2018.2 which is now available for download. We have prepared a number of changes that you will be able to immediately use in your projects. The most important changes are expanded functionality for work with resources, custom fonts, the new style editor, access to reports and many others.

Resource Panel in Viewer
Now documents (PDF, Word, Excel, etc.) and images added to the report resources can be displayed in the viewer. To do this, select the checkbox for the Available in the Viewer option in the Edit Resource dialog or when creating it. After that, this resource will be displayed in a separate panel in the viewer window or in the preview tab. Also, it can be viewed or saved to a file in the viewer.

Resource Panel in Viewer

Custom Fonts in Reports
The release of 2018.2, we added the ability to use custom fonts in the report. To do this, drag the file with fonts (ttf, otf) to the Dictionary of the report. In the font collection, you will add custom fonts that you can apply to the text components of the report.

Custom Fonts in Reports

New Style Editor
We have completely redesigned the style editor. Collections and styles are now displayed in a hierarchical form. Use drag’and’drop to change the collection for the style. Also we added filters and sorting styles. In addition, all the styles used in the report are checked with markers in the style editor. Also, search of a style by name or part of name is added.

new style designer

Refresh Time for Reports
Starting with release 2018.2, you can define the time interval after which the report will be rebuilt. In addition to the preset values, you can enter custom values in seconds.

refresh time for reports

Access to Reports
In the release 2018.2, you can configure remote access to the report preview from the report designer. To do this, select File -> Share. Save the report in Stimulsoft Cloud, set the access settings and view the report remotely by reference, by the barcode or embed the report code in your HTML page.

access to reports

Sub-reports from Resources
Starting with the release 2018.2, you can add other reports (mrt, mrz, mdc, mdz) to the report as resources, and use these built-in reports in the Sub-Report component. To do this, in the Hyperlink tab in the editor of the sub-report, select a report from the resource gallery or specify a link to the resource manually.

sub reports from resources

Interactive Chart in Reports.JS
Starting with the release 2018.2, you can view reports with interactive data in the charts. Interactivity of data can be organized from a chart to a diagram, from a chart to other components of a report, from other report components to a chart. Interactivity of charts works in both the Web viewer component and in the preview tab in the report designer.

interactive chart in js

Text Files in Report Resources
You can add text files (txt, rtf) to the report resources, and then display them in the report using the RichText component. Add text files to the resources, then open the RichText component editor text and select a text file from the resource gallery.

Text Files in Report Resources

Dragging Data to a Dictionary
When dragging a data file into the dictionary, there are various options for adding it. If the file is dragged to the top of the dictionary, a new data source will be created based on this file. If you drag the data file to the bottom of the dictionary, the data file will be added to the report resources.

Dragging Data to a Dictionary

Move to Resources Command
When creating file data sources, you can move them to report resources. To do this, click the Move to Resource button in the New Data window. After that, the data file will be added to the report resources, and the data source will be created based on this resource. In addition, for DBF and CSV data sources, you can specify the path to the repository with multiple CSV and DBF files. In this case, when you click the Move to Resources button, all CSV and DBF files from the specified repository will be added to the report.

Move to Resources Command

Saving Resources
In the release 2018.2, the ability to save resources to a file is added. To do this, click the Save button in the Edit Resource window. The resource will be saved to a file of the same type that it was before the report was added.

Saving Resources

New Command for Resources
The new New Data Source [resource name] command has been added to the data dictionary. This command is only active for resources that contain data files. Select a resource in the data dictionary, on the New Item menu or from the context menu, call the New Data Source [resource name] command. After that, the New Data dialog will be called with a link to this resource.

New Command for Resources

Search for Items in Parameters
In the release 2018.2, the ability to find parameter values is added. If the number of parameter values is greater than 10, the search field will be displayed in the list of values. It is enough to enter a symbol, a part of a value or an entire value, and the list of parameter values will be filtered in real time.

Search for Items in Parameters

New Files in Resources
Now you can attach PDF files as Word to the report. To do this, drag the files to the Dictionary of the report. Also, these files can be displayed in the resource panel in the viewer.

New Barcode Editor
For the release 2018.2, we improved the editor of the Barcode component. The basic settings can be found in the barcode editor, and additional settings - in the property panel. Also there is a barcode preview bar in the editor.

New Barcode Editor

New Shape Menu
Beginning with the release of 2018.2 all primitives are grouped in one menu and split by the shape type. The Shapes menu is located in the Insert tab and on the Toolbox in the report designer.

New Shape Menu

New Page Button
Previously, the command to add a new page to the report template, depending on the designer, was placed in various locations. Now, in order to add a new page to the report template, click the Page button on the Insert tab.

New Page Button

New Status Bar
The WinForms designer now has the redesigned status panel for the preview and report designer. Earlier, there were two of them, now the panel is one, while full functionality is remained. Also, a visual element of the report rendering was added.

New Status Bar

Globalization in reports

Articles
Published on 28 March 2018

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
When designing reports, there can be situations when users who view rendered reports have different language cultures. In this case, they can make the required number of copies of the report, each of which is localized in a specific language. However, when editing one report template, you will have to do changes in all of its copies. Thus, every change in the report template will increase the time spent on preparing the report and significantly increases the likelihood of errors in copies of this report.

Our reporting tool provides the ability to localize the report depending on the selected report culture. The Globalization Strings tool is used for this. You can define a list of cultures with which the elements of the report will be translated. The items for which you can configure localization include:

- Report properties: Report Alias, Report Author, Report Description;
- Text component, text in cells, Rich text;
- Each cell of the Table and the Cross-tab components;
- Variables in the report;
- The text fields of the Chart component (labels, legends, rows, charts, and also you can override the values of the text properties before and the text after these chart items).

You should know that for each text component, as well as for each cell in the Table and Cross-tab, you can override several properties of this component. For example, if the report uses the text component Text1, then:

- In the Text1.Hyperlink property, you can specify a hyperlink (or expression) when you select a specific culture. For example, you can specify a hyperlink (or expression) on a localized page of your website;
- In the Text1.Tag property, you can specify a tag (or expression) for this text component when you select a specific culture. The tags in the report are used to refer to a particular report component;
- In the Text1.Text property, you can specify the text (or expression) of the text component that will be processed when the report is rendered and displayed to the user when a particular culture is selected;
- In the Text1.Tooltip property, you can specify the tooltip (or expression) of this text component when you select a specific culture.

If a property is not filled, then when you select a specific culture, the result will be empty. For example, if you do not specify anything for a particular culture in the Text1.Text property, then when you select this culture, the text component will be printed without any content.

Notice
The report culture does not depend on the localized GUI of the report designer. The culture of the report depends on the value of the Culture property. The list of values for this property depends on the list of cultures supported by the operating system. By default, the report uses the current culture of the operating system.

To call the Globalization Editor, you should go to the report properties and click in the report template area.

Globalizaion Editor

And on the properties panel, click the Browse button on the Globalization property. Below is the view of the Globalization Editor.

Globalizaion Editor

1. Click this button to add a new culture. The added cultures will be displayed in the list of cultures.
2. Select the culture in the list and click this button to remove the culture from the list.

3. The buttons to control cultures.

- Get the culture settings from the report, in this case, for the items of the selected culture, the values that are used in the report will be specified.
- Transfer culture settings to a report, in this case, the values from the selected culture will be specified for the report items.

4. If the Auto Localize Report on Run option is enabled, then, when rendering reports, the report engine will check the report culture and whether they are presented in the list. If identical cultures are found, then expressions of the report items will be replaced.

5. The list of cultures, setting which, the localization of the report items will occur (i.e. replacing expressions that are specified in a particular culture).
6. The list of report items, which localization can be configured.
7. An expression of the item that will be assigned to the selected report item when you select a specific culture.

The list of cultures, setting which, the localization of the report items will occur (i.e. replacing expressions that are specified in a particular culture).
The list of report items, which localization can be configured.
An expression of the item that will be assigned to the selected report item when you select a specific culture.

In order to automatically localize the report, you should specify the report culture after specifying the list of cultures and their settings. To do this, select the required value in the Culture property of the report. Then, when rendering the report, the report engine will check the report culture and their presence in the list of cultures. If identical cultures are found, the expressions of the report items will be replaced.

You can also set the report culture from code. To do this, you should call a special method before rendering a report and specify the culture as an argument.

Information
The culture which is indicated as an argument of the method should be in the list of cultures. Otherwise, the localization of the report will not be performed and it will be displayed with the localization of the default elements.

To localize the report in Reports.Net, Reports.Wpf, Reports.Web, Reports.Java, Reports.UWP, Reports.Silverlight.

C#
StiReport report = new StiReport();
string cultureName = "en-US";
...
report.LocalizeReport(cultureName);
report.Render(false);

//report.LocalizeReport(cultureName);
//report.Show();

To globalize reports in Reports.JS, Reports.PHP (JS).
JavaScript

var report = new Stimulsoft.Report.StiReport();
var cultureName = "en-US";
report.localizeReport(cultureName);
report.render();

To globalize reports in Reports. Flex.

Flex
var report: StiReport = new StiReport();
var cultureName: String = "en";
...
report.localizeReport(cultureName);
report.render(false);
...
//report.localizeReport(cultureName);
//report.show();

To localize reports in Reports.PHP (Flash), you need to set the globalization value for the GET or POST requests when viewing the report.

Hyperlink
http: //localhost/stimulsoft/index.php? Stimulsoft_client_key = ViewerFx & stimulsoft_report_key = Report.mrt & globalization = en-US

To localize reports in Report.Java (Flash), you should set the localization parameter when viewing the report:

Java
<stiviewerfx: button value = "Show Report" report = "Report.mrt" variableStr = "globalization = en-US" />

* the globalization parameter specifies which culture will be used in the report.
TwitterTwitterFacebookFacebookRSSRSSLinked inLinked inYoutubeYoutubeStimulsoft BlogStimulsoft BlogViberViberWhatsAppWhatsAppSkypeSkypeTelegramTelegram