Hi,
I'm changing layout of my fence report and I want to reference a text field from GINT_ALIGNMENTS table but fence report doesn't show any text after placing it in the report. I also tried to show the AlignID field with same result. Are these fields somewhat special so they can't be referenced?
Thanks for any insight
Jakub Hruška
Hi Jakub,
If you go into the Data Tool>System>DataItems, there is an option for FenceBLAlignment. I believe you should be able to use that in a Lookup() expression to get text from the Alignments table.
Answer Verified By: Jakub Hruška
Hi Jesse,
thanks for your advice. It worked using the FenceBLAlignment data item. I used the lookup expression:
<<Lookup(_ <<GINT_ALIGNMENTS.Name>>,_ <<GINT_ALIGNMENTS.AlignID>> = <<FenceBLAlignment>>_)>>
With regards