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

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

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

Comments

Didn't find what you were looking for?