none
Formatting cells where duplicate values are hidden RRS feed

  • Question

  • So I've got my report designed using a report table with duplicate values hidden. I want to put borders on cells, but I don't want borders on any cells where the values have been hidden. (The reason for this is simply to match the format of a previous version of the report, so it's not a showstopper.) I'm trying to achieve this sort of effect:

    -------------------------------|
    Col1Val1 | Col2Val1 | Col3Val1 |
             |          -----------|
             |          | Col3Val2 |
             ----------------------|
             | Col2Val2 | Col3Val3 |
             |          -----------|
             |          | Col3Val4 |
    -------------------------------|
    Col1Val2 | Col2Val3 | Col3Val5 |
             |          -----------|
             |          | Col3Val6 |
             ----------------------|
             | Col2Val4 | Col3Val7 |
             |          -----------|
             |          | Col3Val8 |
    -------------------------------|

    ...and so on.

    I know conditional formatting can be set with an expression, but how can I determine if a cell's value has been hidden? Testing the value doesn't work because the value is still there, just hidden.

    Any help much appreciated.
    Friday, June 8, 2007 12:13 AM

Answers

  • By grouping the separate columns and adding subtotals, I was able to apply different border formatting  and get the desired effect.
    Friday, June 8, 2007 9:37 PM