Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Posted: 27 Dec 2012 at 9:25am
You are thinking in right way, Group By Plant, next group by Top, Group By Bottom, in same Hierarchy(Group Expert). Place fields accordingly in the Group Headers/ footers to display as you wish.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 28 Dec 2012 at 10:59am
well, you can't group by top and then by bottom...they are just entries, I would think that you would group by a formula. If the entries are just top and bottom, then you could create a formula like:
left({table.field}, 3)
the display for the group would be something like:
if left(table.field},3) = "top" then
"Top"
else
"Bottom"
if the entries are more varied, obviously the formula will get more complex, but you would need to find a way to split entries correctly into different groups.
Yes. I already solved this problem. Now, what I need to do again is add a summary of the report but not adding a subreport. It will be included on the main report. It is like this,
Plant1
Top
Top1 12
Top2 14
Bottom
Bottom1 12
Bottom1 14
Plant2
Top
Top1 34
Top2 18
Bottom
Bottom1 34
Bottom1 18
Total
Top
Top1 46
Top2 32
Bottom
Bottom1 46
Bottom1 32
Showing a total per Top and bottom at the end. Please help.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
