ReportZilla

ReportZilla is an Excel AddIn that allows you to easily generate reports from ClearQuest - all without programming. The report is generated in Excel, a familiar application, a distributable format.
This allows you to distribute the report by email and allows end users to view the report using Microsofts free Excel viewer. You can customize reports within 5 minutes by simply checking a few boxes and options.
A unique report can be created for every worksheet in a spreadsheet. A spreadsheet; therefore, can contain multiple reports and all of them can be generated with the click of a button.
ReportZilla can use any of these sources as inputs for a report:
ï¿­ ClearQuest
ï¿­ Excel
ï¿­ Databases
ReportZilla seamlessly interfaces with sources (e.g. ClearQuest) to retrieve data. Your report is generated automatically in your format with the click of a button.
Here are some key features of "ReportZilla":
ï¿­ Automatically update pivot tables and charts
ï¿­ Populate the cell you specify with the date/timestamp the report was generated
ï¿­ Total number of records
ï¿­ Group records by any field you specify
ï¿­ Number records for easy reference
ï¿­ Bold specific columns for easy reference
ï¿­ Specify which columns should wrap text to show all detail
ï¿­ Conditionally format fields to highlight relevant information
ï¿­ Hyperlink each record directly to ClearQuest Web record
ï¿­ Generate one report for each worksheet in a spreadsheet
ï¿­ Display column headings
ï¿­ Apply alternate row shading to each record
ï¿­ Display or hide duplicate records
ï¿­ Toggle wrap text dynamically to allow you to view a concise version of the report or the entire report
ï¿­ Turn on Excels Auto filter feature after generating the report
ï¿­ Set the worksheet name to the query name
ï¿­ Sort records by up to 3 fields with the ability to specify the sort order for each field
ï¿­ Specify the location of the report within the worksheet
ï¿­ Resize specific columns based on its content
ï¿­ Specify the font style for group headings, column headings and records
ï¿­ Automatically search and replace text in specific columns or the entire data set
ï¿­ Reports built off of templates
Requirements:
ï¿­ MS Excel