I have a form that uses several check boxes, this works well when using the edit form, but not so well with a report. Is there a simple way to change the 1 or 0 to an X or a check mark?
Craig
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Running a report with Checkboxes
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
Re: Running a report with Checkboxes
I'm sorry, When I run a report, a checkbox gets posted as a 1 or a 0. Is there a simple way to convert this to an X if 1 is present or null if 0 is present?
This is the edit form:

This is the Report output:

It must something that is dealt with all the time I just can't seem to find it.
Thanks
This is the edit form:

This is the Report output:

It must something that is dealt with all the time I just can't seem to find it.
Thanks
Re: Running a report with Checkboxes
saultpastor,
The easiest way would be to use a Dropdown or Listbox (instead of a checkbox) with the following in the SQL field..
Steven
The easiest way would be to use a Dropdown or Listbox (instead of a checkbox) with the following in the SQL field..
Code: Select all
|No|X|Yes
You do not have the required permissions to view the files attached to this post.
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times