1 Topic by identity (edited by identity 2016-02-23 16:30:34)

  • Registered: 2016-01-17
  • Posts: 139

Topic: Checkbox in Report Designer

Hi
In my project there are two checkboxes. one is "junior" and the other is "senior" and when one of them is clicked, the other becomes disabled.
in the report designer when I click on one of them, it writes only 1 when it is enabled and 0 when it is disabled
the question is:
is there any way that whichever I click, in the report designer instead of 1 and 0, it writes junior or senior?
I know that using ComboBox is easier but in my project I need to use checkboxes.
can you fix this problem in the attached project?
thanks

Post's attachments

Attachment icon 1.rar 294.89 kb, 406 downloads since 2016-02-23 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Checkbox in Report Designer

Hello,

Check out this SQL query for the report

SELECT person.photo, person.firstname,
person.lastname,
groups.groupname,
phone.number,
(CASE WHEN person.junior=1 THEN 'Junior' WHEN person.senior=1 THEN 'Senior' END) as junior,

person.id FROM person
LEFT OUTER JOIN phone ON person.id=phone.id_person
LEFT OUTER JOIN groups ON person.id_groups=groups.id
Dmitry.