Report Truble

[Jujuy_Adventure]

Hello community, how are you? Today I come to ask for your help because I am trying to generate an automatic report and I cannot find where my error is.

As I told you, I am trying to generate an automatic report (PDF and email body) every time a new row is added to this table.
My problem arises when I try to embed a REF field from another table in this report. First I tried to directly insert the Ref field (using <<[REF]>>), which logically returns the correct value, but this field is the ID and I need the label.  For this reason try to use the LOOKUP() expression, so that in relation to said ID it returns its corresponding label (using <<LOOKUP([REF],”REF TABLE”,”ID”,”LABEL”)>> and <<LOOKUP("REF",”REF TABLE”,”ID”,”LABEL”)>>).
Unfortunately the result of this when the report is generated is blank.

Does anyone know what I'm doing wrong?
Thanks!

[graham_howe · Accepted solution]

Have you tried the following:

<<[REF].[Label]>>

[Jujuy_Adventure]

It woks !
Thanks!!!!!