Skip to main content

Concatenate in Subreport

Permanently deleted user

I can't seem to get concatenation of multiple fields to work in Subreport.  Does anyone know how to make it work?

0

Comments

4 comments

Date Votes
  • Permanently deleted user

    You would need to create a calculated field and you can use this syntax to concatenate two fields or more [Field] + [Field2] you would then add the calculated field name to the data field property of where you are trying to display the data.

     

     

    0
  • Permanently deleted user

    I created a calculated field and put  in the following: =MA Hous Number + " " + MA Fraction + " " + MA Street Name + " " + MA Unit 

    I referenced the field in the datafield section of my subreport but the report gives this error "Control Script failed for control TextBox1"

    I've tried it with and without the equal sign  and I've put brackets around the individual fields.  This seems like it should work but I can't figure out why it isn't working. 

    0
  • Permanently deleted user
    I dont belive an equal sign is needed and are you using alias names. I don't believe the report will pick up alias name you would need to use the acutal column names. The brackets are not supposed to be used. I inlcuded a link to the active reports syntax. I think your issue may be your column names they should not have any spacing. http://www.datadynamics.com/help/ARNET3/ar3tskAddingFieldExpressions.html
    0
  • Permanently deleted user

    Thanks Nick. I think it really has to do with the subreport or the datalink.  I've concatenated fields in a report and it works fine and I've constructed the datafield according to the links you included.  It just doesn't work in the subreport.  

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post