Creating Crosstabs via Drag & Drop

dialogue choose table element type

A crosstab does a great job in aggregating your data and helps to spot trends and outliers. We've put great effort in enhancing our crosstab support for the last few versions. However, although there's a nice wizard to get you started, usability testing showed that even creating simple crosstabs was still a challenging task for some users. That's something we hope to change with LL24.

Reset Page Count for Group Header

While List & Label has a superior concept for printing mail merges, many other (usually band-type) reporting tools people got used to apply a different concept to print invoices and other mail merge typed projects. Usually in List & Label, you'd define the header data as variables and use text objects, images etc. to design your letter head.

Crosstabs: Expand Sub Tables in the Interactive Preview

As we swiftly proceed through the development process of List & Label 22, we found a slot to add one more feature to the crosstab. Starting in version 19, we've added a lot of interactivity to the preview, including a feature called "Expandable Regions" for the report container. It allows to expand sub tables by just a click. For LL22, we've now extended this feature to the crosstab.

Top-N and “Others” for Crosstabs

And while we're at it, let's disclose the last new feature for LL22's crosstab. You were able to design Top-N reports with the crosstab before. The way it works, you choose the required sorting for your group cells, e.g. the category name in the sample of the last post. You're then able to choose the sort order for the items (alphabetically, based on the result value, based on the displayed value).

Automatic Fill-Up for Crosstabs

automatic fill-up for crosstabs
To continue the quest for the perfect crosstab, welcome to part three of this blog post series. After visiting multiple result cells and cross-column references, today let's look at another cool new feature in the LL22 crosstab – Auto-Fill. This comes in handy whenever there is few data. Think of a yearly statistic where you don't have results for each quarter. Printing something like Q1…Q2…Q4 looks awkward and unprofessional. In LL22 we have the solution to this.

Cross-Row and Column References for Crosstabs

cross-row and column References for crosstabs

From the latest blog post you could already tell that the crosstab is one of our focus areas for version 22. Besides multiple result cells we decided to pay a visit to the crosstab functions as well. In version 21 these functions can already be used to reference the values of sum cells, column and row labels etc. By extending the functions slightly, striking new features become available.

Enabling Multiple Result Cells for Crosstabs

enabling multiple result cells for crosstabs
As this was one of the most frequent requested features in our feedback portal and we hadn't visited the crosstab's features for a couple of versions, this feature was an easy pick. A crosstab is aggregating values and groups them by two or even more dimensions. Until version 22, there was exactly one aggregation possible, e.g. you could have either the number of orders or the revenue sum per customer and year, not both. In LL22, there is no limit anymore.

Introducing C++ Support for Multiple Report Containers

During our Roadshow this fall, the question I was asked the most was "why do you support certain features only for .NET". Most notably, multiple report containers (since LL20) and nested tables (since LL21) were only available for .NET databinding. The reason for this is the necessity to support a special and – until now – undocumented COM interface for passing the data to List & Label. We decided to leave this interface undocumented in version 20 in order to be free to apply changes without breaking customer code. We had to make sure the interface was ripe. Now we are and here we go.