PageFooterBand is working at one record later tthan Masterband

Comments

• PatF

  January 2016 edited 9:45AM

  The field in your PageFooter will always print the value for the current record. FastReport do a DataSet.Next to navigate in all the data when printing your DataBand.
  
  When you only have one record, it stays on the same record after the DataSet.Next so the data in the PageFooter is the same as the data in the header. When printing multiple records, the DataSet.Next navigate to the next row of data, so the data in the PageFooter is not the same as the data in the header.
  
  To solve your problem, I see two options.
  
  1) You can use a different band type, like a GroupFooter. To be able to use a GroupFooter, you need a GroupHeader to define the break condition. If you don't want to see it, put his height to 0. It is possible to force a static position to a band, but it is a bit more complex.
  
  2) You can store the value that you want to show on the PageFooter in a variable on the event of your choosing (ie: BeforePrint of the DataBand).
• Kai Inge Buseth

  January 2016 edited 9:45AM

  PatF wrote: »

  The field in your PageFooter will always print the value for the current record. FastReport do a DataSet.Next to navigate in all the data when printing your DataBand.
  
  When you only have one record, it stays on the same record after the DataSet.Next so the data in the PageFooter is the same as the data in the header. When printing multiple records, the DataSet.Next navigate to the next row of data, so the data in the PageFooter is not the same as the data in the header.
  
  To solve your problem, I see two options.
  
  1) You can use a different band type, like a GroupFooter. To be able to use a GroupFooter, you need a GroupHeader to define the break condition. If you don't want to see it, put his height to 0. It is possible to force a static position to a band, but it is a bit more complex.
  
  2) You can store the value that you want to show on the PageFooter in a variable on the event of your choosing (ie: BeforePrint of the DataBand).

  
  I will try solution 2 and see if I can manage the data that way, but it's seems a bit peculiar that Fast Report do not directly allow to print data from the Masterband whereever needed on a page, without having to use workarounds as this?
  I would believe this is a daily need in reports.
  A single footer databand designed for this, that is not affected by the dataSet.next command seems mandatory to me, so why does it not exist in an advanced tool like Fast Report I don't understand. :-)
  
  Thank you for the solution.
  If I fail to use it, I will be back. :-)
  
  [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Kai Inge[/img]
• PatF

  January 2016 edited 9:45AM

  The GroupFooter is the clean way to do it. It takes less than two minutes to configure and it works as a charm. The reason why I even suggested the option #2 is because you said you wanted to put this information in a page footer.
  
  However, I do agree that it would be more simple if they had a footer band that can print after the details.