Report Refresh Not in Sync

[DaBuzz]

Using FP2.6 with some legacy applications in house.

The report is grouped on Invoice. If I jump to page 11 (as an example), then the group total for Invoice is actually the total for the prior invoice - page 10. If I start at page 1 and go next all the way through the pages are correct - but if I use previous it doesn't always update the totals.

If I print page 11 (again as an example) the invoice total is from the previous page. If I print all pages each page is correct.

The data is correct, the groupings are correct - it appears to be something in regards to the page groupings and/or printing.

Is there a way to force recalculation when the group changes? Shouldn't have to but I need something to be able to print a single page and know it is in sync with the data.

Haven't encountered this before....

 

[JRB-Bldr]

If the Report is being done via a Foxpro Report Form, then I must assume that Invoice totals are being calculated in variables within the Report Form.

If so, the Report variables can be set to re-zero and begin calculating again on specific criteria such as the start of a new Group. This is accomplished within the FP Report Form Designer.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[DaBuzz]

It is really a simple report.
Customer number, Invoice Number, Billed Hours, Bill Rate. The group is customer then another with Invoice. The total by Invoice is Billed Hours * Bill Rate, using the FP report designer on the report expression I have it set to reset per invoice number change and calculate a Sum on these 2 fields. Not using a report variable - but might try that to see if the problem goes away.

I've been using FP2.6 for a long time and have never encountered where I couldn't print off one page of many and not have it be what is in the table for that grouping. Not knowing what is causing this is driving me crazy.

I jumped out to my program and changed it from a field calculation to a variable - resetting after invoice number change and unfortunately it didn't help.

My next two attempts will be to create a new report and see if it happens in that (corrupt report file?) and if that doesn't work rebuild it in VFP. I hate not being able to trust the grouping results.

Thanks for your input - made me think to try a variable as a solution. Any other thoughts??

 

[DaBuzz]

More baffled than ever.

Did a little more testing.

Stripped down the application, recreated report tested in the command window ran fine. Using the Printer Prompt I printed only page 11 and it was correct. I compiled this simplified version - 1 prg that performs a SQL select and prints the report via printer prompt. Compiled running as an EXE when I printed only page 11, the data was not in sync the totals matched the previous invoice total.

Something in the print / preview driver when compiled is creating an error.

Any clues????