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.
[Solved] Conditionally Color the Field Box
[Solved] Conditionally Color the Field Box
Last edited by ewtay on Mon May 25, 2015 2:51 am, edited 1 time in total.
openoffice 4.1 on windows 7
Re: Conditionally Color the Field Box
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?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 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
Code: Select all
[RED][=0]#;[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
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... .
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
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
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
Wow...
I never thought it is this simple!
Thanks Guys!
I never thought it is this simple!
Thanks Guys!
openoffice 4.1 on windows 7