Populating checkbox text/label on the report

Question

Hi,I've checkboxes on the form and wanted to use them in the report. In report, it only shows yes/no that is if checkbox is selected or not and doesn't show the checkbox text. Form:Report:Is there a way I can show actual text or name of that checkbox in the report instead of yes/no? If multiple checkboxes have been  selected then can we handle that scenario? Thanks in advance!------------------------------Mrunali Kadam------------------------------

SSNJeffP · Answer

You can just create a formula text field for each of these and use if statements to handle it like this:

If([Create or Delete a Product]=1, "Product Created or Deleted", "Product Not Created or Deleted")

Then show that field in your report instead.

Alternately:

You can use report formulas to do this directly in the report.

In the report builder, under the 'Report Formulas' Section, create a new report formula and enter the formula above:

That formula will then appear as a column you can add to the report.

Note that these values would only be visible in that report and not usable anywhere else (if that matters for your purpose).

------------------------------
Jeff Peterson
------------------------------

Sign up

Login to the community