Counts in Reports

[joshw]

I have a report that is based on a form with a subform within it. The main form contains general info (name, address, etc.), while the nested subform contains line item expense details. I want the report to count the number of primary records, not the number of detail line items (e.g. one main record may have 10 or 20 line item details). I have tried every kind of "count" expression, and it always counts the detail records, instead of the main records. HELP!!!!

joshw in Texas

 

[NShafranski]

Have you tried counting the primary key field in the report header?

 

[joshw]

Counts In Reports

Yes I did, and that didn't want to work either. Actually, I finally came across a "quick and dirty" way to do it by setting a text field in the record to =1, then to place a running sum text field on the record footer that referred back that field. I could then reference the running sum field in my location footer and PRESTO!, I have a count of primary records. Yes, it's a very, very sloppy way to get around it, but hey - it works!

 

[NShafranski]

That's what I was going to suggest. Good work man