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?

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

This discussion has been closed.