I have a couple different reports that are randomly missing "sum" totals.
Here is an example.. the report is built using a cursor "code" defined prior to the report being
called. Under data grouping, I have the "breaking" field entered as: cursloglist.codetype with
no check marks in the boxes below. On the report, I have a group footer and header: codetype
The header is blank, just a spacer basically. The footer has some static text labels as well as a
few fields as follows:
- The first field has an expression of: cursloglist.codetype. The calculations for this field is set
to COUNT with a reset on cursloglist.codetype. (This is intended to print how many records were
printed above the group footer)
- Following is a label that states: ENTRIES TOTAL FOR:
- Following is a field with an expression of: cursloglist.codetype. (This is intended to list the codetype
for this group for reference purposes: Example: Billing, Adjustment, Time, etc)
- Following a a field with an expression of: cursloglist.amt. The calculations for this field is set
to SUM with a reset on cursloglist.codetype. The format is set for: $$$,$$9.99, NUMERIC is marked,
and no checks in the bottom half of the format settings. (This is to sum the afore listed records AMT column)
An example of the error: When we ran the report earlier today, it printed fine. We noted a missing
entry and went and added it. When we reran the report... everything printed including the new entry
record - except - the group footer read: 39 ENTRIES TOTAL FOR: Billing and nothing else - the
remainder of the line was blank. When I was just rechecking this problem - reviewing it with the
operator... we ran the report again - this time the group footer was complete including the SUM
total. Nothing was added or changed to the data/program/report between these last two initiations
of the report itself.
Any suggestions as to why this is turning into a hit or miss?
Thanks
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!