Hi I have a question on Basic Syntax supression formula. Currently on Crystal XI with SQL 2005. The formula is
Global iCount as number
WhilePrintingRecords
If {mainprocedure;1.entry1} = 100 then
iCount = iCount + 1
Formula = False
ELSE
Formula = True
End if
This formula is supressing duplicates by giving a count (or so I think).
What I want to do in this supression section is
IF table.value = "value1" then true else if table.other = "value2" then true else false.
How can I add this to the current basic syntax.
Global iCount as number
WhilePrintingRecords
If {mainprocedure;1.entry1} = 100 then
iCount = iCount + 1
Formula = False
ELSE
Formula = True
End if
This formula is supressing duplicates by giving a count (or so I think).
What I want to do in this supression section is
IF table.value = "value1" then true else if table.other = "value2" then true else false.
How can I add this to the current basic syntax.