Home > Getting Started > Toolbar

Toolbar

The ReportsDNA toolbar provides access to all functionality.  The toolbar can be displayed or hidden by clicking the ReportsDNA button in Excel's menu.  The button will be the last item in Excel's menu except in Excel 2007.  In Excel 2007, access to the button is gained by clicking the Add-ins button (see below).

New/Edit Report
New/Edit Report displays the dialog box which allows the user to define the report’s configuration.

Generate Report
This feature generates the report for the active worksheet. Execution includes clearing the worksheet of data, reloading data from the source and applying the formatting options.

Generate All Reports
This option will generate the reports for all visible worksheets in the workbook that have a report configuration. ReportsDNA will end with the worksheet that was active when this option was chosen.

Summary
This button turns off the Wrap function for columns defined in the Wrap Columns field. This allows you to see more records.

Detail
Report Detail On turns on the Wrap function for columns defined in the Wrap Columns field. This allows you to see multiple rows of data for columns designated with this option.

Workbook settings

Change All - clicking a radio button in Change All will set all workbook-level features to the setting chosen.T

Tools
Opens the list of available tools for quickly and easily inserting formulas, working with filtered data and more.
Click here for more information on Tools.


See also

Overview
Getting Around
Creating Your First Report