Change History
Version: 1.4
Release Date: March 1, 2010
Enhancements
Enhancement: Modification to allow free use
- Free version requires a new download every 120 days
- Free version places a Generaterd by ReportsDNA.com on each page of the report
Enhancement: Automated installation and uninstall
Enhancement: Option to create shortcuts to the uninstaller, manual and forums in the Start Menu
Enhancement: Option to install extensions for Microsoft Project, HP Quality Center and Excel 2003+ Lists
Enhancement: Increased number of fields from 30 to 60 in the Field Format feature
Enhancement: Email spreadsheet as a zip file
Enhancement: Ability to automatically check for updates every 30 days (see About box)
Fixes
Fix: Field Format - Toggle Displayed Fields button didn't do anything when first clicked.
Fix: Field Format - Moving fields up and down didn't appear to function if the list of displayed fields were filtered (using the Toggle Displayed Fields feature)
Fix: An extension's configuration form would redisplay after it's OK or Cancel button was clicked
Fix: The configuration form for a data source wouldn't display when the Source was clicked if it was already selected. It would require a double-click.
Fix: Conditional format could fail if all columns in the report were not displayed (by setting the field's Display setting to No in the Field Format feature
Version: 1.3.1
Release Date: January 29, 2010
Enhancements
Enhancement: Added the ability to specify if the Duplicates function is case sensitive.
Enhancement: Added Sentence case as a format option for both field names and data.
Enhancement: Email spreadsheet as a zip file
Fixes
Fix: Fixed activated licenses that expire as if they were a trial.
Fix: report checkboxes would not hold settings in non-US versions of Excel
Fix: Type Mismatch error in non-US versions of Excel.
Fix: Field Formats would display fields in a random order the first time they were displayed.
Version: 1.3
Release Date: November 25, 2009
Release Notes
ReportsDNA 1.3 uses a new format for saving column settings. As a result, the following settings may be lost for reports configured using previous versions of ReportsDNA:
- Column Order
- Number Format
Enhancements
Enhancement: rename column names
Enhancement: set the case for column names (UPPER, lower, Capitalize First Letter Of Each Word (aka Title)
Enhancement: set the text alignment and indent (left, center, right, full, distributed, justify) for data in the report.
Enhancement: new interface for specifying columns to delete, bold, wrap and resize
Fixes
Fix: "Type mismatch" error that occurs after agreeing to the license agreement.
Fix: Updated code signing license for ReportDNA's Outlook component
Version: 1.2.3
Release Date: September 17, 2009
Fixes
Fix: Fixes compile errors in Excel 2002 when editing a report or when creating a new report
Version: 1.2.2
Release Date: September 16, 2009
Enhancments
Enhancement: Removed requirement for Office XP Web Tools
Enhancement: Added Zip Code, Zip Code + 4, Phone Number and Social Security Number formats to Field Formats.
Enhancement: New Field Format form.
Fixes
Fix: “Could not load an object because it is unavailable on this machine" error.
Version: 1.2.1
Release Date: August 25, 2009
Fixes
Fix: "Type mismatch" error that occurs after agreeing to the license agreement.
Version: 1.2
Release Date: August 10, 2009
Enhancements
Enhancement: added ability to group by multiple fields
Enhancement: changed group label to multiline (wrap text)
Enhancement: extended the number of report properities available for extensions from 20 to 50 (required for RNA-Project 1.2.3)
Enhancement: easier form for entering search and replace settings
Enhancement: easier form for entering conditional formatting settings.
Enhancements: changes related to the "Record Count Text" setting
- added Superscript (&X), Subscript (&Y) and Strikethrough (&S) formatting
- added report settings variables
*********************************************************************
CLEARQUEST SOURCE VARIABLES
*********************************************************************
&R[CQ_QUERY]
&R[CQ_DATABASE]
&R[CQ_SCHEMA]
&R[CQ_USER]
&R[CQ_PARAMETERS]
*********************************************************************
EXCEL SOURCE VARIABLES
*********************************************************************
&R[EXCEL_FILENAME]
&R[EXCEL_WORKSHEET
*********************************************************************
DATABASE SOURCE VARIABLS
*********************************************************************
&R[DB_FILENAME]
&R[DB_WORKSHEET]
&R[DB_QUER
Fixes
Fix: repeated requests to enter a license after a license has been successfully activated.
Fix: colors chosen for conditional formatting may not reflect the color chosen
Version: 1.1.5
Release Date: May 22, 2009
Enhancements
Enhancement: added ability to sort by custom lists (including ability to sort multiple columns by custom lists)
Fixes
Fix: error displayed when 'Criteria Range' dropdown clicked on the 'Data' tab when a worksheet has not been specified.
Fix: record count incorrect when duplicate records functionality and template layout used
Fix: 'Duplicate records' functioned incorrectly when 'Report Location' did not start in column A
Fix: Column chooser did not display template columns when 'Table Style' option enabled
Fix: 'Duplicate records' would delete the entire row where a duplicate existed. It should only delete data from the data set.
Version: 1.1.4
Release Date: April 09, 2009
Fixes
Fix: Data fields with content > 900 characters would appear as empty.
Version: 1.1.3
Release Date: February 05, 2009
Enhancements
Added: additional date variables (e.g., month, date, year) to ClearQuest Dynamic Parameters
Fixes
Fix: Changes to email functionality to improve stability.
Fix: Delete (Columns) does not display columns previously marked to delete in the field list
Version: 1.1.2
Release Date: January 26, 2009
Enhancements
Added: Ability to activate license on a machine without an internet connectoin
Added: Ability to load ClearQuest dynamic parameters from a file
Added: Status of report creation to Excel's status bar
Fixes
Fix: memory leaks when report configuration forms are displayed
Fix: Conditional formatting would only function if Search and Replace was enabled
Version: 1.1.1
Release Date: January 20, 2009
Enhancement:
Added - performance improvements to template-style reports
Fixes
Fix: Stratification failed when the original data source is Excel and the "Skip Top Rows" setting is not set to zero
Fix: SaveCopyAs failure when report is located in the drive's root folder
Fix: number records was out of order if sort was applied (bug introduced in version 1.0)
Fix: Field Formats - did not work properly in conjunction with either Group By feature or Delete Columns feature
Fix: Hyperlinks were not generated when Group By feature was set
Outlook Component (VBAProject.OTM)
Version: 1.1
Enhancement: Compatibility changes required for ReportsDNA 1.1.1
Version: 1.1
Release Date: January 9, 2009
Enhancements
Enhancement: Added ability to specify the format for each field (e.g., set the format for a field that contains a date to a date format)
Enhancement: Added the Stratification feature, which generates a seperate report (workshet) for each unique value in field.
Enhancement: Added the stratification value as a variable for Email fields (To, CC, BCC, Body, Subject), and Save As settings
Enhancement: Renamed 'Save to File' button to 'Save Settings'
Enhancement: Renamed 'Load from File' button to 'Load Settings'
Enhancement: Added enumeration constants for Extension Parameter Types
Enhancement: Added checkbox to turn Search and Replace off without deleting Search and Replace settings
Enhancement: Added checkbox to turn Conditional Formatting off without deleting Conditional Formatting settings
Enhancement: Performance enhancements to Search and Replace
Enhancement: Added option to email the entire workbook or only the worksheet (current report)
Enhancement: Added option to save copy of the entire workbook or only the worksheet (current report)
Fixes
Fix: Cell formatting for 'Record Count Text' field - some codes (e.g. Bold) were not evaluated properly in all cases
Fix: Advanced Features tab: removed 'Active Workbook' checkbox since it was not fully implemented
Fix: Defect which limited datasets to 37266 records'
Fix: 'Delete method of range class failed' warning displayed when rerunning a report with autofilter enabled and delete columns specified
Fix: disabled ability to set autofilter option when 'Group By' option is set
Fix: 'Save' failure would prevent 'Save Copy' from executing
Fix: A successful 'Save' would be reported as a failure if 'Save Copy' failed
Fix: The following which did not work properly if the report's location did not start in column "A": column order, hyperlink column assignment
Fix: Sort when using template layout and remove duplicates option selected
Fix: 'Group By' feature would change column widths for every column that followed the column used for grouping
Fix: Fields with "wrap text" turned on would lose their indent
RNA Extension for Microsoft Project
Version: Release Candidate 1.2
Enhancement: Added option to hide summary tasks
Version: 1.0.2
Release Date: December 23, 2008
Enhancements:
- Added prompt to uninstall or enter license at the end of the trial period
Click here to view the online manual
Version: 1.0.1
Release Date: December 02, 2008
Enhancements:
- Added ability to bold, italicize, underline and set the font size for the Record Count Text field
- Reduced the size of the report configuration form
Version: 1.0
Release Date: November 17, 2008
Initial release available for purchase.
Version: RC1.2
Release Date: October 7, 2008
Fix: Installation failures caused by incorrect date localization
Enhancement: Remove unresolveable email addresses when email feature utilized
Version: RC1.1
Release Date: October 6, 2008
Fix: ClearQuest login problems for ReportZilla upgraders
Fix: Report settings not saved
Version: RC1.0
Release Date: October 1, 2008
Baseline release candidate