Add Field Expressions

Posted by: yosef.teferi on 26 April 2019, 2:09 am EST

  • Posted 26 April 2019, 2:09 am EST

    It is possible to concatenate field expression like this. I have multiple checboxes with 1 being checked and 0 not checked. I would like to display the result of all checked boxed into one text box. I am trying to do this and not sure if this is possible.


    Desired outcome

  • Replied 28 April 2019, 6:28 pm EST


    You can use the value of CheckBox bound Fields to construct the Expression for TextBox, using the Value property of the CheckBox field. This can be done as follows:

    =IIF(Fields!Married.Value=1,IIF(Fields!Confirmed.Value=1,"Married,Confirmed","Married"),IIF(Fields!Confirmed.Value=1,"Confirmed","Not checked"))

    This has been implemented in the attached report. The database for the same is also attached.
    Hope it helps.

    Best Regards,
  • Marked as Answer

    Replied 28 April 2019, 10:39 pm EST


    The same can be done in Section Reports as in the attached report.
    Here, a calculated field can be used, with the Formula:
    =Married==1?(Confirmed==1?"Married,Confirmed":"Married"):(Confirmed==1?"Confirmed":"Not Checked") 

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels