Conditional suppression weirdness
Conditional suppression weirdness
(OP)
Hi All,
This one has me stumped. I have a SAP Business one print layout that should work for 2 locations. For the Logo and for the company address, I have conditional suppression formulas that should show logo and address 1 if it is warehouse x and logo and address2 if it is warehouse Y. Here is what I CANNOT figure out for the life of me. Page 1 of the document it works great, page 2 both logos and addresses are showing. There are located in the page header section of my print layout.
Here are my formulas:
Logo and address 1
if {INV1.WhsCode} = '04D1'
OR {INV1.WhsCode} = '04D1S'
OR {INV1.WhsCode} = '05D1'
OR {INV1.WhsCode} = '05D1S'
then true
Logo and address 2
if {INV1.WhsCode} = '01D1'
OR {INV1.WhsCode} = '01D1S'
OR {INV1.WhsCode} = '02D1'
OR {INV1.WhsCode} = '02D1S'
OR {INV1.WhsCode} = '03D1'
OR {INV1.WhsCode}= '03D1S'
then true
Any help would be GREATLY appreciated.
Thank you
This one has me stumped. I have a SAP Business one print layout that should work for 2 locations. For the Logo and for the company address, I have conditional suppression formulas that should show logo and address 1 if it is warehouse x and logo and address2 if it is warehouse Y. Here is what I CANNOT figure out for the life of me. Page 1 of the document it works great, page 2 both logos and addresses are showing. There are located in the page header section of my print layout.
Here are my formulas:
Logo and address 1
if {INV1.WhsCode} = '04D1'
OR {INV1.WhsCode} = '04D1S'
OR {INV1.WhsCode} = '05D1'
OR {INV1.WhsCode} = '05D1S'
then true
Logo and address 2
if {INV1.WhsCode} = '01D1'
OR {INV1.WhsCode} = '01D1S'
OR {INV1.WhsCode} = '02D1'
OR {INV1.WhsCode} = '02D1S'
OR {INV1.WhsCode} = '03D1'
OR {INV1.WhsCode}= '03D1S'
then true
Any help would be GREATLY appreciated.
Thank you
RE: Conditional suppression weirdness
RE: Conditional suppression weirdness
not onlastrecord. This will fix your issue and also prevent a new page at the end of the report.
Just to clarify, the default value if not true is false and it is not necessary to specify. However, if a suppression formula hits a null in the field it is testing (whscode), a checkmark in the suppression box will override the formula in the x+2 formula area (if you have not checked for nulls in the formula), so whether or not you check it depends upon what you want to happen if the whscode field is null. I ordinarily never check the box if I am using a conditional formula, but there might be an occasion when you would want it to work that way.
You could also simplify your formula to:
{Inv1.whscode} in ['01D1','01D1S', etc.]
-LB
RE: Conditional suppression weirdness
Odd I was under the assumption that a formula always overrides the checkbox. At least that is what I observed.
RE: Conditional suppression weirdness
-LB