Products Technologies Demo Docs Blog Support Company

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.

Sneak Peek X16: Filter and Sort MergeBlock Rows

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 TXTextControl.DocumentServer.DataSources.DataSourceManager class, has a new button to specify data shaping settings:

Data Shaping in TX Text Control X16

A typical merge block listing orders looks like shown in the following screenshot:

Merge Block

After merging, the table gets expanded with all block data rows:

Merge Block

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:

Data Shaping in TX Text Control X16

The following screenshot shows the same list, but sorted by price ascending:

Merge Block

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:

Data Shaping in TX Text Control X16

Merge Block

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.

Stay in the loop!

Subscribe to the newsletter to receive the latest updates.

Also See

This post references the following in the documentation:

  • TXTextControl.DocumentServer.DataSources.DataSourceManager Class
  • TXTextControl.DocumentServer.DataSources.MergeBlockInfo Class
  • TXTextControl.DocumentServer.DataSources.MergeBlockInfo.Filters Property
  • TXTextControl.DocumentServer.DataSources.MergeBlockInfo.SortingInstructions Property

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.

ASP.NET Core
Angular
Blazor
JavaScript
React
  • Angular
  • Blazor
  • React
  • JavaScript
  • ASP.NET MVC, ASP.NET Core, and WebForms

Learn more Trial token Download trial

Related Posts

ActiveXASP.NETReporting

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.


ActiveXASP.NETReporting

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.


ActiveXASP.NETReporting

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.


ActiveXASP.NETReporting

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.


ActiveXASP.NETReporting

TX Text Control X18 has been Released

We are happy to announce the immediate availability of TX Text Control X18.