[Solved] Formatting a Report Sheet and Printing it

[ACCS]

Hello Everyone,
Looking for some help on a report. I was able to format the report sheet somewhat. A number of issues I need answered for those in the know.
1. Field "Total Invoice Amount" What steps must be taken to have the money totals summed at the end of the report?
2. The output for the "Total Invoice Amount" is good for all lines except for one. The line item cost in this instance has two decimal points, and four numbers. Instead of an out put like this 1,774.00 the output
is 1744. Can anyone answer why. When the number outputs are in the hundreds everything comes out fine 768.00, 245.00 etc.
3. The next issue is there is no dollar sign.
4. How do I set the size of paper for the printing of the report (8 1/2 x 11, 8 1/2 x 14 etc.)?
5. How do I get the report to print off my printer?


I know these are quite few questions and there may be a protocol of asking one question at a time. Please let me know about that and I would appreciate any help that can be extended to a fellow who is just starting out working with Open Office 3.4.1 with Windows Vista. Thank you so much!

[Villeroy]

Open the report for editing (right-click>Edit).
It is an ordinary Writer document with a 2-row table. First row is a place holder for the column labels. Second row is a place holder for the data to be filled in.

[ACCS]

I got a good output for the report now. Only two issues, under the date field the output for the date is just a bunch of random numbers. Also, I cant figure out how to sum the column for total sales along with it showing dollar signs for each sale price. Any help will be appreciated.

[Villeroy]

The numbers are not random. These are the correct day numbers. Simply apply some date format to the respective place holder cell in row #2.

[ACCS]

Since I am a novice at this and I have never worked with a report in open office, a step by step direction would make it a lot easier to accomplish this formatting the field. If you could do that, it would really be appreciated. Thanks. So how would you make this random output of "date" numbers look to represent the dates they actually are?