This is a migrated thread and some comments may be shown as answers.

Grouped Crosstab with static rows

1 Answer 104 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 29 May 2013, 09:07 PM
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?

1 Answer, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 03 Jun 2013, 09:52 AM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Tags
General Discussions
Asked by
Brian
Top achievements
Rank 1
Answers by
Elian
Telerik team
Share this question
or