December 4, 2006 at 8:32 am
I have a need to embed two tables within a list, all of which share the same datasource, for a report…or at least that’s my thinking. The purpose for it is to iterate through each drawing within an area within a department displaying info for each drawing; at the end of each area, I need to display totals for that area. As it is, I’m able to display data similar to below:
Architectural Department
Area A1
DwgCode DwgScale HoursPerDwg CADD Comp
0001 1/4” 7.0 10 0
0002 1/4” 7.5 0 12
0005 1/16” 7.0 13 0
Area A2
DwgCode DwgScale HoursPerDwg CADD Comp
0003 1/4” 7.0 0 10
0004 1/4” 7.5 0 12
0007 1/16” 7.0 13 0
That part is easy, but what I need is to display the data similar to below:
Architectural Department
Area A1
DwgCode DwgScale HoursPerDwg CADD Comp
0001 1/4" 7.0 10 0
0002 1/4” 7.5 0 12
0005 1/16” 7.0 13 0
Total CADD: 23
Total Comp: 12
Area A2
DwgCode DwgScale HoursPerDwg CADD Comp
0003 1/4” 7.0 0 10
0004 1/4” 7.5 0 12
0007 1/16” 7.0 13 0
Total CADD: 13
Total Comp: 22
Instead, what I get is similar to below:
Architectural Department
Area A1
DwgCode DwgScale HoursPerDwg CADD Comp
0001 1/4" 7.0 10 0
Total CADD: 23
Total Comp: 12
0002 1/4” 7.5 0 12
Total CADD: 23
Total Comp: 12
0005 1/16” 7.0 13 0
Total CADD: 23
Total Comp: 12
Area A2
DwgCode DwgScale HoursPerDwg CADD Comp
0003 1/4" 7.0 0 10
Total CADD: 13
Total Comp: 22
0004 1/4" 7.5 0 12
Total CADD: 13
Total Comp: 22
0007 1/16” 7.0 13 0
Total CADD: 13
Total Comp: 22
Does anyone have an idea how I can accomplish what I need for this report? Thanks for any and all help.
December 4, 2006 at 11:14 am
It looks to me like list is repeating on DwgCode and not on Area.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply