dbabaracus
New member
- Local time
- Today, 03:06
- Joined
- Jul 26, 2017
- Messages
- 4
Is there a way to use conditional formatting for lines or shapes in Report headers?
For example, let's say I'm reporting on groups of color. Instead of using the color field in the header so that it says "Red", "Orange", "Blue" as text, we want to just have a colored line in the header. In the past, we've had separate reports so that the Blue report would only pull Blue records and it had a blue line in its formatting, and so on for each color group.
What I'd like to do is have a single report that can change its line color dynamically based on the Color field in the records. Instead of separate reports for each color, there'd be some sort of formatting rules that say "If <Color field> equals 'BLU' then set line color to <blue color formatting>", "If <Color field> equals 'RED' then set line color to <red color formatting>", etc.
For example, let's say I'm reporting on groups of color. Instead of using the color field in the header so that it says "Red", "Orange", "Blue" as text, we want to just have a colored line in the header. In the past, we've had separate reports so that the Blue report would only pull Blue records and it had a blue line in its formatting, and so on for each color group.
What I'd like to do is have a single report that can change its line color dynamically based on the Color field in the records. Instead of separate reports for each color, there'd be some sort of formatting rules that say "If <Color field> equals 'BLU' then set line color to <blue color formatting>", "If <Color field> equals 'RED' then set line color to <red color formatting>", etc.