I've looked everywhere to get some help, but haven't had any luck.
Here's the issue:
I'm trying to get my summary fields to shop up at the end all records, almost as if it were a record itself.
here's what i want it to look like:
johnson $5
smith $7
total $12
but when i set it up in the layout, here's what i get as a result:
johnson $5
total $12
smith $7
total $12
putting it in the footer won't work because these reports end up being 5 pages long.
so what i do is make 2 seperate layouts, one that looks like this:
johnson $5
smith $7
and one that looks like this:
total $12
then, what i do is print out the first report, 5 pages.
after that, i line up my second report(totals) so that it prints directly
below the last record, or in this example smith.
so i have to print the full report, then rig it so the totals will print on the last page.
i believe i came across the solution to this once while working on a layout, but i forgot what it is called.
any help would be much much much appreciated.
thanks!!!
Here's the issue:
I'm trying to get my summary fields to shop up at the end all records, almost as if it were a record itself.
here's what i want it to look like:
johnson $5
smith $7
total $12
but when i set it up in the layout, here's what i get as a result:
johnson $5
total $12
smith $7
total $12
putting it in the footer won't work because these reports end up being 5 pages long.
so what i do is make 2 seperate layouts, one that looks like this:
johnson $5
smith $7
and one that looks like this:
total $12
then, what i do is print out the first report, 5 pages.
after that, i line up my second report(totals) so that it prints directly
below the last record, or in this example smith.
so i have to print the full report, then rig it so the totals will print on the last page.
i believe i came across the solution to this once while working on a layout, but i forgot what it is called.
any help would be much much much appreciated.
thanks!!!