Post reply

Background colour on hidden duplicate fields in SSRS 2005

  • July 29, 2008 at 3:04 am

    #190132

    Hi,

    I'll try and explain this.

    I have a table which looks like this in the detail row

    Field1.value field2.value field4.value field5.value field6.value etc

    We'll call them fields 1 2 3 4 5 6 7 8 9.....

    The table is grouped on field 1.

    The table hides duplicates in fields 1 2 3 4 5 based on that only group.

    Fields 4 and 5 hold a value - which are compared, and if thery are not the same, the background colour is changed to red.

    Fields 6 7 8 9 are 'more detail' - not supressed.

    When I run the report I get (for example)

    Part No | Part Desc | Qty | Part Cost | Part Value | Part detail | Part detail etc

    | Part detail | Part detail etc

    | Part detail | Part Detail etc

    And indeed it's easy to set the first row background colour to be Red when the values don't match - BUT - I want the subsequent 'supressed detail' Fields 4 and 5 to be white - Otherwise I get two columns of Red - which just doesn't look right.

    Either I'm missing something basic or..........?

    Thanks for any ideas....

    Pete

  • July 29, 2008 at 7:28 am

    #849771

    TextBox : Background property

    Edit Expression

    =iif(Fields!Field4.Value <> Fields!Field5.Value,"Red","White")

  • July 29, 2008 at 7:36 am

    #849779

    Bruno,

    Thanks - but - either I'm missing something here - but your solution gives me a column of red - where the duplicated fields are hidden. I only want the first row column made red and the rows underneath to be all white - regardless of the values of fields 4 and 5.

  • July 29, 2008 at 7:46 am

    #849793

    Compare the two fields in the group header.

    So, in the group header they will appear Red or White, and in the detail it will be always white.

    group header : Part No | Part Desc | Qty | Part Cost | Part Value | Part detail

    detail : | Part detail | Part detail etc

    | Part detail | Part Detail etc

    If think i've understand your problem. Sorry if i doesn't. 🙂

  • July 29, 2008 at 8:10 am

    #849814

    Aha.... I see what you mean. And yes, that's the way to go. Thanks.

    I'll tell the person who speced the report that it has to be the Bruno way or not at all.....

    P 🙂

  • July 29, 2008 at 8:19 am

    #849824

    🙂

    Good luck..

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

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