Post reply

Indicators in SSRS

  • April 16, 2012 at 8:03 am

    #256555

    My result set has 3 category of values.

    Collected.

    Not Collected.

    Delay by xyz mins.

    My Requirement is to set the green indicator on the status column for all the rows where value is collected, Yellow for Delay and Red for Not collected.

    I have added the indicators and it is allowing only numeric values but in my case i have defined data.

    Can any one throw some light in this regard.

    Also when i place my cursor on the status row where yellow color exists it should display that it is delayed by xyz mins.

    Regards,

    Sandhya

  • April 17, 2012 at 1:42 am

    #1474548

    for the colouring you will want to put an expression on the fill property which uses with SWITCH of IIF passing in the field value and then saying if Delay then red into the clauses

    =SWITCH(Fields!Field1.Value, 'Delay', 'Green',..............

    =IIF(Fields!Field1.Value = 'Delay', 'Green', IIF(Fields!Field1.Value = ..................

    For the xyz mins you will want to look at tool tips on the tablix.

Viewing 2 posts - 1 through 2 (of 2 total)

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