Report Option List
The Report Option List tool in the Report Tools library is used to draw a trio of checkboxes that allow users to set some formatting attributes for their reports, as displayed below:
The purpose of each checkbox is as follows:
• Use Excel to Display Screen Reports: When the Use Excel to Display Screen Reports checkbox is selected and the Screen Display report output format has been selected, the resulting report will be displayed in a Microsoft Excel spreadsheet. If the Use Excel to Display Screen Reports checkbox is not selected and the Screen Display report output format has been selected, the resulting report will be displayed in a simple window.
• Use Separate Sheets/Tables: When the Use Separate Sheets/Tables checkbox is selected, and the output format is configured to use Microsoft Excel or Microsoft Access, the report data will be saved in separate spreadsheets or tables. If the Use Separate Sheets/Tables checkbox is selected, and the output format is configured to use Microsoft Excel or Microsoft Access, the report data will be saved in a single spreadsheet or table.
• Rename Sheets/Tables: When the Rename Sheets/Tables checkbox is selected, and the output format is configured to use Microsoft Excel or Microsoft Access, the spreadsheet(s) and table(s) into which the report data is saved will be renamed to correspond to the date and time at which the report was generated. If the Rename Sheets/Tables checkbox is not selected, and the output format is configured to use Microsoft Excel or Microsoft Access, the spreadsheet(s) and table(s) into which the report data is saved will be left with their default names (e.g. "Sheet 1", "Sheet 2", etc.).
The graphic editor for the Report Option List Editor dialog is as shown:
(Click title to expand text)
The Title field is used to enter the text you wish to be displayed above the completed Report Option List.
The Focus ID spin box is used to select a number representing the order of this completed object group in the overall tab order.
When you configure some or all of the report tools on a page, each object is given a focus ID that identifies that object's place in the tab order (that is, which object will be selected when the Tab key is pressed). This does not control which object will initially have focus when a page is opened – that belongs to the first item drawn on the page that can receive focus. (i.e. the first graphics statement in the page’s source file).
The Draw Bevel checkbox is used to indicate whether or not the completed Report Option List object should be drawn with a beveled border. If the Draw Bevel checkbox is selected, the completed object group will be drawn with a beveled border surrounding it. If the Draw Bevel checkbox is not selected, the completed object group will be drawn without a beveled border.
The Align Title checkbox is used to specify whether or not you wish the Report Option List object group's title to be included in the Vertical Alignment calculation (see below). If the Align Title checkbox is selected, the title will be included in the Vertical Alignment calculation. If the Align Title checkbox is not selected, the title will not be included in the Vertical Alignment calculation.
The Vertical Alignment radio buttons enable you to specify the alignment to be applied to the Report Option List object group, its title and bevel vertically within its drawing area. You may select one of:
• Top: The Top radio button indicates that the Report Option List object group, its title (if the Align Title checkbox has been selected), and its bevel (if the Draw Bevel checkbox has been selected) will be aligned to the vertical top of its drawing area.
• Centered: The Centered radio button indicates that the Report Option List object group, its title (if the Align Title checkbox has been selected), and its bevel (if the Draw Bevel checkbox has been selected) will be aligned to the vertical center of its drawing area.
• Bottom: The Bottom radio button indicates that the Report Option List object group, its title (if the Align Title checkbox has been selected), and its bevel (if the Draw Bevel checkbox has been selected) will be aligned to the vertical bottom of its drawing area.
The All Users Can Edit checkbox is used to indicate whether or not all logged on users may use the objects in the completed Report Option List group, regardless as to the privileges that have been granted to their user account. If the All Users Can Edit checkbox is selected, then all users may use the objects in the completed Report Option List group, regardless as to their privileges. If the All Users Can Edit checkbox is not selected, then only users who have the Configure privilege granted to their user account may use the objects comprising the Report Option List group.
Note: Information on the Configure security privilege can be found in System Privileges.
Note: Information on configuring a custom reports page can be found in Creating a Customized Reports Page.