Adding a table as dynamic text using an expression

Inserting Table dynamic text allows you to display the attributes from a table within your map or source database. After selecting the table you want to use, you can specify a specific attribute field to display using filtering and query options. You can query and use table values from any table you can access in ArcMap.

You can display an attribute field by using a SQL query to choose field values, or you can use the Expression Parser dialog box to create a script that returns the attribute or attribute field value you want displayed.

Steps:

1. Start ArcMap.
2. On the main menu, click Customize > Toolbars > MPS Atlas.
3. Click the Add Dynamic Text button on the MPS Atlas toolbar.

   A crosshair with a letter A appears.

4. Click anywhere in the map sheet layout.

   A piece of dynamic text is inserted on the page.

5. Double-click the dynamic text.

   The Dynamic Text Properties dialog box appears.

6. Click the Dynamic Text tab if necessary.
7. Click the Dynamic Text drop-down arrow and choose Table.
8. Click Insert.

   The table text appears in the text box.

9. Click the dynamic text element in the text box.

   The Table Dynamic Text Properties dialog box appears.
10. Click the Browse button to navigate to the table you want to use.
11. Click Select.

    The path to the table appears in the Table text box. A field name appears in the Field drop-down list.

12. Click Query Builder if you want to specify attribute field values to display.

    The Select Features Using a Query dialog box appears.

13. Create a SQL expression to display the attribute field values you want displayed.

    Learn more about creating a SQL expression

14. Click OK when you are finished creating the SQL query expression.

    The Table Dynamic Text Properties dialog box appears.

15. Click the Expression option.
16. Click Edit Script.

    The Expression Parser dialog box appears.
17. In the Expression area, click to right of the Generate = expression.
18. Double click a field name in the Parameter list.

    In the Expression area, the field name appears to the right of Generate =: Generate = [NAME].

    Tip:

    Double click a field name without an _arr suffix.

19. Click Verify.

    The Output area lists Function evaluated successfully.

20. Click OK to close the Expression Parser dialog box.
21. Click OK to close the Table Dynamic Text Properties dialog box.
22. Click OK to close the Dynamic Text Properties dialog box.

    The table dynamic text displays in the page layout.

Note:

If you change the layer or data frame, the expression will be cleared. A new layer will require a new set of function parameters.