Help with Crystal 8 Report (1 Viewer)

[raycomp]

Greetings from Sunny South Africa. I am new to Chrystal Reports and need some help with the following.

Using VB6, Access Database and Crystal Reports 8


I have a field on the report that must print only if a condition is met in another formula field.

Field @outerpack with following Formula:

if {ControlHeada.Package} = "OuterPack" then
if {ControlDetailsA.caseno} = "" then
""
else
"All packed in one " & {ControlDetailsA.ctnType}
else
if {ControlHeada.Package} = "LtdQty" then
if {ControlDetailsA.caseno} = "" then
""
else
"All packed in one " & {ControlDetailsA.ctnType}
else
if {ControlHeada.Package} = "OverPack" then
if {ControlDetailsA.caseno} = "" then
""
else
"Overpack used #" & {controldetailsA.caseno}

what I need now is that ONLY when the last condition is met (in blue above then

field Qvalue should print on the report

Hope this makes sense

 

[kevlray]

You could put the field on the report. Put a formula in the 'Suppress' like the formula above, replacing the strings in the 'then's and 'else's with true except with the last else, which would be false.

if {ControlHeada.Package} = "OuterPack" then
if {ControlDetailsA.caseno} = "" then
True
else
True
else
if {ControlHeada.Package} = "LtdQty" then
if {ControlDetailsA.caseno} = "" then
True
else
True
else
if {ControlHeada.Package} = "OverPack" then
if {ControlDetailsA.caseno} = "" then
True
else
False