all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Matrix Drill Down Issue


Matrix Drill Down Issue Raz
6/20/2006 7:12:02 AM
sql server reporting services:
I have a matrix with dynamic columns and rows. If I apply any filters to the
row groups then the higher levels only reflect the first "store" result set
in the higher levels instead of the aggregate total. If I remove the filters
on each group then the values at each level are correct but my first
[member_caption] at each level is null.
Expression: =Fields!location_Division.Value="" operator: = value: =false
Thanks in advance for your help.

col1 col2 col3 col4 col5 col6
division 5 5 4 4 5 4
region 5 5 4 4 5 4
district 1 5 5 4 4 5 4
store 10 5 5 4 4 5 4
RE: Matrix Drill Down Issue Raz
6/26/2006 5:48:02 AM
Found a way around this problem.....have to select the leaves in your MDX
and sum the column value.......

[quoted text, click to view]
AddThis Social Bookmark Button