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.
A new row will be available in the grid section.
The Description field can be blank.
In the Row Type field, select Description Title.
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.
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.
This is how Description Title row will look like on report preview based on the above configuration.
Example 2. Specific Year is used for column header
The Description Title row will show specific year when Year is selected in the Caption field. And the year it will show will be based on the Filter Type configured.
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 12/31/2015 date belongs.
This is how Description Title row will look like on report preview based on the above configuration. As shown, 2015 is the Current Fiscal Year.
Example 3. Short Month and Long Month is used for column header
The Description Title row will show specific month when 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.
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.
This is how Description Title row will look like on report preview based on the above configuration.
Example 4. Month and Period Description is used for column header
The Description Title row will show specific month when Month and Period Description is selected in the Caption field. And the month it will show will be based on the Filter Type configured.
The Month caption will show 2-digit value equivalent to the Filter Type setup for the row. The first row in the Fiscal Year setup being 01.
The Period Description caption will take the Period Name in the Fiscal Year screen, equivalent to the Filter Type setup for the row.
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.
This is how Description title row will look like on report preview based on the above configuration.
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. 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.
This is how Description Title row will look like on report preview based on the above configuration. As shown, 2014 is the Fiscal Year.
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.
A new row will be available in the grid section.
The Description field can be blank.
In the Row Type field, select Description Title.
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.
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.
This is how Description Title row will look like on report preview based on the above configuration.
Example 2. Specific Year is used for column header
The Description Title row will show specific year when Year is selected in the Caption field. And the year it will show will be based on the Filter Type configured.
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.
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.
Example 3. Short Month and Long Month is used for column header
The Description Title row will show specific month when 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.
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.
This is how Description Title row will look like on report preview based on the above configuration.
Example 4. Month and Period Description is used for column header The Description Title row will show specific month when Month and Period Description is selected in the Caption field. And the month it will show will be based on the Filter Type configured.
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. 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.
This is how Description Title row will look like on report preview based on the above configuration.
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. 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.
This is how Description Title row will look like on report preview based on the above configuration. As shown, 2014 is the Fiscal Year.