Select extra info from another table in pdf file

ihayek86
Participant I

Hi
I am trying to get the address of the shipping place from the table shipping while i am exporting order report but I am not able to, do i have error in my syntax? need help

SHIP TO:
<<[ShippingTo]>> (returns value because it is getting value from the order table)
<<Start: LOOKUP( [_Thisrow].[ShippingTo] , โ€Shippingโ€, โ€œShippingToโ€ , โ€œAddressโ€ )>><> (returns nothing)

Solved Solved
1 2 321
1 ACCEPTED SOLUTION

MultiTech
Participant V

I would suggest investigating references, theyโ€™ll allow you to connect tables together and pull data easily from one to the next.

So the [Shipping To] would be a reference to the Shipping table, then you could dereference the Adress super easy:

[Shipping_To].[Shipping_Address]

View solution in original post

2 REPLIES 2

MultiTech
Participant V

I would suggest investigating references, theyโ€™ll allow you to connect tables together and pull data easily from one to the next.

So the [Shipping To] would be a reference to the Shipping table, then you could dereference the Adress super easy:

[Shipping_To].[Shipping_Address]

Thanks it works now

Top Labels in this Space