Quote:
Originally Posted by hadenp
I can list the values, but how do I format them to look 'good' on the page? For me, that means right justifying the $ amounts under the "Amount" heading. Is that best done with tabs? How do I specify that within the field code syntax that I'm using to generate the list?
|
A single right-aligned tab-stop in the field code and a corresponding tab character between the relevant fields will suffice.
Quote:
Also, how to underline the heading text? The output would ideally look something like this - only better.
Date………......Amount
Feb/01/2013 $225.00
Mar/01/2013 $10.00
Apr/01/2013 $50.00
------------------------------
Total $285.00
|
Just as the tutorial demonstrates headings with bold text, you can apply an underline format at the same point.
Quote:
|
Finally, I'd like to have Total line at the bottom with a sum of the amounts. Is that best calculated as a formula the Excel spreadsheet? How would I underline the last amount
|
For the total line, the tutorial provides two options, described in the tutorial's 'Using an Extra Field to Generate the Trailing Content Per Group' or 'Calculating Group and Sub-Group Totals' examples, respectively. Note that using an underline for the last record with either of these will necessitate a suitably-formatted line to be inserted just above the code that actually outputs the total, not in the other data lines.