How to make the report more impressive? Markers and column properties.

There is the third article of the series about the new generation of our database reporting software. The first one describes most important additions of the new software generation. The second dwells with title, header, and footer customization.

In most cases, we need a way to accent the attention of the report's user to some items. It is "total" column of the table, unusual or unexpected values or even whole rows, etc.

The "column property" feature is easy to use way to assign custom design to some columns of the report. The standard edition of the reporting tool allows users to define one property only. The professional edition has no limitations. Of course, this feature is not suitable for design-less formats: plain text and XML.

To assign custom design to some column the user should make three easy steps:

  1. Select the column.
  2. Specify the list of design items: size, colors, etc.
  3. Add it to the list of the properties.

At the moment the tool does not allow to assign more than one property to the same column. However, the user enabled to assign a few design items at once.

This example shows how to assign a bold font to column "Total":

When the column property operates with the whole column, the marker deals with a single cell or row of the report's table. The marker is a condition based way to modify a design of the report item. The marker is not applicable to plain text and XML output formats.

To create a marker the user should:

  1. Select a column for marker*
  2. Select a column for condition checking. It can be different with a column of the marker.
  3. Select the operation: >, <, =, !=, >=, <=, contains, starts with or in range
  4. Specify the list of design items: size, colors, etc.
  5. Add it to list of markers

* - by default the marker will be applied to the single cell if the condition is true. However, the program can mark the whole row by selected format if the condition is true. The user can switch this option on using "apply to whole row" check box.

This example marks values less 10 by red bold font. To do that we:

  1. Select column for marking.
  2. Select the same column for condition.
  3. Select less as a condition and 0 as a comparison value.
  4. Assign red for font color and check "bold" item on.
  5. Add the new marker to the list.

DTM Query Reporter: define a marker for less 10 values

There is preview for generated report:

DTM Query Reporter: preview for the less 10 value marker

This example marks the whole row by green background if the discount more than 15%:

  1. Switch on "whole" row mode
  2. Select discount column for condition.
  3. Select >= as condition and use 0.15 (15%) for value.
  4. Use green color for background.

DTM Query Reporter: define a marker for the whole row

There is preview for generated report:

DTM Query Reporter: the whole row marker preview

As you can see, the row marker has lower priority than the marker for an individual cell of the report table.

The next article will describe the converters feature. It helps the user to change a presentation of the value as well as markers and column properties change the design of the item.