DevExpress Reporting 19.2

Adds new cross tab control.
October 25, 2019
New Version

Features

WinForms Reporting

  • New Cross Tab Control - The new Cross Tab report control is now available for those using the Visual Studio report designer and the WinForms End-User Report Designer. While it's expected to provide a similar user experience for the Web and WPF report designers in the future, all reports that rely on this new control render perfectly in browser-based and WPF applications.
  • The Cross Tab control resolves limitations associated with the XRPivotGrid report control and makes cross tab reporting as easy as possible. Its features include:
  • Design-Time Support
    • A new Cross Tab report type has been added to the Report Wizard.
    • You can define the cross tab layout by dragging fields from the Field List.
    • The RowVisible and ColumnVisible properties allow you to display/hide rows and columns. Invisible region is populated with a hatch brush in the report designer.
  • Data Binding and Formatting Options
    • Data Cell properties allow you to specify the summary type and the way in which a calculated value correlates to summary values in other cells.
    • Tab Header Cell properties allow you to combine column and row fields into groups and apply the appropriate sort order.
    • You can now pass report parameters to the control's filter string without event handling.
    • You can now conditionally format cells using Expression Bindings.
    • The Cross Tab control supports Report Styles. You can define the appearance of each cell region.
  • Layout Options
    • Right-to-Left display mode.
    • You can display row or column field headers in the upper left corner of the control or leave it empty.
    • Multiple data field values and their associated headers can be displayed in a row or a column.
    • Row or column totals can be displayed before or after data.
    • The Cross Tab control can be printed in an 'across then down' mode. Pivot data is moved to the next row once it reaches the right page border.
    • Row groups can be printed in a tree-like manner.
    • Repeat column and row headers across page breaks.
    • Cross Tab cells include an Angle property. This allows you to print column and row headers vertically.
    • Column best fit.
  • You can easily convert the XRPivotGrid to Cross Tab via a smart tag, which includes a new 'Convert to Cross Tab' option.
  • Parameters Panel - Reset Button Behavior - The default behavior of the reset button has changed. It now reverts parameter values to their defaults.
  • Report Designer - Enhanced Filter Editor - Integrated enhanced Filter Editor into Report Designer component. You can now search through data source fields while constructing a filter criterion and use custom expression functions.
  • Data Federation - Union Query Support - The Federation Data Source now supports Union and UnionAll operations.
  • End-User Report Designer - Properties Panel Non-Tabbed View - Use the PropertyGridDockPanel.UseTabbedView property to switch the Office-inspired Properties Panel to the non-tabbed view.
  • JSON Data Source - Path Parameters Support

ASP.NET Core and Web Reporting

  • Web Report Designer - Usability Enhancements
  • Updated Project Templates - The Web Report project templates include the following new options:
    • Add Sample JSON Data Connection Storage - Registers a sample data connection storage to create JSON Data Sources in the Report and Data Source Wizards.
    • Add Sample Data Object - Registers a sample data object to create Object Data Sources in the Report and Data Source Wizards.
    • Enable Rich Text Editor - Provides an in-line RTF editor for the Report Designer’s RichText control.
  • Also enhanced the report storage implementation across all templates. In previous versions, this implementation relied on REPX files stored in a file storage. With this release, the report storage can also open reports by individual instances and allows you to handle report events as needed.
  • Updated Properties Panel - A square button near each property now indicates whether a property value differs from its default value. This button also allows you to define expression bindings. Once you specify the expression, the button changes its icon to formula (f) and displays the expression in its tooltip.
  • Custom Zoom Factor - You can now input any value in the zoom toolbar editor instead of decreasing or increasing the zoom level by a predefined 5% scale.
  • Search in Lists - Added incremental search functionality to the following UI elements:
    • Field List
    • Report Explorer
    • Expression Editor (through 'Report Items' and 'Fields')
    • Report and Data Source Wizards (through SQL queries and object types)
  • Web Document Viewer – Progress Bar Position - In previous versions, the document generation progress bar was always displayed at the bottom of the Document Viewer and could leave the visible web page area when users scrolled the page. In v19.2, the progress bar retains its position within the visible region (you can now always see the document generation progress). Also introduced a new API to customize the progress bar's position and behavior.
  • Rename Custom Queries - You can now define a custom query's name in the Report and Data Source Wizards without invoking the Query Builder dialog.
  • Sync Report Names and Tab Names - A tab's caption (within the Report Designer) is now updated when you save a report with a different name.
  • Bind a Report to ObjectDataSource Using the Data Source Wizard - You can now select Object type in the Data Source Wizard and bind a report to a collection of business objects. In the Data Source Wizard, you can specify the parameter expression (using the Expression Editor) and pass an existing report parameter to the constructor or the method that returns a collection of business objects.
  • In-Place Rich Text Editing - The XRRichText control allows end-users to edit its contents. Double click the control to activate the editor. The editor's popup provides various text formatting options:
    • Text Alignment
    • Font Style
    • Font
    • Font Size
    • Text Foreground and Background
    • Hyperlinks
  • Script Support - You can now implement and use report scripts in applications that target .NET Core 2.x / 3. Install the Microsoft.CodeAnalysis NuGet package and enable script execution as described in Script Execution Mode.
  • End-User Report Designer - New Add Parameter Dialog

WPF Reporting

  • WPF Report Designer - Collapsible Bands - You can now expand and collapse bands in the DevExpress WPF Report Designer.
  • WPF Report Designer - Enhanced Filter Editor - Integrated enhanced Filter Editor into the WPF Report Designer component. You can now search through data source fields while constructing a filter criterion and use custom expression functions.
  • Data Federation - Union Query Support - The Federation Data Source now supports Union and UnionAll operations.
  • Parameters Panel - Reset Button Behavior - The default behavior of our reset button has changed. It now reverts parameter values to their defaults.
  • JSON Data Source - Path Parameters Support
  • End-User Report Designer - New Add Parameter Dialog

All Platforms

  • Report Layout - Display Cross-Band Content - In previous builds, DevExpress Reporting printed all bands sequentially (one after another). With this release, you can display bands across two layers. Enable the Page Header or Group Header band's PrintAcrossBands property to display a given band's content in the background layer. As you would expect, all remaining bands will overlay this background layer once your report is generated. This new feature allows you to incorporate extended group/page watermark information or to display group/page-specific information in conjunction with detail records and footer content.
  • Report Layout - Populate Free Space with Blank Rows - When printing on pre-printed forms, a set number of data rows must be printed. If actual report data is less than that needed by the pre-printed form, blank rows must be inserted as necessary. This release adds a new DetailBand.FillEmptySpace option. Enable this option to populate your report with blank rows.
  • Parameters - Date Range Parameter - You can now create a DateTime range parameter. The built-in parameter panel displays a Date-Range parameter editor. This editor has a customizable list of predefined ranges and displays two DateTime editors for custom start and end dates. The DateTime range parameter consists of two regular parameters which can be used to filter report data at the data source and report level.
  • Parameters - Define Parameter Values via Expression Binding - You can now define the default parameter value using an expression binding (the DateTime.Now constant).
  • Report Designer - Re-order Detail Reports in Report Explorer - With integrated Detail Report drag & drop support, your end-users can rearrange detail report hierarchies. You can drag & drop detail report bands within the Report Explorer pane, preserving report band structure.
  • Report Designer - SVG Watermark - With this release, you can use a SVG image as a report's watermark.
  • Crystal Reports Converter Enhancements - The Reporting.Import tool can now convert formulas, subreports and report bands that have the 'Underlay Following Section' property enabled.
  • Charting - Filtering Enhancements - You can now use SeriesBase.FilterString and XRChart.Parameters to filter individual chart series.
New Cross Tab Control

DevExpress Reporting

Reporting for WinForms, WPF, ASP.NET, MVC, ASP.NET Core and WinUI.

Got a Question?

Live Chat with our DevExpress licensing specialists now.