How to set up a layer report for data that contains a join?

Chris Dunlop

21. Februar 2020 00:37

Hello, hopefully a simple question here. I can create a layer report using the template for a layer in a map service that has no joins. It creates the report with some fields from the layer, and if I preview it, it works correctly.

 

However, if I try to do the exact same thing with a layer that contains a join, it fails. If I click the Validate Bindings button, all the labels in the detail section display a red box instead of a black one, and the Expression property in the Properties pane has a red exclamation mark for each label.

 

If I try to preview the report, it fails. The console log displays an error:

 

DevExpress.DataAccess.Sql.QueryExecutionException: Query Address Pts failed to execute. ---> DevExpress.DataAccess.Sql.FilterByColumnOfMissingTableValidationException: There are no tables containing the column [Address Pts.ADDRESS_Pts.OBJECTID] that is used in the filter string.

 

Any ideas what might be going on?

 

Thanks,

 

Chris

0

• 

  Chris Dunlop

  21. Februar 2020 00:42

  BTW the table name IS "Address Pts", and there IS a field "ADDRESS_Pts.OBJECTID"

   

  https://maps.orcity.org/arcgis/rest/services/AddressPts_PUBLIC/MapServer/0

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.