Report builder conditional color formating

Yahoo Archive
1
Two ways.

1. Whole band method - conditionally print the band depending on a given test value...one band of true the other if false. Two identical sets of fields...just formatted differently as needed.

2. Single band/Individual Field - Change value to be printed to two string fields - if true OK and if false all spaces - then format in color desired and lay one right over the other so that only one or ther other will ever show because spaces are always the same color - transparent. This method is better if you have lots of values on a line that need to be formatted otherwise method ones results in a stack of conditional bands and multiplys quickly (gets confusion). I use #2 for making certain warning values red.

-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of schujamm
Sent: Friday, September 22, 2006 10:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report builder conditional color formating



Is there a way to conditionaly color a record line in a Report Builder
report based on a record value? If so I could use so direction.

Thanks

jim







[Non-text portions of this message have been removed]
2
Is there a way to conditionaly color a record line in a Report Builder
report based on a record value? If so I could use so direction.

Thanks

jim