<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic ArcGIS Pro Report Expression Not Reading Joined Field Correctly in ArcGIS Pro Questions</title>
    <link>https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-report-expression-not-reading-joined/m-p/1712956#M103876</link>
    <description>&lt;P&gt;Hello, I am creating a report in ArcGIS Pro and using an Arcade expression to group two field values into a single label. The field I am referencing comes from a spatial join.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dnieves_1-1783439435998.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/155023i74CBE0075DB5D0F2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="dnieves_1-1783439435998.png" alt="dnieves_1-1783439435998.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I have also tried other alternatives such as using what if statements.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dnieves_2-1783439581624.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/155024iE1722B37B9F4847A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="dnieves_2-1783439581624.png" alt="dnieves_2-1783439581624.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The expression returns nothing. So how should joined fields be referenced inside report expressions? Do joined fields need a specific syntax in Arcade when used in a report?&lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 07 Jul 2026 15:55:49 GMT</pubDate>
    <dc:creator>dnieves</dc:creator>
    <dc:date>2026-07-07T15:55:49Z</dc:date>
    <item>
      <title>ArcGIS Pro Report Expression Not Reading Joined Field Correctly</title>
      <link>https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-report-expression-not-reading-joined/m-p/1712956#M103876</link>
      <description>&lt;P&gt;Hello, I am creating a report in ArcGIS Pro and using an Arcade expression to group two field values into a single label. The field I am referencing comes from a spatial join.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dnieves_1-1783439435998.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/155023i74CBE0075DB5D0F2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="dnieves_1-1783439435998.png" alt="dnieves_1-1783439435998.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I have also tried other alternatives such as using what if statements.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dnieves_2-1783439581624.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/155024iE1722B37B9F4847A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="dnieves_2-1783439581624.png" alt="dnieves_2-1783439581624.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The expression returns nothing. So how should joined fields be referenced inside report expressions? Do joined fields need a specific syntax in Arcade when used in a report?&lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 07 Jul 2026 15:55:49 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-report-expression-not-reading-joined/m-p/1712956#M103876</guid>
      <dc:creator>dnieves</dc:creator>
      <dc:date>2026-07-07T15:55:49Z</dc:date>
    </item>
    <item>
      <title>Re: ArcGIS Pro Report Expression Not Reading Joined Field Correctly</title>
      <link>https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-report-expression-not-reading-joined/m-p/1713251#M103894</link>
      <description>&lt;P&gt;Joined fields should be referenced in Arcade using&amp;nbsp;bracket notation&amp;nbsp;and the&amp;nbsp;fully qualified&amp;nbsp;table.field&amp;nbsp;name:&lt;BR /&gt;&lt;BR /&gt;var a = $feature["JoinTableName.FieldA"]&lt;BR /&gt;var b = $feature["JoinTableName.FieldB"]&lt;BR /&gt;return a + " / " + b&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;This is the documented syntax for joined fields in Arcade:&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://pro.arcgis.com/en/pro-app/3.6/help/mapping/text/specify-text-for-labels.htm" target="_blank" rel="noopener noreferrer"&gt;$feature['tablename.fieldname']&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(same Arcade field access rules apply).&lt;/P&gt;&lt;P&gt;If your expression returns nothing, the most common causes are:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;You used&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;$feature.JoinTableName.FieldA&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(dot syntax won’t work for joined fields).&lt;/LI&gt;&lt;LI&gt;The join table name in the layer is not what you think (it may be an alias or auto-renamed). Use the exact qualified name shown in the layer’s attribute table fields list.&lt;/LI&gt;&lt;LI&gt;The “joined” values aren’t actually present (no match in the join), so the joined field is null.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Also, if you’re using a&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;EM&gt;temporary/in-memory&lt;/EM&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;join, consider writing the join results to a new dataset (for example, run&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Spatial Join&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;to create an output feature class) so the report is reading physical fields rather than a live join.&lt;/P&gt;</description>
      <pubDate>Wed, 08 Jul 2026 14:34:33 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-report-expression-not-reading-joined/m-p/1713251#M103894</guid>
      <dc:creator>Robert_LeClair</dc:creator>
      <dc:date>2026-07-08T14:34:33Z</dc:date>
    </item>
  </channel>
</rss>

