How do I concatenate description values in report

Permanently deleted user

March 28, 2018 13:49

Hello,  I am using an AGO hosted layer to generate a report.  I would like to concatenate several fields that have coded values.  I can concatenate the field values like this Field1+Field2 and that returns the code value say (A B), I would like to return the description value (A:Historic B:Person).  So I tried Field1.name()+Field2.name().  If I just do one field say Field1.name() it does return the description but not when I try to concatenate them.

 

It returns a Control Script failed for control error. 

 

Any ideas on how to concatenate field values that return the description not the code value?

0

• 

  Aaron Oxley

  June 26, 2018 00:31

  Hi Melissa,

   

  I've tested this behaviour and confirmed that there is a limitation with values from coded value domains being concatenated in Report Designer. I see the same results you are seeing.

   

  To get this working, you could use a transform workflow. Transform workflows are associated with a single report and are created only to make changes to a report's data. Here is an example: https://support.geocortex.com/essentialsGSCCodeGallery?id=kA460000000KzvkCAC.

   

  Alternatively, you may find that you can achieve what you are trying to do in Geocortex Reporting 5: https://www.geocortex.com/products/geocortex-reporting/.

   

  Thanks,

   

  Aaron Oxley

  0

Please sign in to leave a comment.