I ‘m having a issue with line count on one of my reports.
I need a count of unique records over each group, then a total for the Report Footer.
Or a way to count unique records for the whole report
This is what I working with now.

Report has 2 Groups with totals
ReportHeader – Report Title
PageHeader - Column Titles

CarrierHeader1 – [txtField1] - [txtField2]

ShpNoHeader2
Unbound - [txtBillCount] – Control Source =1 – Running Sum = OverGroup
[txtBillCount] does line count correctly

Deatil – No Fields
ShpNoFooter1 – No Fields

CarrierFooter2
Unbound- [txtBillGrpCount ]– Control Source =[txtBillCount] – Running Sum = No
[txtBillGrpCount ] does line count correctly

PagerFooter – Date & Page

Report Footer
Unbound- [txtBillCountTotal] – Control Source =[txtBillGrpCount ] – Running Sum = No
This one doesn’t work

I’m using the line count in some calc fields
[txtGrpCount Formula] Control Source =Sum([Pcs])*0.05+[txtBillGrpCount]*197
[txtGrpTotalFormula] Control Source =Sum([Pcs])*0.05+[txtBillCountTotal]*197
I’ve played with changing the Running Sum in both controls without success.



Recap – Line count works for ShpNoHeader and CarrierFooter but not ReportFooter
Any and all suggestion will be appreciated.

Gil Chichester