Invoice type report problem

Comments

• gordk St.Catherines On. Canada.

  September 2010 edited 10:21AM

  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

  September 2010 edited 10:21AM

  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 St.Catherines On. Canada.

  September 2010 edited 10:21AM

  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

  September 2010 edited 10:21AM

  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 St.Catherines On. Canada.

  September 2010 edited 10:21AM

  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

  January 2011 edited 10:21AM

  Thank you very much gordk; it really works very fine.
  
  Greeting from old Germany
  Bernd
• Gazzali Coimbatore,TN,India

  May 2013 edited 10:21AM

  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