Group summary

blackflag

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

gordk

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.

blackflag

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