Features
Articles in this section
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