Conditional Colour in Report Header

All,
I need to alter the Header Bar background colour in my report
depending on who the report is being prepared for. For example, client
accounts that start **P need to have a blue background whereas client
accounts that start **A need a red background.
Any help on how to switch the colour conditionally would be greatly
appreciated.
Thanks,
Scott.Just put a formula in the appropriate Color property:
=iif(...)
Cheers,
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"scottf" <scottfuk@.yahoo.co.uk> wrote in message
news:b4349ea7.0411230619.2f1771c7@.posting.google.com...
> All,
> I need to alter the Header Bar background colour in my report
> depending on who the report is being prepared for. For example, client
> accounts that start **P need to have a blue background whereas client
> accounts that start **A need a red background.
> Any help on how to switch the colour conditionally would be greatly
> appreciated.
> Thanks,
> Scott.