ReportsDNA extends the capabilities of Excel to allow anyone to create customized reports without programming. It is designed for users, not developers so it is easy to use. It comes with built-in ability to generate reports from any data source Excel can import: databases, web pages, xml, files, .... Furthermore, it can be extended to accept additional sources like ClearQuest or PC/M Plus Remedy. Just install the extension and the data source is fully integrated into ReportsDNA.
Most importantly, reports are generated in Excel, an application familiar to most people . This allows you to distribute the report by email and allows end users to view the report using Microsoft’s free Excel viewer.
Implementation
ReportsDNA is an Excel AddIn. It can be installed in minutes by an individual or deployed throughout the Enterprise as part of Excel. The configuration for each report is stored in each Excel worksheet. There are no additional configuration files. The report can be run on any computer that has ReportsDNA installed.
Features
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