I am using Crystal Reports 11.5 and Crystal Reports
syntax. I am reading from a SQL DB
Here are the SQL Field types.
{AckParagraphs.AckParagraphBlurb} is a VarChar(Max)
{AckParagraphs.AckParagraphNum} is a nchar(5)
ParaNum is a Global NumberVar set to 999 in the group header.
The purpose of this formula is to print each detail line
until a blank field is reached. When the
record with the blank field is read I want the variable set to the paragraph
number. This variable will be used in
other formulas when printing records.
This formula is throwing and error on the 2nd 'If' "A
number is required here.
If isNull({AckParagraphs.AckParagraphBlurb}) THEN
ParaNum :=
ToNumber({AckParagraphs.AckParagraphNum})
Else If ParaNum = 999 THEN
{AckParagraphs.AckParagraphBlurb}
I'm at a total loss.
IP Logged
