News combit Dev Blog

Crosstabs: One More Thing

Posted: Wednesday, August 24, 2016 | 0 comment(s)
 
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.

Take the following crosstab for an example:

Crosstab bevor expanding


For brevity reasons, I've restricted it to fit on one page. However if I had activated the automatic fill-up feature it surely wouldn't fit. Wouldn't it be nice to hide the details for the year first and then only expand the year you're interested in? That would allow to add way more levels of detail to the crosstab without making compromises to the readability. And that's exactly, what the new feature is about. In the crosstab's properties, set the "Expandable Region" property for the "Year" field to "True":


Choose with area in the crosstab you would like to expand

In the preview, the "Year" columns will then be rendered collapsed and a small expansion handle will appear in the cells:


Collapsed crosstab in List & Label reporting tool

Simply click on the handle to expand the required year (and only that year):


Expanded crosstab in report designer

This is a completely new and intuitive way to drill-down on your aggregated data. It allows to browse complex data at a glance in a powerful way. And it's really fun to use, btw :).

 





Author: Jochen Bartlau
Head of Development List & Label

Jochen Bartlau leads the development at combit as Managing Director. He's a Microsoft .NET enthusiast driving innovation & agile project management. The mobile devices geek who used to be a physicist in his first life loves to spend his spare time with his family.


  

+1 800 256 3608 (toll-free North America only)