Grouped Crosstab with static rows

[Brian]

I'm trying to construct a grouped crosstab with static rows and some dynamic columns.  I tried just building static rows of a crosstab inside the group header section, but it just summed up ALL of the data for each group (not just data for that group).  Like this

Group 1
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 500000 500000 500000 1500000
Stat 2 50 50 50 150

Group 2
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 500000 500000 500000 1500000
Stat 2 50 50 50 150

The second attempt I added a row group to the crosstab, but then I only get the first group header and then the static rows repeated for each group.  Like this

Group 1
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 200000 200000 200000 600000
Stat 2 20 20 20 60
Stat 1 300000 300000 300000 900000
Stat 2 30 30 30 90

What am I missing that I would need to get the Group 2 header in the 2nd sample?

[Elian]

Hello Brian,

In the first case, where you add the crosstab in the GroupHeader, the crosstab should have no DataSource initially set and the data must be supplied using Bindings:
Property Path:           Expression:
DataSource              = ReportItem.DataObject
This will feed the Crosstab with the data for the current group. 
In order to be of further help, please give us more detailed information on your case.
What is your data structure?
What is the desired report layout?
 
Regards,
Elian
Telerik