call our helpline

Change History

Version: 2.3
Release Date: March 9 , 2012

 

Enancements

- Added ability to create reports by resource from MS Project

- Performance improvements when reporting from MS Project

 

Fixes

- Fixed "Skip Top Rows" feature for reports using Excel as a data source

- Updated digital certficate

 


Version: 2.2.1 - Bug fix release
Release Date: September 21 , 2012

 

Fixes:

- fixes "Compile error in hidden module: qc" error by removing the Tools feature set


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