I have a label in a report that I only want to show when a logical field (Turbocharged) is true.
The logical field is defined in a table record and the same field is also defined in the query that generates the report.
I have defined the Conditional Print Expression for the label field as [Turbocharged] (though I have also tried numerous variations including IF) and the label doesn’t appear whether Turbocharged is true or false. What am I doing wrong?
CRDF,
Did you test this on your computer?
'[turbocharged]=true()" does nothing even though turbocharged is set to true.
Thanks,
Erik
The values for a Boolean field are TRUE or FALSE, no quotes or brackets.
What about the suggestion by RobertG (adapted for you here):
IF([Turbocharged];"Label";"")
See/remember How include text in report if condition is true - #14 by RobertG
Or is you "label" more than plain text?
CRDF
Yes, and still not working.
To confirm. I added a label to my report called “My Label”, In the label’s General tab, for Conditional Print Expression, I added “=[turbocharged]=true()” (w/o the quotes).
To do a rudimentary test, can I force the label to show by entering a true condition in the Conditional Print Expression like “=True()”. Why does True have parenthesis? Thanks .
Wanderer,
Regarding trying “IF([Turbocharged];“Label”;”")" (w/o the quotes), I added a text box to my report. I didn’t assign a Data Field in the Data tab, and added your suggested condition in the General tab for Conditional Print Expression, both without and with a leading “=”, and nothing shows. (I’d also like to be able to control a label based on the a logical condition). Interestingly, I never get an error message. Erik
Because it’s a function of the Report Builder:
Category > Logical > TRUE
Logical field should be [Turbocharged]. If this field is never NULL (empty) you only need
Conditional Print Expression → [Turbocharged]
If [Turbocharged] is NULL the query/view for the report has to change it to “false”. An empty field couldn’t be “true” or “false” for the ReportBuilder.
no need of = TRUE() 
But
Seems it runs better with labels than with textfields (which show content of the database). A label will only be shown when [Turbocharged] is true here.
Label is what is asked for.
I knew [turbocharged] – [PAID] to me here – as a boolean should suffice.
But because of quote above did it = (the logical report function) TRUE()
Both works here to me.