List & Label Reporting Blog

Introducing Adjacent Pivot/Crosstabs for Multi-Dimensional Data Analysis

Introducing Adjacent Pivot/Crosstabs for Multi-Dimensional Data Analysis

ByJochen BartlauMar 5, 20242 min read
Pivot/crosstabs are a very popular object within the List & Label Designer, that’s why we’re continuously adding enhancements to this important features. So far though, despite all added extensions, pivot/crosstabs have ultimately been a simple grouping in two dimensions. From version 29 on, they’ll become more dimensional.
Supporting Multiple Report Containers

Supporting Multiple Report Containers

ByJochen BartlauMay 23, 20142 min read
Since we introduced the report container in List & Label 11, the one remaining feature request that kept coming in was “could we have multiple report containers, please”. Many cases can be covered by using a multi-columnar layout for the report container as a workaround or combining distances between container elements and changes in alignment to get the visual impression of separated tables. But these workarounds are not very discoverable and they are just that – workarounds.
In version 20 we’ll introduce a brand new databinding mode for the .NET component which will replace the old one seamlessly. You won’t need to apply any code changes to profit from this new mode. However, under the hood things will be working quite different then.
changing the order in which objects are printed

Combining the Report Structure and Object Tool Windows

ByJochen BartlauMay 5, 20141 min read
The two tool windows you'll probably use the most in the report designer of our List & Label reporting tool are the "Objects" window and the "Report Structure" window. The "Objects" window enables you to quickly select an object in order to change its properties and contents. The "Report Structure" window is used to configure the specific contents of a report container object, i.e. tables and subtables, charts, crosstabs and Gantt charts.
edit filter

Filtering at Database Level

ByJochen BartlauApr 11, 20142 min read
Using report parameters has become very popular since we've introduced them in version 19. A typical use case that will become even more seminal with version 20 of our reporting tool is using parameters to filter data (see last feature focus). This is something we've usually put on the "don't" list as databases can filter data much faster than we can. In the past, all records had to be passed to the reporting engine which then decided if a record should be used or not. A vast overhead for a task databases are usually optimized for. In version 20, we'll be introducing a new feature that allows List & Label filter expressions to be translated to native database filters, therefore hugely increasing performance (in principle, depending on the data this is "infinitely" faster).
table to add drilldown reporting parameters

Drilldown via Report Parameters

ByJochen BartlauMar 11, 20142 min read
Building on the sound foundation of report parameters introduced in version 19 of our List & Label reporting tool, we've extended the way drilldown reports can be used in the report designer.
In addition to the drilldown via relations which we already had in the product for a couple of versions, you can now trigger a sub report that uses report parameters and set the parameter values depending on the item that you just clicked in the preview. This terrific feature works for pie/donut and bar charts, shapefile charts, table fields and crosstab contents. Of course, a drilldown report can contain another drilldown, too.
As with all the feature focus articles, keep in mind that this feature is not yet available in the current version, it will be part of List & Label 20.
dummy-img

What’s this blog for?

ByJochen BartlauMar 10, 20141 min read
In the past, we haven’t been communicating our development progress until the next major version of our development component was almost finished and polished. This is now going to change! Our motivation for this blog is, to show you early what to expect from the next version of our List & Label reporting tool.