ReportZilla1.54

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? DatabasesReportZilla 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 templatesRequirements:? MS Excel