Report with XLS attachment & ref column value

[Jennie_Lewis]

Hi -

I have two tables:
Observations = list of potential values to use for tracking
Observation Tracking = daily tracking, includes Observations as a ref column for use in a form drop down menu

I’m building a report with an XLS attachment. When the report runs, the values returned are the ID from the original table, not the friendly name of the value.

The start expression is the standard value generated when I created the XLS template.

<<Start: Filter(Observation Tracking, true)>><<[Observation]>>

Is there another start expression I could use to pull in the name of the value instead of the ID?

Thanks!

[Suvrutt_Gurjar · Accepted solution]

I believe you could try something like below

<<Start: Filter(Observation Tracking, true)>><<[Observation].[Label Column of Observation Table]>>

[Jennie_Lewis]

This works - thank you!