Options
Articles in this section
Column Headings
This box is currently enabled at all times. The column headings for a dataset will be displayed when this setting is enabledSummary
When enabled, the Summary option sets each record's row height to a single line when the report is first generated. Each row will only be one line high even if columns have Wrap Text enabled. This feature is useful for viewing more records (e.g., to find a record). The report's detail can be viewed by clicking the Detail button on the toolbar.
Note: This report-level setting has an equivalent Workbook Setting, which can override it.
EXAMPLE: A comparison of a report generated with the Summary setting disabled and with enabled
Download
| Summary unchecked | Summary checked |
 |
 |
See also
Workbook Settings
Summary toolbar button
Detail toolbar button
Set Sheet Name to Query
Activate this feature and ReportsDNA will rename the worksheet with the name of the query formatted to meet worksheet naming standards. The query name is defined as that portion of the query that does not include the query path. In the example below, the worksheet tab will be set to Active Bugs. The query name will be truncated to 32 characters – the maximum number of characters permissible for a worksheet name.
Query: Personal Queries/Bugs/Active Bugs
ReportsDNA will append an underscore and a number (starting with 1 and incrementing to 9) if another worksheet already exists with the query name. If a worksheet already exists named Active Bugs then ReportsDNA would try Active Bugs_1, Active Bugs_2 and so on until it the worksheet was named successfully. It stops attempting to rename the worksheet after the ninth iteration.
Number Records
This feature numbers all records sequentially starting with the number one. This can assist a reader in locating a specific record.
Change Tab Color
When checked, Change Tab Color will change the worksheets tab color to green (see screenshot belo) when there is at least one record in the data set. This feature is particularly useful when a workbook contains multiple reports that are run using Generate All Reports. It visually indicates which reports contain data.
Auto Filter
Auto FilterTurns on Excel’s AutoFilter feature after the report is generated.
Hyperlinks
Use this feature to add a hyperlink to one of the the fields in each record. This feature requires two settingsHyperlink Column specifies the column where the hyperlink will be placed
Hyperlink specifies the hyperlink associated with the field and takes the following Variables:
| Variable Type | Variable Placeholder | Description |
| field value | &F[Field Name] | Placeholder for the value located in the record's field named Field Name Replace Field Name with the name of the field whose value is to be used. Double-clicking the field name in the Variable Pane (see below) will enter the correct Variable Placeholder at the end of the Hyperlink setting. Variable Pane for Hyperlink setting populated with fields  |
EXAMPLE: A report that links to a website based on the stock ticker in each record of a report.
Download
| Setting | Value |
| Hyperlink Column | Ticker symbol |
| Hyperlink | http://moneycentral.msn.com/money.search?q=&F[Ticker symbol] |
| ReportsDNA | |||
| # | Ticker symbol | Company | Sector |
| 1 | MMM | 3M Company | Industrials |
| 2 | ABT | Abbott Labs | Health Care |
| 3 | ANF | Abercrombie & Fitch Co. | Consumer Discretionary |
| 4 | ADBE | Adobe Systems | Information Technology |
| 5 | AMD | Advanced Micro Devices | Information Technology |
See also