16 Mar 10 8:54
I have a QRP form that I print using Centura Report Writer.
At first, it used input variables and input items only to get relevant information and everything seemed to work well.
I had a new requirement to change the output format of the report recently so I added some formulas in place of some of the input variables.
Now the report doesn't work as expected... the formula parts do work, but the input variables that worked before don't work correctly and the page numbering is off.
The form is an Invoice. If we print multiple invoices at once, it should number them correctly, (e.g. each should say Page 1, unless an invoice has multiple pages) Instead, it is assuming that all the invoices take on consecutive numbering.. so the first page has page 1, the second invoice has also page 1, but then the 3rd invoice has page 2, the 4th invoice has page 3, and so on.
The input variable fetch data like contact name and phone number. The form seems to apply one contact and number to all invoices.
Here is the formula I applied:
StrReplace( StrIFF( StrScan( LN_CURR_DISC_UNIT_PRICE , '$0.00' ) , LN_CURR_DISC_UNIT_PRICE, ' ' , LN_CURR_DISC_UNIT_PRICE ), StrScan( LN_CURR_DISC_UNIT_PRICE , '$'), 1, ' ')
It suppresses 0 values and removes $ signs which are part of the database entries.
Please advise of any suggestions as to the cause of my issue.