Add Field Expressions

Add Field Expressions

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

• 

  yosef.teferi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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
  
  
  

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 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