Page 1 of 1
Including Expression from another Section
Posted: 05 Oct 2015, 12:14
by dgmers
We are trying to include an expression in a qr code that exists within another section - it doesn't seem to work. My qr code is as follows:
SALES_ORDER.DEL_NAME+SALES_ORDER.DEL_ADDRESS_1+SALES_ORDER.DEL_ADDRESS_2+SALES_ORDER.DEL_ADDRESS_3+SALES_ORDER.DEL_ADDRESS_4+SALES_ORDER.DEL_ADDRESS_5+SALES_ORDER.ORDER_NUMBER+Expr20
The Expr20 doesn't work. I assume because it is in another section (Details).
Can you help?
Re: Including Expression from another Section
Posted: 05 Oct 2015, 19:55
by brucedenney
What is the expression?
Could you attach the layout, report to a post
Re: Including Expression from another Section
Posted: 06 Oct 2015, 14:26
by dgmers
Hi, thanks I have attached. As discussed I am trying to get the expr20 to be included in the qr code (top left).
Re: Including Expression from another Section
Posted: 07 Oct 2015, 14:59
by brucedenney
At the point where the header is printed all the items have not yet been printed so the value of Expr 20 will not be known.
The issue is the Expression 20 is either 1 or 2 depending on the item.
The Order could have more than one item, so it could have some lines that have 1 on and some that have 2 so what value you want in the qr code it indeterminate.
You could do max or min of that expression and use that, but then these still happen after the QR code is printed, you can either move the QR code to the footer after the lines are printed and the expression can be determined or you may be able to use use the aggregation feature to do it.
Re: Including Expression from another Section
Posted: 07 Oct 2015, 17:09
by dgmers
Thank you I will give it a go.