[Solved] Conditional Formatting Using Report Builder

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] Conditional Formatting Using Report Builder

Postby Mokonzi » Wed Mar 11, 2015 11:10 am

I'm trying to get the Report Builder to format a field based on the contents of another two fields, but no success. I'm struggling to understand how the syntax works for it.

I need one field that is true and another that is false to trigger setting the formatting to italics. Can anyone post any suggestions on the syntax I need to use?

Many thanks.
Last edited by Hagar Delest on Thu Mar 26, 2015 5:09 am, edited 1 time in total.
Reason: tagged [Solved].
Mokonzi

OpenOffice 4.1.1 on Windows 7
Mokonzi
 
Posts: 5
Joined: Tue Feb 10, 2015 7:30 pm

Re: Conditional Formatting Using Report Builder and Expressi

Postby F3K Total » Fri Mar 13, 2015 9:29 pm

Hi,
e.g. Expression is:
Code: Select all   Expand viewCollapse view
AND([B1];NOT([B2]))

See example.
R
Attachments
Report_conditional_formatting.odb
(24 KiB) Downloaded 145 times
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 903
Joined: Fri Dec 16, 2011 8:20 pm

Re: Conditional Formatting Using Report Builder and Expressi

Postby Mokonzi » Wed Mar 18, 2015 11:12 am

Awesome. Thanks for the help matey. :)
Mokonzi

OpenOffice 4.1.1 on Windows 7
Mokonzi
 
Posts: 5
Joined: Tue Feb 10, 2015 7:30 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 3 guests