Group summary

blackflagblackflag
edited 6:24PM in FastReport 4.0
I'm new to fastreport just converting some old reports from freereport.
Is is possible to get something like a group summary band?
I have a report that shows grouped products and services from two tables with sums. For example like this

ProductGroup1Name (GroupHeader)
Product1 Price (MasterData)
Product2 Price
ProductGroup1Sum (GroupFooter)

ProductGroup2Name (GroupHeader)
Product3 Price (MasterData)
Product4 Price
ProductGroup2Sum (GroupFooter)

TotalProductSum (need GroupSummary)


ServiceGroup1Name (GroupHeader)
Service1 Price (MasterData)
Service2 Price
ServiceGroup1Sum (GroupFooter)
ServiceGroup2Name (GroupHeader)
Service3 Price (MasterData)
Service4 Price
ServiceGroup2Sum (GroupFooter)

TotalServiceSum (need GroupSummary)

TotalSum (ReportSummary)


In FreeReport this is solved with a composite report with a report for products and a report for services each having a ReportSummary and a report for the TotalSum. Since FastReport 4 has no CompositeReport and the workaround from the manual is not usable because reports are stored in DFM, how can I solve this problem?

Thanks for any suggestions
Michael

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 6:24PM
    in your first case just setting group condition should work use a query with an orderby clause to supply the data.
    looks about the same for the second case.
    for overall you could change from storing reports in dfm, which by the way causes exe bloat).
    or run a 2 design page report.
    many combos are possible, a lot has changed since free report so i suggest you run the main demo
    look at the reports and the datamodule to see how they were constructed and connected.
    Particularly, under basic reports, the nested groups report.
    Primarily read the programmer's manual as working from delphi and the users manual as working from with in the report.
  • blackflagblackflag
    edited 6:24PM
    gordk wrote: »
    in your first case just setting group condition should work use a query with an orderby clause to supply the data.
    looks about the same for the second case.
    for overall you could change from storing reports in dfm, which by the way causes exe bloat).
    or run a 2 design page report.
    many combos are possible, a lot has changed since free report so i suggest you run the main demo
    look at the reports and the datamodule to see how they were constructed and connected.
    Particularly, under basic reports, the nested groups report.
    Primarily read the programmer's manual as working from delphi and the users manual as working from with in the report.
    Thanks, the hint with a multiple page report works for me. Never used it in FreeReport.

    Michael

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.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024