You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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.


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.

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.

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 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.


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
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.


 

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.


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.

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.


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.

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.

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 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.


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
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.


 

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.


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.

  • No labels