Hello,
I'm trying to setup a check box for an existing report. The report lists items from an inventory table. I'm trying to add a new column called "Computer" that will display a check box (or a YES flag or something) next to any item in the report if it is a computer.
Computers are denoted in the data by the 'Code' field from the 'inven' table. If the Code is equal to 25, then the item is a computer.
I figure the logic would be something similar to this: If ( Code = '25' ), Print ('Yes'), Else Print (' ')
If there's a way to actually put a check in the text box, then that'd be great too. I suppose it's not mandatory, but nice to have.
I played around with the expression builder, but I couldn't figure out how to do this seemingly simple add-on. I have the 'Computer' heading showing up fine, but the check box and associated logic is a bit harder. Any thoughts?
Thanks.