Next Function

[mmemon]

Hello All
I have a formula that looks like this
{@Name} = next({@Name}) and {@MessageValueIf} = next({@MessageValueIf}) and {@FieldValues} = next({@FieldValues})

Now In the details section I supress this formula. Basically what it does is elimiated duplicate rows. If the next row is equal to the current row, then only 1 row will show.

It works fine however, the last record on the report doesn't display the row even if it is not a duplicate.

I have tried many things and nothing is working. Any suggestions?

 

[goranm]

Hi !

I don´t know how your formula works, but have you tried to use the OnLastRecord function ?

if not OnLastRecord then
{@Name} = next({@Name}) and {@MessageValueIf} = next({@MessageValueIf}) and {@FieldValues} = next({@FieldValues})

Maybe it will help you.

/Goran

 

[mmemon]

Goran

That worked! Thank You so much!! Your a lifesaver.