Nested groups (using same group more than once in same report) or

[WhiteKnight2K]

Hello there. Here's the problem I'm having and I'm not sure if there is a solution for this or not, but here goes anyway:

My report is grouped by Area and within each area I have a Tree Grouping, which identifies all the Tree Groups within a region, and within each Tree Group the details of each Tree is listed. However, after the Tree listing, I would like to have a section that follows that shows the Firewood within each Tree Group as well, but when I try to create another Group, I cannot select Tree Group from the Grouping menu. The thing is, each Tree Group will contain Trees as well as Firewood, but for organization sake, I would like to just list all the Firewood in its own section and group it by Tree Group (in a separate section). Each Tree Group can only have ONE pile of Firewood associated with it, but the same Tree Group can have MANY Trees associated with it. I know this sounds really confusing so below is what the report looks like:

Area 1

Tree Group 1
Tree 1
Tree 2
Tree 3

Tree Group 2
Tree 1
Tree 2
Tree 3

Tree Group 3
Tree 1
Tree 2
Tree 3


Now what I would like is for a separate section for the Firewood to follow:

Tree Group 1 Firewood Amount
Tree Group 2 Firewood Amount
Tree Group 3 Firewood Amount



So far all I can get it to show is that the Firewood AMount is shown after the Trees have been listed within each Tree Group, but I would like the Firewood to be in its own section so that each Tree Group is listed with its corresponding Firewood Amount.

Then the report would follow with Area 2 in the format as Area 1.

Please, if you understand what is going on here or if you know how to remedy the situation, please respond.

Thank you very much,

Christopher

P.S. I think this could be accomplished if one were allowed to have multiple Details sections and the choice to move the placement of the Details within any area, not just in the Details area.

 

[IdoMillet]

Option 1: Insert a subreport with what you want in "Area 2" inside the Report footer.

Option 2 (even simpler): Insert a CrossTab in the Report Footer. Assuming each record has a "Firewood" (TRUE/FALSE) column indicating if it is "Firewood" and an "Amount" column indicating the amount that needs to be totaled if Firewood is TRUE, create a formula
@Firewood_Amount:
-----------------------------------------
IF {Firewood} = TRUE THEN {Amount} ELSE 0
-----------------------------------------
Then, the CrossTab is simply
SUM of @Firewood_Amount BY TreeGroup

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com