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.

    =((AERONAUTICS=1)?"AERONAUTICS":"") & ','& ((BESTVALUE =1)?"BESTVALUE":"")


    Desired outcome
    AERONAUTICS , BESTVALUE

  • Replied 28 April 2019, 6:28 pm EST

    Hi,

    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,
    Esha
    FieldsExpression.zip
  • Marked as Answer

    Replied 28 April 2019, 10:39 pm EST

    Hi,

    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") 

    Regards.
    CheckBoxSelection(SectionReport).zip
Need extra support?

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

Learn More

Forum Channels