Change row color when drilling down 1

[tshad]

We have our reports striped but would like to change the color of the row when we drill down.

For example, we have a report with retailers and totals for that retailer. Each row is either gray or white alternately. But if you want to see all the stores for that retailer, you press the plus sign and it drills down and shows you all the stores. We want to change the color of the Retailer row to brown. Then when they close the row, they want it back to the striped color (gray or white).

Is there a way to do this?

Is there some property we can access from a script task that tells us whether the row is drilled down or not?

Thanks,

Tom

 

[xlbo]

Try using the Inscope function in your background colour definition. The Inscope function should tell you which group the data is residing in so if in Store group then brown

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[tshad]

That was exactly what I was looking for.

The way I would use it is I have Group Document, which would be striped, using the following function that stripes the rows alternately gray and white:

=Code.AlternateColorDocumentGroup1("#F1F1F1", "White", True)

Now if the Group Retailer is open when drilled down, I would have the something like the following in the 1st cell of the group:

=IIF(InScope("Document"),"Green","Brown")

But this changes the current cell. Is there a way to change this to change the cells in the Document group?

Also, when it is closed to go back to the original function (AlternateColorDocumentGroup1) mentioned above?

Thanks,

Tom

 

[xlbo]

=IIF(InScope("Retailer"),"Brown",Code.AlternateColorDocumentGroup1("#F1F1F1", "White", True))



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question