Stimulsoft Ultimate 2016.2

Business Intelligence 

New Features:

The new static option StiOptions.Engine.OptimizeDetailDataFiltering, by default is true. In some cases, to ensure compatibility with older reports, this property should be disabled.
Updated WebViewerFx is located in the Stimulsoft.Reports.Web assembly. Unified names of properties and events, implemented general algorithms of processing reports with the WebViewer. Updated algorithms of caching reports. Static options are transferred to the dynamic properties of the component. Old WebViewerFx is located in the Stimulsoft.Reports.WebFx assembly – running in the compatibility mode and is obsolete.
The new DesignWindow property of WebViewer and WebViewerFx. The property sets the target window for the event by clicking the Design button.
A new form to pick a color and ability to indicate the transparency.
Support for loading the WebViewer localization from the stream.
The Date Range variables.
The DockStyle property in Designer.
Speed optimization in the report engine.
The chart styles editor in WebDesigner.
The new export command line options to setup exports in ExportsFx: settings_image_compression_method, settings_image_resolution, settings_image_quality.
The StiReport.retrieveOnlyUsedData report property which indicates how the report engine retrieves data - used only in the report data or all data.
MSSQL database support in webdesigner.
Export to PDF. Now the EmbeddedFiles feature is supported.
Export to PDF. Support for ZUGFeRD.
The CommandTimeout & ReconnectOnEachRow properties to the edit form for SQL datasources.
The Culture report property in the Designer.
The Create label & Create Field on Double Click checkboxes in the dictionary in the Designer.
The style conditions edit form to Designer.
The CustomCss property to Mobile Designer and Viewer.
The condition Break If True functionality.
Select all functions to the variable list in WebViewer.
The ability to encrypt reports in the Designer.
The MirrorMargins property to the page in the Designer.
Database adapter for Java.
The new static option StiOptions.Export.Xml.ConvertTagsToUpperCase=true.
The report checker in the Designer.
The JSONDatabase of the jsonData property.
The new static option StiOptions.Export.Pdf.OrderComponentsByPlacement= false.
Support for Java Server Faces (from v2.2) for WebViewer & WebDesigner.
The new static properties StiOptions.Export.Pdf.Security.DefaultUserPassword and StiOptions.Export.Pdf.Security.DefaultOwnerPassword.
The AlwaysUpdateReportFileName property includes enables compulsory use of the name and alias of the report to save files.
Support for the StiOptions.Designer.ShowDesignerInStylesMode property in WPF and Wpf V2 designers. If this property is set to true, the Style Editor will be opened automatically.
Support for custom styles in the SIteMap editor.
Support for the Format property in WPF dialog forms in the StiDateTimePickerControl control.
Support for StiMap and StiGauge styles in the Style Editor.
The new Web Viewer component supports detail, sorting, collapsing, new themes, reports sent by Email and etc.
The new data source button in the wizard form in the designer.
The report checker in Designer.
The Owner property is added in dialog forms in viewers. The dialog is always displayed on top.
The Select All checkbox to list variable in the Mobile Viewer.
Parameters in the editor form for the sub-report component in the Designer.
The RichText editor for the text component in the Designer.
Ability to drag and drop report template files right into the designer.
Download report from browser, if not subscribed to the Save event in the Mobile Designer.
The expression checker in the text editor form in the Designer.
The Shift Mode property to Mobile Designer.
The dual calendar with preset time intervals for DateRange type variables in the viewer.
Globalization editor in Designer.
The new StiOptions.Dictionary.ColumnsSynchronizationMode option for selecting the selection mode of synchronizing columns of data sources.
The new StiOptions.Dictionary.UseAllowDBNullProperty option to support for nullable types of data.
Saving and loading styles in the Web Designer.
The Table component in the MVC Report Designer.
The grid on the page in the MVC Report Designer.
Download report from a browser, if not subscribed to the Save event in the MVC Reports Designer.
The Shift Mode property in the MVC Report Designer.
A target to open links from the exported report (StiOptions.Export.Html.setOpenLinksTarget).
The ShowTooltipsHelp property for WebViewer allows hiding the button to go to the documentation by the current item.
The Selection property to the variable in the Designer.
Support for expressions in Watermark of the page.
The new property is added in the report - RetrieveOnlyUsedData.
Styles Form in the Designer. Move Up & Down Styles, Copy, Cut and Paste, Duplicate Style, Get Style From Component.
The RetrieveOnlyUsedData property to the report in the Designer.
The watermark enabled expression in the Designer.
Support for GlobalizationManager when editing the report and the StiOptions.Designer.UseGlobalizationManager=true to disable this functionality.
StiWebDesignerOptions LocalizationStream.
The Oracle adapter for the JS engine.
Custom user functions.
Interaction sorting.
Interaction collapsing.
Interaction drill-down.
Copy copmponents with the CTRL button in the Designer.
Virtual datasource.
JS. Export to PDF. Charts and barcodes.
The Linked and Locked properties for components in the Designer.
The Column direction and Min Rows In Column properties to data bands in the Designer.
The ReportDisplayMode (Table, Div, Span) property to Designer and Viewer.
The new event - StiOptions.Designer.Editors.EditCustomConnection - to intercept processing of editing the custom database.
Data sources from other data sources in Web Designer.
The ability to call the text editor for Watermark.Text.
Interaction edit form in Web Designer.
The Cross-Tab edit form in Web Designer.
The Styles tab to create data wizard in the Web Designer.
The report tree in the Designer.
The Duplicate item is added on the page context menu of the Web Designer.
The grid on the page in the Web Designer.
The Table component in the Web Designer.
Drag&drop components from the toolbox in the Web designer.
The Layout tab in the Web Designer.
The text format editor in the Web Designer.
The Text format editor in the MVC Web Designer.
Calcualted column in Web Designer.
The new static option StiOptions.Engine.PrintIfDetailEmptyNesting to enable more accurate checking of the PrintIfDetailEmpty property.


The OpenLinksTarget and OpenExportedReportTarget properties are renamed in OpenLinksWindow and OpenExportedReportWindow. Also the necessary Enum values for the properties are added.
Export to images. Now the output files will have more correct numbering.
Engine V2, The UseParentStyles property now works when rendering the report.
View data in the designer in a new tab.
The KeepDetailsTogether property was changed on more functional KeepDetails in the Flash Designer.
Change interface in the more colors form in Designer.
Improved display of bar-codes in the edit menu of the barcode.
The time control to datepicker in the designer.
Ability to use report variables in the SQL query string in the designer.
Optimized speed of loading a report in Designer.
Engine. Speed optimization when processing data for master-detail reports.
The PopupWindow value in the StiPrint Destination is replaced by the With Preview for Web Viewer.
Optimizing data import a large volume of data in the Designer.

Fixed Bugs:

Export to HTML. In some cases there was the exception when having primitives on the bottom page margin.
The user variable of the list type in the SQL query.
Error of rebuilding titles in the Cross-tab component when deleting a row.
EngineV2. When using business objects and placing detail bands in the sub-report duplication of fetail bands occured.
Error displaying Cross-tab, if the the ShowTotal and the Enabled properties of the total were not enabled.
Excel data source. Now files from the SpreadsheetGear are opened correctly.
Collaboration Wrap and HorAlignment properties in the Cross-tab component.
The error when viewing the exported report in a new window in WebViewer.
Localization could not find items from English locale.
A bug with dependent variables in the Designer.
WebViewer image export.
System icons icons for 4K monitors are redrawn. Now, icons are not blurred.
Changed algorithm of opening the Cross-tab editor. If data is specified in the Cross-tab, it immediately opens a second tab to work directly with the component, and not the first tab to specify data.
Default export setings in WebVeiwer.
Modify the cross-tab condition column style in WebDesigner.
The fullscreen mode of WebViewer.
Displaying the Null DB field value.
The error with scrolling the browser in the fullscreen mode from WebViewer.
The transparent background color of charts is now correctly exported to Word/Excel.
Support for RefCusror in the Oracle database.
WebDesigner parameters editor.
Changed the behaviour in the form of editing of the Expression property of the Watermark. Now, if to move anything from the dictionary - the braces automatically added in the expression, so it is an expression.
Support for the String.Format function.
Conditions in the Cross-Tab component.
The ProcessAtEnd chart property now works correctly.
Some problems with working the RetrieveOnlyUsedData report property.
Export to HTML, exception on check export settings when export from the code.
Export to HTML. Some problems with the export of images that overlap with the textbox.
Report Engine, When CacheAllData the report property was disabled, then, in some cases, there was the exception when crearing Constraints.
The error with displaying the cross-tab without rows.
SummaryTitle for the CrossTab.
Incorrect calculation of the height of cross rows in some cases.
Problems with dependent variables in Viewer and Designer.
WebDesigner sub-report.
ViewData in WebDesigner.
A bug in the method of color comparison. As a result, export to Excel was accelerated several times.
The error occured when opening the expression editor of the calculated column of the business object.
In the interpreted mode, the aggregate functions by the group for the textbox located at GroupFooter were not working if the GroupFooter was put after the Table component.
EngineV2 GetGroupHeaders for StiTable.
Query timeout option StiOptions.Dictionary.setQueryTimeout().
Chart Y-axis range display.
Improved work with ColorPicker.
Disabled the ability to animate the chart when the Axis Auto Range property is set to false.
A problem with the automatic changing the size of cross-tab cells with the enabled MaxSize property.
The thickness of the border when defining the size of the cross-tab cells was not considered.
Calculation of the cross-tab cells size with border thickness.
Cells auto size in the cross-tab component with the enabled MaxSize property.
WebDesigner bands filters editor.
A more precise definition of the server port number solves the problem using the port number in the URL.
The localization of the variable PageNoFM.
The dependence of the PageNofM localization on the selected values of the Culture property of the report.
Drawing when exporting charts to HTML with set min and max for YAxis.
Animated charts in several iframes.
When the text property AllowHtmlTags is enabled, the symbol "Non Breaking Space" is now handled correctly.
Some problems with the report cache when having Request From User variables.
Export to PDF. Improves processing of errors with the digital signature of the file.
A bug with incorrect input of HTML tags on monitors with high dpi.
EngineV2. A bug with the calculation of aggregate functions in the interpreted mode with a certain combination of components Table and GroupHeader/Footer.
A bug when creating a component style in the empty report.
Drawing charts with set min and max for YAxis.
A bug with empty cross-tab fields in the Designer.
Engine V2. When docking is enabled for the component, the CanGrow property is now applied again after docking.
A bug with not visible properties for FullStackedColumnArea in the chart editor form.
Data sorting.
Editing sorting column in the web designer.
Variables DataSource editor in webdesigner.
The StopBeforePrint behaviour.
Obsolete variable $HTTP_RAW_POST_DATA no longer used in PHP adapters.
Engine V2. The SubReport sizeis now correctly calculated if it is located directly on the page.
The PageNofM variable.
The List variables.
Sub-report with an empty page.
The error of the parameters.reportFileName zero variable in Web Viewer.
A bug with zoom by page width and page height in the viewer.
Problem with multilevel collapsing in WebViewer.
Undo/Redo webdesigner functionality.
In the Chart Edit for Scatter, the Marker Line option was removed.
Some problems with working the RetrieveOnlyUsedData report property.
In the Chart Edit for Scatter Spline Line, the Marker Line option was added.
Now the CanBreak property of the StiText component works correctly.
The text with the first blank line was shown incorrectly.
Export to PDF. When having Tabs in the text, the exported file was corrupted.
Export to PDF. When having more than 255 various characters in the text the exported file was corrupted.
The error when editing the relation, if the alias of the datasource is not equal to the name.
ReportUnit of external subreport is now converted to ReportUnit of the master report.
WebDesigner retrieve columns with parameters.
The StiTable component grouping.
The BreakIfTrue property of the Highlight Condition now works correctly in the interpretation mode.
Export to Word. Charts with transparent background are now exported correctly.
Watermark transparency.
Confirmation to leave while in the preview tab in webdesigner.
The Make Horizontal/Vertical Spacing Equal function.
View Data of a Data Source via context menu in WebDesigner.
Watermark displaing in WebDesigner.
A bug with the watermark image in the MVC Designer.
A bug with the onPreview event in the JS Designer.
On some computers the scale of the system font was incorrectly set. This led to incorrect rendering of some components.
In some cases, the bookmarks did not work at static components of sub-reports.
Engine V2. In some cases, in master-detail reports, when having empty details, aggregate functions were shifted.
The WebViewer interaction on second+ page.
Export to SVG. Fractional font sizes were not correctly processed.
Collapsing interaction editor in WebDesigner.
Engine. Fixed error of serialization images when using report cache.
The bug when set the collapsed property for bands in the Designer.
Support for Wildfly & WebLogic servers.
The data group properties were not displayed in the CrossTab editor form.
Export to HTML. Now the Strikeout property of the font is correctly processed.
Chart styles №26, 27, 28 were not loaded in DesignerFx.
The error with applying properties in the CrossTab edit form.
Strikeout in the HTML export & WebDesigner.
The {Today} system variabe.
The "onlyText" behaviour.
Loading color which name contains more than one word.
Interaction editor in WebDesigner.
The Make Vertical Spacing Equal function.
Database adapter for ASP.NET.
Soritng for the data band was not applied, if the report was created from wizard.
Some parameters of loading JSON.
WebDesigner Undo/Redo.
Loading files by URL.
Viewer buttons localization.
IconCondition was incorrectly working when usong the Flex engine.
Conditions with null Oracle data column value.
Bookmarks with apostrophe in WebViewer.
Improved compatibility of WebViewer and MvcViewer styles with other frameworks.
Incorrect work of the Reset function for the Request form User variables when using lists from the database in Flash.
Paint background for Gauge.
Hide RichText in WebDesigner.
In some cases, an incorrect rounding of the Y-axis values in Flash charts was applied.
Grouping separator in the Number Formatter.
Parameters in the SQL query.
The error message with non existing parameter.
JSON parsing.
Export to pdf, exception если задан некорректный hyperlink (длина менее 4 символов). Export to PDF. The exception was thrown if an incorrect hyperlink (the length of at least 4 characters) was set.
WebVeiwer cache errors.
Engine V2. Now the UseParentStyles property works more correct and is applied before Conditions.
Export to Excel. By default all sheet tabs were selected.
The ToWordsEs function. The numeral un/uno/una is now correclty selected.
Engine V2. The OnlyText property of the Text component is now works in interpreted mode.
Export to HTML. In some cases, text was smoothed when exported as an image.
Issues with printing on some printer models.
The number formatter.
PDF fonts.
Export to PDF. DigitalSignature. The UseLocalMachineCertificates property is now applicable for CertificateData as well.
Report deserialization.
Отрисовка EAN13-based штрихкодов при изменённом масштабе системного шрифта. Drawing the EAN13-based barcode with changed system font scale.
The TextOptions deserialization problem.
Export to HTML. The border style "double" now works correct.
The border styles in the HTML export.
Improved output of nested business objects without adding the previous bands.
The chart from JSON data failed when null data values in JSON.
Stacked Column render.
The Shape component with the style set to None is now displayed correctly and exported to the PDF format.
Set '0' values for Page Margin.
The Shape component with the style set to None is now correctly exported to the PDF format.
Some corrections to the Scatter Line chart associated with arguments of the date type.
Reduced the rendering and drawing charts time with large amount of data.
When reopening the StiMap editor, data on the style tab were not visible.
Support for variables and parameters in a query when retreiving columns in Flash Designer.
Incorrect file name when exporting a report with an empty name in WebViewerFx.
EngineV2, Duplication of detailed BusinessObjects when having the big data structure.
Custom styles were not applied to the StiMap component.
Export to Excel. When using the UseOnePageHeaderAndFooter property and complex headers, in some cases, cells shifted.
Export to pdf. When using the "unsignedsignaturefield" tag, in some cases, the error of export occured.
When uploading invalid user data in the JSON format in the StiMap editor, an unhandled exception was thrown.
A rare bug with displaying the chart using the report template created not in the .NET/WPF version of the product.
WebDesigner connections icons & names.
Now DateSerial, MonthName, DayOfWeek functions are working properly.
WebDesigner duplicate page function.
In the Text Quality=Wysiwyg mode, the textbox was not output entirely for some fonts, if at least one of the used characters was output in this font.
The error with wrong data sorting.
Export to XPS. Wrong size of pictures when you changing DPI in the export settings.
The ShowMainMenuNew, ShowMainMenuReportOpen, ShowMainMenuReportOpenFromGoogleDocs, ShowMainMenuReportSave, ShowMainMenuReportSaveAs, ShowMainMenuReportSaveAsToGoogleDocs, ShowMainMenuReportPreview, ShowMainMenuCheckForIssues, ShowMainMenuReportSetup, ShowMainMenuClose, ShowMainMenuOptions, ShowMainMenuExit у StiRibbonDesignerControl properties for the Office2013 theme.
The property XAxis -> DateTimeStep->Month for Column Chart.
Date functions.
Variables which names start with underscore.
The error with Copy/Paste of components from one report to another in the Flash Designer.
The bug with data source aliases in the wizard form.
Export to PDF. Incorrect processing of some checkboxes.
Working of the TopN chart property together with sorting.
A bud with hyperlinks when the viewer shows a report in the one page mode.
The StiSystemVariablesHelper.GetSystemVariables() method now returns not string[] but List. Now the user can dynamically change the list of variables.
Setting the Keys value - Values at Init By: - Expression in the form of New Variable.
Export to OpenOffice Writer. Alignment of rotated text.
Now in the report designer you cannot specify the empty name of the component.
Export to Excel. When using the UseOnePageHeaderFooter property complex headers are now processed correctly.
In some cases there is a compilation report error in the presence of a single expression of several nested functions with multiple parameters.
Flex configuration loading.
Incorrect display of diacritical marks and some composite characters when using certain fonts.
The bug with showing a default value of the variable, if variable.selection = first.
Incorrect rendering of AdvancedBorder whan certain thicknesses borders is set.
In the designer, the Show Rules and Show Order buttones were always locked.
The JoinColumnContent(BusinessObject) function now correctly works on the detail-band.
JSON encoding.
Export to HTML. Now fonts whose name contains a space are exported correctly.
The compilation error when adding Sub-Report parameters simultaneously through the event and menu.
Issue with the font size when exporting to HTML.
The exception on Page->Duplicate in the designer context menu.
The CreateReport event was not called.
The Month function.
Increased the speed of exporting reports.
Fixed problems in StiMap with rendering the HeatmapWithGroup type.
The nameInSource property was not working.
Issues with loading JPEG.
The Restrictions (Allow Move) property for TextComponent.
Issues with loading the XSD schema.
The error when setting the loading timeout of XML and JSON data in Flash Designer.
Charts zooming.
Loading some JSON files.
Charts display backgound.
Some issues with the OData loader.
QRCode encoding.
Issue with rendering charts with empty data.
Completely redesigned algorithms associated with animating pages and visual elements. Fixed bug with incorrect moving pages when switching modes PageOne, TwoPages, MultiPages.
Printing rotated text.
Style colors serialization/deserialization.
The ShrinkFontToFit function.
The new report with maps is added in the Demo application.
Work dependent variables. Filtering with initial values.
PDF print in Chrome browser for WebViewer.
The problem with the large timeout when using built-in XML and JSON data adapters in Flash designer.
Improved the editor to select data columns for the RichText component in the Flash designer.
The error with printing reports in HTML and PDF mode in the updated WebViewerFx.
Export to Excel. The Export Page Breaks option now works correctly.
The Minimum and Minimum properties for all axes of the charts.
The problem with positioning the Collapse button on the report page in WebViewer.
Export to CSV. Exception in the ExportDocument method in some cases.
Memory leaks in ReportCacheMode.
In some cases, embedded functions in expressions caused exception when compiling the report.
Reports might not loaded correctly in WebViewerFx.
Speed optimization of rendering the Hierarchical band that uses BusinessObject.
Export to PDF. When using the editable fields the exception occired in some cases.
The Drag & Drop of the MDC file in the JSON format did not work in the viewer.
Improved rendering of charts using a custom range for the axes.
The error of printing from the code, if the script is added to the page title.
Export response as inline in the browser window.
The dialog box to open images for variables worked incorrectly in the Flash designer.
A bug with the sub-report page container in the Designer.
Problems when Mobile Designer is used with Semantic UI.
Bugs with CTRL+C and CTRL+V in the Designer.
Align images in the middle and on the right edge of Flash Designer.
A bug with cross-tab fields in the designer when the interface mode is touch.
Document serialization/deserialization.
A bug with sorting interaction in the Designer.
It is forbidden to move the components outside the page in the Designer.
Print in PDF in WebViewer and MvcViewer now done using the POST request intstead of the GET request. This solves the problem with big number of parameters.
A bug with calculated column expression in the Designer.
The work of the Prevent Intersection property when rotating Chart Labels.
The Help button is added for the richtext and text editors.
EngineV2. If the container laid directly on the page then the CanGrow did not work for the second and subsequent pages.
Incorrect work of ImageCache for images embedded in the report.
Improved the definition of high system dpi on Windows10 for "only font size" mode.
Export to Excel. Hyperlink on Image now works correctly.
Export to PDF. Editable checkboxes now work correctly if the initial values is not set.
EngineV2. Exception when rendering big StiCrossTab in SubReport.
Export to PDF. Barcodes are now exported correctly.
Improved drawing of the series of the Area type.
Command timeout for data source.
The problem with report styles when re-drawing the viewer or designer.
Issues in the parser of expressions.
Updated localizations.
Editing Conditions in the Cross-Tab component.
Loading images by URL when exporting.
Issues with loading templates of the XML types.
Improved drawing series of the Area type when exporting to HTML.
JS Export to PDF. Embedded fonts.
Fix, JS, export to PDF. Font size .
Aliases to columns in creating report wizard.
A bug with apply styles collection in Designer.
The Size button for components in the Layout tab in the Designer.
A problem with gaps when rendering the Cross-Tab component.
The issues in the Cross-tab.
The new event - StiOptions.Designer.Editors.EditDataStoreAdapter.
Portuguese UI localization.
A problem with displaying software cursors on 4K monitors (they were displayed smaller then they were).
Showing the last values in charts.
The problem with moving components on 4K monitors (they were moved several times further away from the cursor).
When calling the preview from the File menu, the viewer was displayed empty.
A problem with a memory leak in the viewer when using Thumbnails.
Change of scale in the designer by pressing the Ctrl key + the scroll wheel.
Vertical scrolling is added to the context menu. There were cases that had a lot of elements and it was impossible to select any of them.
When you open the report through the File -> Open in the designer wring report name was output and the path for the subsequent saving was not remembered.
The Cross-Tab unnecessary break.
The error of retrieving non-described columns.
The text zoom if using alignment by the width and anf the Cross-tab component should be squeezed.
A bug with multispaces in the Richtext editor in the Designer.
The error of alighment in the cross-tab component.
Problems with the alignment when putting the Cross-tab on the band.
The wrong property when reading style.
When calling the View Data command for the Data based on other Data Source, the filtering was not considered.
Export to HTML. The vertical alignment of the text in the Div/Span mode now works correctly.
The NewDataSource form when disabling MongoDb StiOptions.Dictionary.Connections.ShowMongoDb = false; The SQL category of connections was not displayed.