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 Microsoft's 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 Excel's 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