Sneak Peek X16: Filter and Sort MergeBlock Rows
In version X16, it will be possible to sort and filter merge block data when merged using the reporting engine MailMerge.

A MergeBlock is a reporting structure to repeat content based on data rows associated with this repeating block. Typically, a merge block contains a list of elements such as order items in an invoice. A block can be a table row, a paragraphs or multiple lines.
In version X16, we are going to introduce data shaping to filter and sort data rows in a MergeBlock. The out-of-the-box available UI (ribbon and dialog boxes) will reflect these new improvements. The Insert Merge Block dialog box, that inserts a new merge block based on the connected data from the TXText
A typical merge block listing orders looks like shown in the following screenshot:
After merging, the table gets expanded with all block data rows:
Sorting
In the new Filter and Sort dialog box, this list gets sorted ascending by price. It is also possible to set multiple sorting conditions:
The following screenshot shows the same list, but sorted by price ascending:
Filter
Next, all entries where UnitPrice is over $800.00 are filtered out. In the dialog, the positive entries are selected: All rows with UnitPrice are less than 800:
All of these settings can be set programmatically using new properties of the MergeBlockInfo class: SortingInstructions and Filters. Additionally, the BlockMergingCondition specifies a condition the parent data row of this merge block has to satisfy, so that this merge block is merged at all.
This enables very flexible data structures and data shaping options in TX Text Control based reporting applications. Stay tuned for more exciting new features coming in version X16.
Let us know what you think about this - we would love to get your feedback on these features.
Also See
This post references the following in the documentation:
- TXText
Control. Document Server. Data Sources. Data Source Manager Class - TXText
Control. Document Server. Data Sources. Merge Block Info Class - TXText
Control. Document Server. Data Sources. Merge Block Info. Filters Property - TXText
Control. Document Server. Data Sources. Merge Block Info. Sorting Instructions Property
Jump to the other posts in this series:
- Sneak Peek X16: Excel Formulas and MailMerge
- Sneak Peek X16: MS Word Compatible Track Changes
- Sneak Peek X16: Filter and Sort MergeBlock Rows
- Sneak Peek X16: New Customizable Sidebar Controls
- Sneak Peek X16: Working with Formulas in Table Cells
- Sneak Peek X16: Selecting Reference Cells for Table Formulas
ASP.NET
Integrate document processing into your applications to create documents such as PDFs and MS Word documents, including client-side document editing, viewing, and electronic signatures.
- Angular
- Blazor
- React
- JavaScript
- ASP.NET MVC, ASP.NET Core, and WebForms
Related Posts
TX Text Control 32.0 Has Been Released
We are pleased to announce the immediate availability of TX Text Control 32.0 for all platforms including ASP.NET, Windows Forms, WPF and ActiveX.
TX Text Control 31.0 and TX Spell .NET 10.0 Have Been Released
We are happy to announce the immediate availability of TX Text Control 31.0 for all platforms including ASP.NET, Windows Forms, WPF and ActiveX and TX Spell .NET 10.0 for all .NET based platforms.
TX Text Control 30.0 and TX Spell .NET 9.0 Have Been Released
We are happy to announce the immediate availability of TX Text Control 30.0 for all platforms including ASP.NET, Windows Forms, WPF and ActiveX and TX Spell .NET 9.0 for all .NET based platforms.
TX Text Control X19 and TX Spell 8.0 Have Been Released
We are happy to announce the immediate availability of TX Text Control X19 for all platforms including Windows Forms, WPF and ASP.NET and TX Spell .NET 8 for all .NET based platforms.
TX Text Control X18 has been Released
We are happy to announce the immediate availability of TX Text Control X18.