Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...



This is how Description Title row will look like on report preview based on the above configuration. As shown, 2014 is the Fiscal Year.


You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.

Expand
title14.4
The Description Title row is a row intended to show column headers configured in the Column Designer.
Follow these steps to add a Description Title row.
  1. A new row will be available in the grid section. 
  2. The Description field can be blank.
  3. In the Row Type field, select Description Title.
  4. All other fields are not anymore necessary so you can leave those out.

This is how Description Title row will look like when you follow the above steps.

Image Added
The following will illustrate how this row is being used and how it is configured to properly work with column designer. 

Example 1. Column Header value is used for column header

The Description Title row will show the Column Header value if Column Header is selected in the Caption field.

Image Added

This is how Description Title row will look like on report preview based on the above configuration.
Image Added

If other captions are selected in the Caption field, then it will show specific value based on that caption.

Example 2. Specific Year is used for column header

The Description Title row will show specific year since Year is selected in the Caption field.  And the year it will show will be based on the Filter Type configured.

Image Added

Take note also that the As of Date in the Report Settings screen will be the basis of what year is your fiscal year. In this example, it will get the Fiscal Year where 09/11/2014 date belongs.

Image Added 
Image Added
This is how Description Title row will look like on report preview based on the above configuration. As shown, 2014 is the Current Fiscal Year.

Image Added
Example 3. Short Month and Long Month is used for column header

The Description Title row will show specific month since Short Month and Long Month is selected in the Caption field.  And the month  it will show will be based on the Filter Type configured.

Image Added
Take note also that the As of Date in the Report Settings screen will be the basis to determine what month is your current month. In this example, since the As Of date is a date in September, the current month is September.

Image Added
This is how Description title row will look like on report preview based on the above configuration. 

Image Added

Example 4. Month and Period Description is used for column header
Note: This will be implemented on version 14.1.

The Description Title row will show specific month since Month and Period Description  is selected in the Caption field.  And the month it will show will be based on the Filter Type configured.

Image Added
 

The Month caption will show 2-digit value equivalent to the Filter Type setup for the row.

The Period Description caption will take the Period Name in the Fiscal Year screen, equivalent to the Filter Type setup for the row.
Image Added
Take note also that the As of Date in the Report Settings screen will be the basis to determine what month is your current month. In this example, since the As Of date is a date in September, the current month is September.

Image Added

This is how Description title row will look like on report preview based on the above configuration. 

Image Added



Example 5. Fiscal Start and Fiscal End is used for column header

The Description Title row will show specific date that is equivalent to the Fiscal Start date and Fiscal End date.
Image Added
Take note also that the As of Date in the Report Settings screen will be the basis of what year is your fiscal year. In this example, it will get the Fiscal Year where 09/11/2014 date belongs.

Image Added
Image Added
This is how Description Title row will look like on report preview based on the above configuration. As shown, 2014 is the Fiscal Year.
Image Added

You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.