Spreadsheet Properties
[TOC]
The Spreadsheet Builder contains the following properties :
Misc
| Properties | Description |
|---|---|
| DefaultPreset | Used to assign properties to the columns |
Schedule
| Properties | Description |
|---|---|
| DBTabsToShow | Used for comma separated list DB Tabs to show. If empty will show all of them. |
| FirstWeekInclude544 | |
| HideDateTab | Used for date range selector tab visibility flag. |
| HideDayTab | Used for single day selector tab visibility flag. |
| HideDbTabs | Used for database defined custom date selectors visibility flags. |
| HideMonthTab | Used for month selector tag visibility flag. |
| HideShiftTab | Used for Shift selector tag visibility flag. |
| HideYearTab | Used for year selector tag visibility fag. |
| SchdCode | Used to set up the schedule code. |
| StartDay544 | Requires Use544 to be set to true. Marks the day of the week periods of fiscal months. |
| Use544 | Changes the month and year ranges to use the 5-4-4 methodology. |
Spreadsheet
| Properties | Description |
|---|---|
| SpreadSheetName | Modifies the name of the spreadsheet to display in the [DGS tree]( ). |
| SQL | Used to Write, modify, update and delete a query. |
| TimeOut | -1 default refers to no timeout. |