Error: Name Ranging not working properly with Union Reports

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Symptoms

The following are examples of error messages that may occur:

  • Name Ranging not working properly

Causes

When running data out to multiple sheets in a Union Report Alchemex under some circumstances can name columns incorrectly with trailing underscores on the end of the names. This was due to a problem with the Names being global names as opposed to local sheet names. Additionally the Data Set Name "RawData" was only being applied (again globally) to one of the output sheets.

Resolution

This has been corrected as well and the name is now applied locally to each output sheet. Note that this problem in some cases could cause Excel Formulae to not work in the output book. To correct the problem please upgrade Alchemex.exe to version 3.6.0.0 or later

Applies To

  • Alchemex