Resolving an issue with displaying data in a PDF report.

[khairu]

Hello Everyone,

I'm a newbie here and need some help.

I’m having an issue with generating a PDF where the input for zone_id is a reference to the zone table (with zone_id as the key and zone_name as the label). The change_requests table includes a zone_id that references the zone table. While the application displays the zone_name, the PDF currently shows the zone_id.

The issue is that I want the PDF to display zone_name instead of zone_id. This data is retrieved after the user inputs the data, and it will be recorded and used to generate the PDF. I’m using <<[zone_id]>> in the PDF template.

Could anyone advise how I can resolve this issue and get the PDF to display zone_name?

Thank you!

[TeeSee1 · Accepted solution]

Just use a dereferencing expression [zone ID].[zone name]

[khairu]

Thank you for your answer. it's correct and really helpful!