How do I specify Conditional Print on a Boolean field

[SonomaCharles]

I have a report based on a table. The table has a Boolean field, Is_On_Hold.

I specify a label field with a conditional print expression of [Is_On_Hold]=“true” (per the Base documentation).

The label field does not print, even for rows for which Is_On_Hold is true.

What am I doing wrong?

Charles

[RobertG]

Works here as expected.
Please show a screenshot of ReportEditor with properties of the field.

[SonomaCharles]

Here you go. The table. I wish this showed something to identify the row a little better, but trust me, the row with Is_On_Hold checked is the row that shows up as the first #3 line in the report below. There is no query – the report is based on the native table.

The report specification showing the “Hold” label conditional print.

The resulting report. The report line in question is the first #3, “Thisisa Testclient.” Note no red “Hold” under the 3.

Thanks for your help!
Charles

[SonomaCharles]

Cancel! Problem solved. The report IS based on a Query, and Is_On_Hold was not part of the query.

Why didn’t Base give me an error for referencing an effectively non-existent field? Why did Base in fact SUGGEST the field Is_On_hold in a drop-down list for the condition?

Charles

[RobertG]

@SonomaCharles

Why did Base in fact SUGGEST the field Is_On_hold in a drop-down list for the condition?

ReportBuilder will only offer fields, which are available. So it seems when creating Is_On_Hold had been available. Might be you have changed the query?

[SonomaCharles]

I added the column to the table yesterday. I totally forgot about the query. So the query never had the column in it. I added the column to the query one minute ago after I mentally questioned my assertion “the report is based on the native table, not a query.”

CM