Grouping by Sections

mark1

Hi, I am trying to use FastReport to print detailed reports for a local inventory company. Is this possible? There is insufficent help documentation on this subject.

This is what I need to do:

Store Side #1:
Shelf #1
Beans 5.00 * 10 = 50.00
Rice 2.40 * 10 = 24.00
Total Shelf #1 $74.00
Shelf #2
Apples .75 * 10 = 7.50
Total Shelf #2 $7.50

---

TOTAL STORE SIDE #1
Apples $7.50
Beans $50.00
Rice $24.00

Store Side #2
Shelf #1
Tortillas 2.75 * 10 = 27.50
Total Shelf #1 $27.50

---

TOTAL STORE SIDE #2
Tortillas $27.50

Total Store: $109.00

Now, of course, my reports are MUCH more detailed than this. Listing every object in a store by shelf and the giving sub totals by side. PLEASE help if you have any suggestions on how to use Fast Report to do this? Thank you in advance!

gordk

the key lies in the orderby clause of the underlying query
then use nested groups supplying the correct grouping condition for each groupheader.
groupheaders and footers do not necessarily have to be visible unless you want them to be.
ie
select * from blah blah
where blah blah
order by
storeid shelfid sideid productid
bands in report
gh1 condition storeid
gh2 condition shelfid
gh3 condition sideid
mdband
gf3
gf2
gf1
when you need unknown quantity of lines of data as a summary in a footer
you can use 1 memo set stretched props of band and memo to true
in appropriate header obp event write code to clear the text of the memo
and in the obp or oap or oad event of the mdband add items to the memos
text.lines property