Alternate Back Color

[mmckeage]

Hi All,
I would like to change the background color of a footer, in the event that such footer has data. I am using this footer to generate a subtotal, if a customer has purchased more than one item- if only one, then the subtotal doesn't show up. So in the case where Count = 1, the report does not subtotal, but otherwise does. I would like for the report to change the background color, too. There is a format called "Alternate Back Color", but I don't know how to trigger that event. Any help would be appreciated!

 

[DCrake]

You could place a box in your footer the same size as the footer and send it to the back. set the back colour you want and use the same rule as your sub total to determine if this box it visible or not.

 

[mmckeage]

Thanks for the reply. I think that will work, as this report does not change size. I guess what I really wanted is a conditional back color.

 

[vbaInet]

Use Conditional Formatting on the textbox and refer set it to Field Value Is 1 with the backcolor settings for the condition and the default.

 

[mmckeage]

Thanks. I am also wondering if I can eliminate the spacing generated for the subtotal when the calculations do not get performed (in those cases where the customer only has one contract)?

 

[vbaInet]

What do you mean? Maybe explain with some screen shots.

 

[mmckeage]

Will try to work up a screen shot, but I guess ultimately, I am asking if there is such an event as a conditional footer, which is active and produces subtotals when a customer has more than one contract, and then is not active and it's height is zero so it doesn't create the space for a subtotal on the report if the customer only has one contract.
Don't know if it matters, but this is a cross-tab report.

Currently, I get:
Customer 1: Contract A: 1 2 3
{dead space where a subtotal would be}
{spacing between customers}
Customer 2: Contract B: 2 3 4
Customer 2: Contract C: 3 4 5
Customer 2 Subtotal: 5 7 9

What I would like is:
Customer 1: Contract A: 1 2 3
{spacing between customers}
Customer 2: Contract B: 2 3 4
Customer 2: Contract C: 3 4 5
Customer 2 Subtotal: 5 7 9

 

[vbaInet]

If you think about it your report layout will be inconsistent. Reports are all about layout and consistency. Let the report subtotal still appear even though it's one transaction for that customer.