Friday, March 23, 2012

Matrix subtotal problem

Hi,

I have a matrix report like this,

  Product 1 Product 2 Product 3 subtotal Dept A         Dept B         …         subtotal        

for some issues, I must add a group filter to filter out some departments that I don't want to show them on this report (ex. Field!dept.value !="A"). Additionally, My users can input the date interval to query by report parameters. When the date interval user inputed only have Dept A data , the report return some error message(I have set the norows property to show "nodata" if there is no data meet the condition). But when I remove the subtotal ,it works and return "nodata" message. I think there's some problem with the subtotal, but I have no idea where to figure it out.

Anyone would give me a help ?!

First, I recommend to install SP1 of SQL Server 2005.

Regarding the filter on the group - it will only apply to the group data but no to the subtotal because the subtotal is not in the scope of the grouping. So if you want to really remove the values for certain groups and a subtotal is present, you should filter directly in the query, at the dataset level, or at the matrix level.

-- Robert

No comments:

Post a Comment