Hi
I have added a sub report into our PO document with T&C's.
I only want the report footer to show if a certain PO type is active for that PO type.
We have Type 1 , 2 and 4.
I don't want the Report footer to show if it is 4.
In the report footer section expert I have the Supress (Nor drill down) ticked and this formula in there
IF {PurchaseOrderHeader.OrderType} = 4 THEN False ELSE TRUE
I also have ticked under the tab Paging tab New Page Before, so it is on its own page at the end of the report.
For some reason it is not working and does not show anything no matter what PO number I put in.
Any ideas how I can fix the issue please.
Thanks
I have added a sub report into our PO document with T&C's.
I only want the report footer to show if a certain PO type is active for that PO type.
We have Type 1 , 2 and 4.
I don't want the Report footer to show if it is 4.
In the report footer section expert I have the Supress (Nor drill down) ticked and this formula in there
IF {PurchaseOrderHeader.OrderType} = 4 THEN False ELSE TRUE
I also have ticked under the tab Paging tab New Page Before, so it is on its own page at the end of the report.
For some reason it is not working and does not show anything no matter what PO number I put in.
Any ideas how I can fix the issue please.
Thanks