Conditonal group footer suppression based on number of detail records 1

[cully651]

I've been trying to get conditonal group footer suppression based on number of detail records. Here's what the problem is;

I have invoices in the detail section and they are grouped for each month with a summary for each month in the group footer. For most months there is only one invoice, so the customers don't want to see the summary in the group footer for those months.

I tried doing a count in a variable then evaluating in the group footer, but that didn't work (maybe the variable was declared wrong?)

Please help!

 

[lbass]

Use a suppression formula on the group footer section:

count({table.invoice},{table.date}) <= 1

...where {table.date} is your group field (on change of month)

-LB

 

[cully651]

Thanks lbass, but I've tried that. It highlights the entire function and both fields, then returns the error, "there must be a group by matches this field".

count({INVOICES.COST_BILLED}, {INVOICES.INVOICED_DATE}) >1

I'm using CRXI R2 aka version 11.5.

 

[lbass]

Sorry, the formula should be:

count({INVOICES.COST_BILLED}, {INVOICES.INVOICED_DATE},"Monthly") <= 1

-LB

 

[cully651]

I could swear I tried that too, but now it works! Thank you very much!