Last record of the group

[Cores]

CRXI, SQL Server 2005

I need to suppress a details' last record of the group.

How to make it? Please give me ideas what formula can be used for it?

Thanks very much.

 

[lbass]

Use a formula like this in the suppression formula area for details in the section expert:

onlastrecord or
{table.groupfield} <> next({table.groupfield})

-LB

 

[Cores]

thank you very much LB for your help.

I have put the followng formula and it works.

onlastrecord or {Payment_Request_vw.BATCH_NUMBER} <> next({Payment_Request_vw.BATCH_NUMBER})

But I have a small issue - Some records have NULL values in BATCH_NUMBER field (this is a groupfield) and in this case I have duplicate records appear with NULL values - one record from details section (since it is not suppressed) and another one from group footer.

How to suppress the records in details sections that have NULL values in the group field?

Thank you once again

 

[lbass]

isnull({Payment_Request_vw.BATCH_NUMBER}) or
onlastrecord or
{Payment_Request_vw.BATCH_NUMBER} <> next({Payment_Request_vw.BATCH_NUMBER})

This would suppress ALL detail records where the batchnumber is null.

-LB

 

[Cores]

Thanks very much LB for your time - appreciate it.