Change History
Version: 2.1.1 - New Tools Release
Release Date: July 18, 2011
System Requirements
Windows 2000 SP3+, Windows X SP2+, Windows Vista, Windows 7
Excel 2002 or greater
Office XP Tool: Web Components [free from Microsoft] not required from version 1.2.2+
Optional: Microsoft Outlook 2000 or greater [required to automatically email reports]
Optional: ClearQuest windows application (required only for ClearQuest reports)
Optional: QualityCenter application (required only for QualityCenter reports)
Optional: MS Project (required only for reports from MS Project files)
New Excel Tools To Enter Formulas For You
Count of Cells With A Special Condition
Count - cells that contain odd numbers Count - cells that contain even numbers Count - cells that are evenly divisible by a number Counf if cells = TRUE Count if cells = FALSE
Count of Cells With Errors
#DIV/0! errors in a range #GETTING_DATA errors in a range #N/A errors in a range #NAME? errors in a range #NULL! errors in a range #NUM! errors in a range #REF! errors in a range #VALUE! errors in a range errors in a range
Count Cells in a Filtered List That Match Criteria
Count - exact string match in filtered data Count - filtered data that CONTAINS a string Count - filtered data that does NOT contain a string Count - filtered data that CONTAINS a string (case sensitive) Count - filtered data that does NOT contain a string (case sensitive) Count - exact number match in filtered data Count - cells greater than > a number in filtered data Count - cells greater than or equal to >= a number in filtered data Count - cells less than < a number in filtered data Count - cells less than or equal to <= a number in filtered data
Dates
Formula that determines if a cell contains a leap year
Hyperlinks
Hyperlink To Cell on the Same Worksheet Hyperlink To Cell in the Same Workbook
Fixes
Fixed link to request a new tool
Version: 2.1 - New Tools Release
Release Date: December 18, 2010
New Tools
Excel Number Formats
$ Thousands $ Millions $ Millions or Thousands € Thousands € Millions € Millions or Thousands Thousands Millions Millions or Thousands
Excel Comparison Tools
Show Differences - Simple, Case Sensitive Flag cells that are equal Flag cells that are not equal Flag cells that as 'Equal' or 'Not Equal'
Excel Counting Formulas
Count - number of errors in a range
Counf if cells start with Count if cells contain text Count cells with with X number of characters Count if cells end with
Excel Totaling Data Formulas
Sum a fixed range of cells
Sum a dynamic range of cells
Sum the largest N numbers in a fixed range
Sum the smallest N numbers in a fixed range
Copying Worksheets/Reports
Copy Worksheet (copies data with cells longer than 255 characters)
Copy Worksheet to Workbook (copies data with cells longer than 255 characters)
Fixes
minor bug fixes
Version: 2.0
Release Date: October 10 , 2010
Enhancements
Enhancement: New email component now completely external to Outlook. Users without a license will have to acknowledge security warnings when a report is automatically emailed.
Enhancement: Point-and-click formulas. Stop memorizing formulas. Just click on what you want and let ReportsDNA enter the formula.
- New formulas for workbook, worksheet and cell properties include: worksheet name, workbook filename, workbook path, filename, cell address, cell row and cell column.
- New formulas to provide counts for a data range: number of columns, rows, cells, empty cells, non empty cells, unique numbers, unique text and numbers, duplicate number and duplicate text and numbers.
Enhancement: Point-and-click Excel number formats. Need to hide zero values or format a number so only one decimal point is showing? Just click on the format you want and let ReportsDNA do the work.
Fixes: minor bug fixes
Version: 1.5.0.1
Release Date: August 27, 2010
Fix: Updated digital certificate for email component
Version: 1.5 - MAJOR CHANGE
Release Date: August 11, 2010
Enhancements
Enhancement: New feature 'Quick Filter'
Enhancement: New feature 'Freeze Pane' (Options tab) will set Freeze Panes after a report is generated
Enhancement: New feature 'Autofit All Columns' (Options tab) will autofit all columns to the data within the column. This feature overrides the 'resize' setting for individual fields specified in 'Field Formats.'
Enhancement: New Feature 'Denormalize' (Data tab) denormalizes designated columns
Enhancement: Simplified conditional format settings
Enhancement: Performance optimizations for analyzing tens of thousands of records
Enhancement: New options for removing and identifying duplicates (see Data tab)
- Remove Duplicates
- Find Duplicates
- Highlight Duplicates
- Find Unique Records
- Highlight Unique Records
- Find Records With A Duplicate
- Highlight Records With A Duplicate
- Find Records That Occur Once
- Highlight Records That Occur Once
Enhancement: Tools for working with data in any worksheet (see Tools in ReportsDNA toolbar)
- Tools for use with filtered data
- Quick filter
- Delete Hidden Rows (records that did not meet filter criteria)
- Delete Visible rows (recoreds that met filter criteria)- Tools for handling duplicates: same features provided for reports plus
- Flag duplicates with user-specifed labels
- Provide count of record occurrences
- Tool for highlight differences in cell text between two sets of data
Enhancement: Modified the 'Field Formats' form: Yes/No settings now operate like radio buttons. Click on a Yes/No setting automatically toggles the value. Previously, the user would have to select the setting and then use the dropdown to select the new value.
Enhancement: New number formats:
"$ Thousands","$ Millions",
"€ Thousands", "€ Millions",
"Thousands or Millions",
"Align # at Decimal",
"Decimal as Fraction"
Enhancement: Conditional Format, "Field(s) to Format" column modified to autopopulate with the value in the "In Field" column.
Enhancement: Performance optimiztions to 'Advanced Filter'
Fixes
Fix: 'Currency' Number Format was incorrectly applying the 'Accounting' format
Fix: Report Configuration fields that referenced a cell on another worksheet were not saved with the report configuratoin
Fix: Field Formats, incorrect Format Preview when a previously saved format was viewed
Fix: Copy to Workbook, fixed title for window requesting the destination workbook
Fix: Reports longer than 32267 rows would not clear prior to rerun
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 Generated 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