How to print Master/Detail with totals for Master

rbuser

Hi there,

I'm sure there must be an easy way to do this but I can't just see what it
is!

Simply I want to print a Master/Detail report for Customer Account
Statements. Each statement to be rpinted on a separate page and where the
Total Due for each customer is printed at the bottom of the page and not
directly after the end of the detail lines.

Currently I have this report set up using your Master/Detail tutorial
example ....

Main Report PileLine - Customer File
Header ---
Customer details

Detail ---
Sales Ledger Transactions Sub-Report


The Sub report is then layed out so ...

SubReport Pipeline - Sales Transactions File
Group Header ---
Column headings for Sales Ledger Transactions

Detail ---
Sales Ledger Transaction line

Group Footer ---
Total Due + Ageing Totals.

This works fine except that the Total Due + Ageing Totals is printed
immediately after the transaction lines. I want them to print at the bottom
of the page (and only the final page if the transactions run over more than
one page).

Really I am trying to emulate a Statement that would be printed on
'pre-printed' stationery.

I'm sure that there must be a simple answer to this but all of the
alternatives I have tried have not worked and a trawl through this newsgroup
has not turned up a solution

Any help would be most appreciated.

Many thanks,
Ian

nicocizik

Hi Ian,

You can adjust the TppGroupFooterBand.PrintPosition property to define where
on a page you would like that band to print. This value should be assigned
in report units. For instance if you are using 9.5x11 paper and you have a
1 inch group footer, setting the PrintPosition to 9.5 would place it at the
bottom of the page.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com