I have an invoice that I want to have only the first and last dollar amount with a "$" and the other get none, e.g.,
The last one is no problem since I have "TOTAL AMOUNT..." in a footer, so I can specify it explicitly. The 1st "$" is a little trickier. The values for my invoice are read in from a table and sorted by Category. My table has (3) columns, e.g.,
So the 1st value for Subtotal needs the "$," but not the subsequent ones. How can a put a test in my Report that checks if this is the first attempt to write a value for Subtotal and, if so, format it with a "$?"
Thanks!
Rich
Code:
BALANCE
Previous Balance . . . . $1000
Amount Received . . . . 50
Interest . . . . . . 3
FEES
Hourly Fee . . . . . 2000
CONSULTANTS
Structural consultant for framing . 500
TOTAL AMOUNT DUE UPON RECEIPT . . $3453
Code:
Category Description Subtotal
----------- ------------------------- --------
BALANCE Previous Balance 1000
BALANCE Amount Received 50
BALANCE Interest 3
FEES Hourly Fees 2000
CONSULTANTS Structural consultant 500
Thanks!
Rich