Invoice type report problem

Alsofocus

Hello,

i've build a invoice type report. it has master section with the header of the invoice data, detail section with the lines of the invoice and a page footer section with the sums and some other data as comment and old, new remainder which are on the master dataset. When i'm trying to print multiple invoices, create report with many pages every one of which represents a single invoice, the footer doesn't synchonise with the data. i could use variables but there are about 15 fields.
is there a way to print something like master, detail, master on every page (header of invoice, details of invoice, footer of invoice)

Thanks in advance
Yiannis

gordk

generally invoice type reports use
page header band (contains info of vendor and purchaser) or use
master header (reprint on newpage true)
master data (order data)
detailheader (reprint on newpage true)
detaildata (items)
detailfooter
masterfooter (order aggregate sums)
page footer (used for page number etc.)

Alsofocus

Thanks for your reply,

but let me be more specific. I have an invoice which as u say has
1) Master data - Invoice data (date, Number, Trader (Customer Or Supplier) .....)
2) Detail data - Invoice Line Details (Item, Quantity, Price, Net .......)
3) Page Footer - Invoice Summary - Sums and (here is the problem) other data as master comments, old - new remainder etc which are in master
data

when the page is generated the footer part contains the data of the next record. i've tried both fields and variables. is there a way the footer part to
get data from master table;

Thanks in advance.....

gordk

yes use the correct band for summary data not the page footer, use masterfooter
you will also want to set the startnewpage prop of the master databand.
if you want the masterfooter to go to the bottom of the page write code in its obp event to force it down.

Bridget

I ran into the same issues, trying to use a pagefooter for the summary of an invoice. Based on the response in this thread, I changed it to a Footer.

Gordk, you said:
"if you want the masterfooter to go to the bottom of the page write code in its obp event to force it down."

What code would i write to move it to the bottom of the page?

gordk

Bridget here is a sample for a summary band just sub your footer in place of it.

procedure ReportSummary1OnBeforePrint(Sender: TfrxComponent);
begin
if engine.freespace > reportsummary1.height then
begin
Engine.CurY := Engine.PageHeight -reportsummary1.height -pagefooter1.Height - 1;

end;
end;

OR IF STRETCHING DO IT HERE

procedure ReportSummary1OnAfterCalcHeight(Sender: TfrxComponent);

begin
Engine.CurY := Engine.PageHeight -reportsummary1.height -pagefooter1.Height - 1;
end;

King-Soft

Thank you very much gordk; it really works very fine.

Greeting from old Germany
Bernd

Gazzali

gordk wrote: »

Bridget here is a sample for a summary band just sub your footer in place of it.

procedure ReportSummary1OnBeforePrint(Sender: TfrxComponent);
begin
if engine.freespace > reportsummary1.height then
begin
Engine.CurY := Engine.PageHeight -reportsummary1.height -pagefooter1.Height - 1;

end;
end;

OR IF STRETCHING DO IT HERE

procedure ReportSummary1OnAfterCalcHeight(Sender: TfrxComponent);

begin
Engine.CurY := Engine.PageHeight -reportsummary1.height -pagefooter1.Height - 1;
end;

hi gordk,
is this pascal script..... it is showing " ; expected" what is the problem. please help me