Post reply

SSRS Matrix Grand Total Conditional Hiding

  • September 21, 2009 at 4:49 pm

    #210024

    Hi Friends

    I am facing some problem with Matrix Grand total Hiding.

    I have matrix in my report.

    mar apr Tot

    water 1 10 23 34

    2 23 0 25

    3 1 1 5

    Total 34 24 64

    what i want here

    I want to show 24 in red colour that means total Value is less than 20 ,it has to be showed in red colour.

    Can anybody help me ,its very urgent to me.

    thanks

  • September 21, 2009 at 5:54 pm

    #1056519

    Most likely you will want to put a conditional expression in the BackgroundColor property of the matrix cell, which tests both the value in the cell and whether it is currently being rendered in the subtotal row.

    However, you were not completely clear in your example - you seemed to indicate you wanted to show the number 24 in red because it was less than 20?

  • September 21, 2009 at 6:05 pm

    #1056520

    Hi

    I already tried ,but i am getting all rows in table which are less than 30.

    i want to show only in grand total field,not total field and detail coulmn field.

    and grand total field is not letting me to see properties.

    Please let m eknow if you can not understand.

  • September 21, 2009 at 6:51 pm

    #1056526

    This is the table i got.Here report has 2 20's.What i want ,in grand total column i want to show in red colour.

    TemP IDS 2009 2008 Total

    Pr1 10 23 33

    Pr2 10 20 34

    Grand Total 20 43 67

    I hope it makes sense.

    Plaese help me if any one knows

  • September 21, 2009 at 10:33 pm

    #1056549

    Try the following expression in the BackgroundColor property of the matrix cell:

    =IIF(Not(InScope("matrix1_rowCategory")) And Sum(Fields!cellvalue.Value) <= 20, "Red", Nothing)

    where matrix1_rowCategory is the name of your matrix's row category, and cellvalue is the data field.

  • September 21, 2009 at 11:27 pm

    #1056556

    Thanks Friend

Viewing 6 posts - 1 through 5 (of 5 total)

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