Matrix Totals Drilldown

Question

Matrix Totals Drilldown

brunm

SSCommitted

Points: 1792
More actions
February 15, 2008 at 5:19 am

#183116

Hi,
i have a report in SSRS 2005 with a matrix that has a drilldown. Everything works fine except for the drilldown of the total on the matrix. When i drill on this field it defaults the parameter passed to the drilldown report to be the first value in the matrix.
Is there any way i can either stop it drilling on the total or get it to pass in a blank/null parameter as it should be (i have coded the subreport to accept null parameters.)
Any help greatly appreciated

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

fiona.kerr SSC-Addicted Points: 425 More actions · Answer 1

Hi,

Not a helpful answer I am afraid. I have exactly the same problem as you so please, if anyone knows how to do this ..... 🙂

Thanks

fiona.kerr SSC-Addicted Points: 425 More actions · Answer 2

Hi again,

Just got it.

You use INSCOPE like this:

=iif(InScope("matrix2_ColumnGroup1"),Fields!DELIVERY_PERIOD.Value,"01/01/1900")

in the value passed to your parameter for the report you are jumping to. The DELIVERY_PERIOD is what forms my matrix columns so the Total column fails the test and gets my default value.

Hope this made sense.

:-):-D

brunm SSCommitted Points: 1792 More actions · Answer 3

Fiona,

Apologies i should have replied to this when i found the answer. Here is some more detail on what you have found. The following example covers on Clicking on all your Cells in your Matrix (Detail, Column Group, Row Group & Group Group {bottom right hand cell})

For your Row Parameter/Field in your Matrix IN Navigation, Parameter the Inscope syntax will be

=iif(InScope("matrix2_ColumnGroup2"),

iif(InScope("matrix2_RowGroup1"),

Fields!Field.Value,

NOTHING),

iif(InScope("matrix2_RowGroup1"),

Fields!Field.Value,

NOTHING))

For your Column Parameter/Field the Inscope SYntax will be

=iif(InScope("matrix2_ColumnGroup2"),

iif(InScope("matrix2_RowGroup1"),

Fields!FieldValue,

Fields!Field.Value),

iif(InScope("matrix2_RowGroup1"),

NOTHING,

NOTHING))

The examples above are for a One Column, One Row Matrix. You can use similar syntax if you have more than one Column or Row but you will need extra IIF statements