Hi,
I am trying to insert a line in my sub-footer that says "25 records for this person" when I have 2 lines for each record in the section.

I can use data aggregation in the form of CNT.DST.RECORDS and get a sum per section, but is it possible to hide that field and put the count of distinct records in the sub footer instead?
I tried using

 <CNT.DST.RECORDS 

in the sub footer but it will not recognize in the footer.

In short: Is there a way to count distinct items in the sub-footer?

This message has been edited. Last edited by: TRue,

I'm seeing the same behaviour.

 <CNT.Records 

works in the Subfooter, but

<CNT.DST.Records

throws a FOCEXEC error.

My work around was to create a compute field called DSTCount for CNT.DST.Records, and reference that in the subfooter. So

  <DSTCount

seems to work in the Subfooter. You can then hide DSTCount from your main table.

Ah Compute! Of course I hadn't tried that!
It worked, just had to get past the fog of trying the same thing too many times since I couldn't figure out what would make the define work before asking the question.

Clarification, for anyone reading this later...
-When you create the compute field named DSTCount the formula is CNT.DST.RECORDS (replace RECORDS with whatever your field name is)
-In the sub footer I use the subtotal function as well:

 <ST.DSTCount 

...so that I get the subtotal of the computed DSTCount field for the section, not just the value[s) returned in the body of the report.

Thanks TMoorthy!

This message has been edited. Last edited by: TRue,

No problem! Glad it worked.