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.

condition in script

hi

I need to alter a procedure depend on some information .

if A is true then

alter procedure .... < code 1>

else

alter procedure .... <code 2>

is it possible?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1557658&SiteID=1

Check out my post in there.