please look at my problem..

I don't know what to call this but here is my problem:

I need to create a report:
sample table
(grouping by name)

name: kris (table_group1)
called number | type of call | duration (table_group1)
303492 call1 110 (table_detail)
3202394 call1 102
230384 call3 90
(sum up by grouping the calltypes)
type of call | duration total
call1 212
call3 90

(this is now the same as above)
name: nemo
called number | type of call | duration
303491 call2 111
3202392 call4 222
230386 call4 33

type of call | duration total
call2 111
call4 255

I can show the report by:
inserting a group then expression: "=fields!name.value"
(this solves the grouping for the name)

but my problem is the:
**********************************
type of call | duration total
call2 111
call4 255
**********************************

how do I do this? because i tried subreport, its showing differently results, same with inserting another group(group_2).

I apologize if there has been a same post of what i'm asking, but i just don't know what to call this. if anyone know something that can help, please reply here. thank you!

My Solution to this problem would be other way round, from high level to individual details. (Drill down)

Create a table. Make 2 header rows. Insert Name in first row. Insert Type of Call and Duration Total in the second row. Make Name and Type of Call as Drilldown by clicking Properties->Advanced->Visibility tab->Initial Appearance as Collapsed.

Make expression of Duration Total as =Sum(fields!duration.value)

In the detail row, add a text field with expression =fields!duration.value

When u preview, u should see multiple rows for Names and when u click on (+) sign before Name, it shows Type of Call and Duration Total for that Type of Call. When u click on (+) sign before Type of Call, it shows individual Type of Calls with their Duration.

Hope it helps.

|||Thanks for the alternative solution, Girija! I'll think about it. but it'll be much better if i can stick with the layout i thought of. :) Still, that is a good and possible idea ;) Thank you!

If anyone else have any idea how to make a same layout same as my example, please spare some time to post in here. Thank you!

|||Can you add a new group for each call type then drag and drop the duration field within the group and do a sum ....