Sum of a SQL Analysis Services calculated measure within a Reporting Services report gives #Error
Summing a SQL Analysis Services calculated measure result within a Reporting Services report gives #Error but the same calculated measure output can be summed within Analysis Services perfectly fine.
Environment: SQL Server 2008 Analysis Services and Reporting Services + SP1, Report builder 2.0 sp1. This should be applicable to all SQL 2008 and 2005 Reporting Services versions prior as well.
If you look at a report builder report, an expression of " =Sum(Fields!highsales.Value)" on a Analysis Services calculated member gives #Error. The zeros in column "highsales" are numeric values.
The report (see screen shot #1 below) is generated base on the following MDX:
Tags: ssrs