I am creating a report that pulls from a table which has a column called "Name". On the report header i would like to show Division Name - Market Name - Manager Name so i have an expression that goes something like..
=[DVSN_NM] & " - " & [MKT_NM] & " - " & [Name]
Everything seems to come out correctly but the [Name] shows the report file name instead of pulling from the table to show the Manager Name. I tired doing [table_name].[Name] and it still doesn't work.
Can anyone help?
Thanks!