*Resolved* Crystal report forumlas
I am so close to my reporting needs...but....
I am now having trouble with suppression forumla.
I would like to examine a field in the database attached to Crystal Reports and suppress a report section if the field equates to a certain value. I have no trouble with this using ...
if not({myreports.subject} = "Art") then true
(the suppress box is ticked)
I would like to extend this to multiple values but I cannot get it to work.
I have tried....
1)
if not({myreports.subject} = "Art") then true else
if not({myreports.subject} = "DT") then true
2)
if not({myreports.subject} = "Art") or
not({myreports.subject} = "DT") then true
and various other types of if, else, or loops.
None seem to work.
Any ideas would be appreciated.
I am so close to my reporting needs...but....
I am now having trouble with suppression forumla.
I would like to examine a field in the database attached to Crystal Reports and suppress a report section if the field equates to a certain value. I have no trouble with this using ...
if not({myreports.subject} = "Art") then true
(the suppress box is ticked)
I would like to extend this to multiple values but I cannot get it to work.
I have tried....
1)
if not({myreports.subject} = "Art") then true else
if not({myreports.subject} = "DT") then true
2)
if not({myreports.subject} = "Art") or
not({myreports.subject} = "DT") then true
and various other types of if, else, or loops.
None seem to work.
Any ideas would be appreciated.
Last edited: