Invoice type report problem

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

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 3:26AM
    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.)
  • edited 3:26AM
    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.....
  • gordkgordk St.Catherines On. Canada.
    edited 3:26AM
    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.
  • edited 3:26AM
    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?
  • gordkgordk St.Catherines On. Canada.
    edited 3:26AM
    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;
  • edited 3:26AM
    Thank you very much gordk; it really works very fine.

    Greeting from old Germany
    Bernd
  • GazzaliGazzali Coimbatore,TN,India
    edited 3:26AM
    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.