Home > Features > Options

Options

Articles in this section

Sort

Group By

Stratify

Column Headings

Summary

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

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. 

Autofit All Columns

This feature will resize the width of all columns in the report.  With this feature checked there is no need to set the Resize columns setting for every column.

Note:  This feature has no effect on columns where Wrap is set.

Freeze Panes

Executes Excel's Freeze Panes feature after the report is generated.  The location of the Freeze Pane can be set by clicking the underscore button.

Auto Filter

Filter Dropdowns
Filter Dropdowns turns on Excel’s Filter feature after the report is generated.


Apply Saved Filter
When checked, this feature will turn on Excel's Filter feature and apply the filter that was previously saved.

Save Filter
Click this button to save the filters that are currently applied to your data when in Filter Mode (see Filter Dropdowns) . 
The filters can then be applied automatically after generating a report be checking the Apply Saved Filter checkbox (see above).

---

Hyperlinks

Use this feature to add a hyperlink to one of the the fields in each record.  This feature requires two settings
Hyperlink 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

Data
Layout
Variables
Templates
Format
Save
Print
Email
Advanced Features
About