Set Auto Range
The auto range feature for cross tab report types automatically displays report data without having to specify a date range. During set up, you select the data types. Only time stamp types enable the option for configuring the date range and auto range.
For example, if 2005 to 2006 is specified as the date range but only values for 2005 have been entered, the report will only display data for 2005. If a date range is not specified, all data will be displayed in the generated report.
At runtime, users will have the option to select dates or auto range.
To enable the auto range option
- From the Edit Report window, click the Data Elements tab.
- Set time stamp data element (date) under First Column or Body Columns.
If no timestamp data element is specified, all dates with data will be displayed when the report is generated.
- Click Apply.
To set the auto range
- Click the Layout tab, then click Cross Tab. There are two check boxes for auto range.
Note: Only report columns with data appear for non-time-stamp data types. If a data value is not entered, the column will not appear in a cross tab report. If you select the time stamp data type, report columns appear, even if data is not entered.
- For From Date, click the Auto Range radio button.
The date selection option will be grayed out. If From Date is selected and To Date is deselected, all data up until the specified end date will display in the report. For example, to view data up to 2005 but exclude 2006, click Auto Range and enter a To Date of 2005.
Alternatively, to view data from 2004 to present, deselect Auto Range and enter a From Date of 2004.
- For To Date, click the Auto Range radio button.
The date selection option will be grayed out. If From Date is deselected, data entered from the specified start date until present will display in the report. For example, to view data starting from 2004 to the present, click Auto Range and enter a From Date of 2004.
Alternatively, to view data up to 2005 but exclude 2006, deselect Auto Range and enter a To Date of 2005.
If you select both options for the Auto Range From and To dates, only the data supplied for this period will appear in the report.
Last Published Thursday, December 14, 2023