February 11, 2010 at 6:19 am
I am new to SSRS matrix report. I am currently facing the following problems:
. I have no column grouping
. I have two rows grouping Matrix1_level1 and Matrix1_level2
I have the following expression inside a cell in a matrix data region.
=iif(inscope(“Matrix1_level2″),
“Within Group2 Scope”,
iif(inscope(“Matrix1_level1″),
“Within Group1 Scope”,
iif(inscope(“matrix1″),
“Within Matrix Scope”,
nothing)))
But this is not working. The result I get is this.
On both group1’s line and group2’s line as “Within Group1 Scope”.
and subtotal
“Within Matrix Scope” message is showing up.
Actually, I need to find the percentage distribution with respect to different grouping levels inside a matrix ssrs reports. Please see the problems description!
I thought of using the inscope () and sum (field,"scope") to calculate the percentage distribution
I.e. IIF (inscope (level6), sum (field, "level6")/sum (field, "level5")
Can anyone please comment on inscope() and sum() function with scope!
May 10, 2011 at 4:35 am
Did you work this out, I have similar issues and can't quite get my head around it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply