Page 1 of 1
[Solved] Conditionally Color the Field Box
Posted: Fri May 22, 2015 2:40 am
by ewtay
Hi guys,
Needed some help on conditionally coloring the report field box.
How do i... in the Report, applying a Color to all the "0" / "Blank" field under detail section?
Thanks.
Re: Conditionally Color the Field Box
Posted: Fri May 22, 2015 7:01 am
by Sliderule
ewtay wrote:Hi guys,
Needed some help on conditionally coloring the report field box.
How do i... in the Report, applying a Color to all the "0" / "Blank" field under detail section?
Thanks.
I am not entirely certain I understand your question . . . that is . . . do you want to assign a COLOUR to the displayed output . . . OR . . . are you talking about a BACKGROUND COLOUR?
I will assume, you mean, COLOUR to the displayed output ( value displayed ). In that case, please check out . . . Base Help . . . topic
format codes;numbers and look at:
Conditions
So, in the Format for your desired field . . . for example, define the following,
User Defined Number Format
Explanation: The above will apply a colour of
RED when the value is 0, otherwise, it will apply a colour of
BLUE .
Change it to whatever you want.
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your
1st post Subject (edit button top right) if this issue has been resolved.
Re: Conditionally Color the Field Box
Posted: Fri May 22, 2015 4:16 pm
by Sliderule
Please take a look at the following database file,
HSQL-WORLDAREA4.ODB
http://www.mediafire.com/download/l87gc ... DAREA4.odb
In the report,
WorldAreaReport - By Continent - Area_02 the detail column
Area_SQ_KM is displayed with
Conditional Formatting... .
- In the Detail section, click on the field Area_SQ_KM
- From the Menu: Format -> Conditional Formatting...
- Complete the Conditional Formatting pop-up ( dialog ) . . . based on your needs
- You can define RANGES or VALUES for the formatting
- You can define the Text Colour . . . with the icon
- You can define the Background Colour . . . with the icon
- Press OK when complete
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your
1st post Subject (edit button top right) if this issue has been resolved.
Re: [SOLVED]Conditionally Color the Field Box
Posted: Mon May 25, 2015 2:53 am
by ewtay
Wow...
I never thought it is this simple!
Thanks Guys!