Exclude group footer on groups of only one line

[shanef1981]

Hi Folks,

I am trying to solve a little problem I have.

Having recently re-designed our customer statements, and am now being asked to group all transactions on each invoice together, for example, the original billing, any payments and/or credits, journal vouchers etc.

I have done this and each invoice now has a section footer to summarise what is outstanding, but I only want it to do this for all sections with more than one line, as what I now have are a lot of invoices raised with no further transactions, and a summary after each line, which has lengthened them somewhat.

Hope I'm making myself clear... has anyone ever had to solve this?

 

[shanef1981]

I managed to sort it myself

For anyone else that wants to know:

I created a hidden field on the group footer that is a count of one field in the detail, then coded an On Format event for the group footer to Cancel if the count = 1, like so:

If InvNoCount > 1 Then cancelfooter = 0
If InvNoCount = 1 Then cancelfooter = 1
Cancel = cancelfooter