Wednesday, March 21, 2012

Error when hiding subtotals in Report Builder

I consequently get an error message in Report Builder (version 9.0.2047.0) when I make a report without subtotals when I have the Key attribute of a dimension in combination with a measure.

The following Report is OK, but when I unselect Show Subtotals, I get an error message.
Date | Count Result
-
10-10-2003 | 200000
-
Total | 200000

The error message is:
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

I have tried experimenting with the GroupingBehaviour on EncourageGrouping or DiscourageGrouping, but without success. I seem to be the only one with this problem.

I am using Reporting Services 2005 in combination with Analysis Services 2005 (9.00.2153.00)Is this a bug in Reporting Services / Analysis Services 2005?

Does anybody have the same problem?

No comments:

Post a Comment