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.

The Challenging Road to Release

We're quickly approaching the final release of List & Label 21. As you surely know from your own practice, release times are hard times ;-). You are moving constantly between madness and excitement. To visualize the long and challenging road we're about to finish, we created the following infographic.

Consolidating Syntax Errors in One Tool Window

One of the most frequently requested features via our feedback portal and a feature we were thinking of for quite a while. Before, if a project contained syntax errors (e.g. it had typos or you renamed a field in the data source) you got a massive dialog containing the source of the error, however no easy way to fix it from there. Additionally, this dialog popped up for each and every error so most of you will probably just have clicked the "OK for all" button and started to investigate manually. This was a time consuming, tedious task which often ended up in opening and closing the designer until all errors were fixed.

End User Friendly Conditional Formatting

This is one of the major new features of LL21. Conditional Formatting is needed whenever you want to change properties depending on data, e.g. something like "red font if value is negative" or "highlight the background if value is greater than threshold". This allows to read a report at a glance and quickly get an overview of what areas of your data require a second look.

Enhanced Color Picker

The existing color picker e.g. for the background color property of a field contained a very long list of predefined color values and – at the very bottom – a "Formula…" entry, which was neither very discoverable nor usable. And choosing "Formula…" left it completely to your end users to figure our how to use the RGB, HSL, RainbowColor, HeatmapColor or one of the other color functions. In LL21, we'll introduce a completely new color picker UI.

Major Updates to Included Projects and the Objects Window

Including other projects is a very nice way to reuse objects and ensure a stringent corporate design. I've blogged about this possibility just recently. However, if you heavily use this feature, your object list can quickly become cluttered with lots of objects from includes. You cannot select them, you cannot change their properties – the only useful thing is their context menu which brings you quickly to the included project. This led to a request in our feedback portal to be able to hide these included objects. And yes, List & Label 21 will enable you to do just that.

A First Peek at List & Label 21

As we're starting internal discussions and meetings and the first LL21 sprint is getting in shape I wanted to share this photograph, the result of a two hour meeting between the two guys that are sometimes called "Mr. List & Mr. Label" internally – our Senior Architect Christian Kaiser and myself.