Summary Report is acting weird

[ron G]

I am using FM 12 04 Advanced.

 

Here is the report:  It is a sub summary report that breaks on "Current" and on "Late"

 

 

Here is the layout:

 

The weird part is that there are 66 (NOT 73) distinct CURRENT Records.  I know.  I printed the report and counted them.... 66.  Here is another weird thing, I put YELLOW {{RecordNumber}} fields on each record and noticed that it skips values ?  In fact, it skips 7 'records' which means that the reported total for Current 73-7=66 the correct number. 

 

 

Notice it skips # 34.... huh?

 

 

BUT, if this isn't weird enough, the "Late" summary works as expected.

 

I am lost in the dark.  Got any light for me?

 

Thanks

 

Ron

[Wim Decorte]

Not enough information.  Would need to know the context of the report layout and the sort order.  Plus any related data that you are showing on that report layout

[FranciscoMtz]

Maybe the RecordNumber field is auto-enter serial. And just maybe you delete some records when were created.

 

Supposing that you create records, from 1 to 9, but then delete the records 8 and 9, and create a new record, this one will have the number 10, and if you navigate from a record to another, this will be like this:
current record id is 5, the next record is 6, the next is 7, but the next after 7 is 10.

[ron G]

Not enough information.  Would need to know the context of the report layout and the sort order.  Plus any related data that you are showing on that report layout

Yes.  There are two tables:  Members and Dues.  The since I need Members::Status information (Current or Late) plus the Dues detail  pertaining to a particular member record I based the LO on Dues.

 

Here is the Dues Layout configuartion:

 

Here is the script that drives the Layout:

 

Running this script results in {{RecordNumber}} 41 being omitted.  Why?

 

 

I adjusted the script and now the report is off by 1 record.  Presumably the 'ghost' record is causing the count to be too high?