Group Footer doesn't work when only one group

Hi,

In delphi 10.4 with fastreport VCL (i try to migrate from crystal report)

I use a dataset whith a join beetween two tables (invoice header and invoice lines) with a query that extract only one invoice but several lines

I set up group header on invoice number (wich is on every lines)

Master data print correctly the lines (qty , unit price, amount)

Group header print correctly (customer, invoice date invoice number etc ...)

Group footer doesn't print anything (invoice due date, bank anccount , paiement conditions etc ...)

Is it because there is no change of the grouping value ? How can i print it anyway ?

Thanks

Comments

  • gpigpi Volnovakha, Ukraine

    Group footer needs dataset which allow Prior method. Do you use such dataset? Some datasets are unidirectional (like DBX) and Prior will not works

  • Correct !

    I use TsqlDataset with dbexpress MS Sql server Driver

    Switching to a clientDataset component solves the problem

    Many Thanks

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.