Home > Features

Features

Articles in this section

Data Layout Variables Templates Options Format Save Print Email Advanced Features About

General

• Multiple reports in each workbook – each worksheet contains its unique report configuration.
• Accepts dynamic parameters (e.g., report that always shows data from TODAY)
• Prompt users for parameters at time of report creation
• Invoke a macro before a report is generated, which can be used a data source
• Invoke a macro after a report is created

Data Retrieval

• Retrieve data from any data store
• Display all records, only unique records, only duplicate records
• Filter out unwanted data

Report Layout

• Create report in a table or by using a template
• Group by field
• Sort by up to 3 fields
• Specify field order
• Display field names
• Suppress unwanted fields
• Number records
• Total number of records

Formatting Options

• Specify font, font size, color, style, and row color
• Bold specific fields
• Wrap text for specific fields
• Resize fields to show all data
• Alternate row shading
• Specify maximum row height
• Conditional formatting – format data based on its value
• Format report so field names are always displayed with data

Post-Report Creation

• Automatically save a copy to a file or post to a website
• Automatically print report to a designated printer with a designated number of copies
• Automatically email report
• Automatically update pivot tables and pivot charts

See also