Report returns first row of data as blank ?

[rzirpolo]

I have picked up a problem where when my report is run the first row of data returns as blank. I have parameters setup to get data between two dates but the same problems happens each time regardless of what data i.e. dataset I use ??

Even running the stored procedure in SQL returns all the data ? Has anybody come across anything similar before ?

 

[rzirpolo]

OK after some further investigation by myself it seems that one of the formula's used returns as NULL hence blanking the entire row.

To summarise this formula uses the Previous function, with the first row being populated Previous will obviously return as Null. I need to write some better syntax to accomodate for this.

One puzzling thing is that this is part of an if statement so surely it would have been picked up and accomodated for in the Else part. Is this a bug with Crystal ?

N.B. I'm using 8.5 by the way.

 

[vidru]

You can incorporate a check using OnFirstRecord in your formula(s):

If not OnFirstRecord then
//Regular formula text hrer
Else
//What to do if you're on the first record

-dave

 

[rzirpolo]

I effectively did the same as I checked for when RecordNumber = 1. But the 'OnFirstRecord' looks and sounds a lot better so I will make that change.

Thanks for your input.