Filter a databand based on a checkbox
HI,
I would like to have a checkbox in the header of a report and when it is checked only show records with a zero value in a field
if it is not checked then all the records print
Is there an example of this anywhere?
This discussion has been closed.
Comments
Hello!
To filter the DataBand based on the value of a CheckBox on a dialogue box (or a boolean parameter: for example, when the checkbox is ticked, display only rows where Amount == 0, and when it is unticked, display all rows), set the following conditional expression for DataBand.Filter:
[CheckBoxParam] ? ([Table.Amount] == 0) : true