Report Writer Returns Incorrect Results with Measure Average as a Dimension

ID: Q218997

The information in this article applies to:

SYMPTOMS

When you apply a filter that contains a measure average as a dimension, Report Writer may return incorrect results.


CAUSE

Not all of the proper items are included in the Select statement when a measure average is used as a dimension.


RESOLUTION

A supported fix that corrects this problem is now available from Microsoft, but has not been fully regression tested and should be applied only to systems experiencing this specific problem. If you are not severely affected by this specific problem, Microsoft recommends that you wait for the next Site Server service pack.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information on support costs, please go to the following address on the World Wide Web:

http://support.microsoft.com/support/supportnet/default.asp
The English version of this fix should have the following file attributes or later:

   Date     Time       Size       File name    Platform
   -----------------------------------------------------
   07/02/98  02:27p        913    Eula.txt     (Alpha)
   02/17/99  05:06p  4,589,056    ReportDA.exe (Alpha)	
   02/17/99  05:06p  4,900,352    ReportDS.exe (Alpha)
   01/27/99  01:56p     80,144    Update.exe   (Alpha)
   02/22/99  01:46p      4,269    Update.inf   (Alpha)

   07/02/98  02:27p        913    Eula.txt     (x86)
   02/17/99  05:06p  3,317,760    ReportDA.exe (x86)
   02/17/99  05:07p  3,526,144    ReportDS.exe (x86)
   01/27/99  01:02p     62,544    Update.exe   (x86)
   02/22/99  01:46p      4,269    Update.inf   (x86)

NOTE: If you contact Microsoft to obtain this fix, a fee may be charged. This fee is refundable if it is determined that you only require the fix you requested. However, this fee is non-refundable if you request additional technical support, if your no-charge technical support period has expired, or if you are not eligible for standard no-charge technical support.

For more information about eligibility for no-charge technical support, see the following article in the Microsoft Knowledge Base:
Q154871 Determining If Your Product Is Eligible for No-Charge Technical Support


STATUS

Microsoft has confirmed this to be a problem in Site Server version 3.0.

Additional query words: hotfix hot fix qfe quick engineering patch 


Keywords          : 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: February 24, 1999