I wrote a rev report to print an invoice-type form. I put the invoice total, payment amt and bal due in the footer. Works fine for one-page, but when it goes to the second page I get all zeros for those amounts. I don't calculate these amounts in the form. I wrote a pre-process that just plugs all the values into a table and then the rev report simply uses the fields from the table. In fact, I can't really calculate them at form-run-time due to complexity of calculations.

How do I keep the footer values from re-setting? The header values remain in tact on the second page. It's as if the program processes the last detail line and immediately re-sets the record.

Hi Dave

I gave up on reporter due to several issues and inconsistencies such as this. A workaround in this case is to create dictionary synonyms for the appropriate fields which are multi-value. Now insert these new fields in your footer, right click on the field and go to MV OPTIONS and change its attributes to "treat as single field" and check remove blank spaces, and they should reappear (tested around OI 3.6 from memory)

NB. you CAN make your fields multi-value directly through right-clicking and changing their attributes - but DO NOT do this as they will disappear when you reopen the report.

That worked. How you figured that one out I'll never guess.

Dave

View this thread on the Works forum...