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

Crosstab and groupings

5 Answers 57 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Travis
Top achievements
Rank 1
Travis asked on 14 Nov 2012, 07:21 PM
Here's My data:

Account Fund    Amount      Group
Acct1   Fund1   $20     1
Acct1   Fund2   $30     1
Acct1   Fund3   $40     2   
Acct1   Fund4   $50     2
Acct2   Fund1   $60     1
Acct2   Fund2   $70     1
Acct2   Fund3   $80     2
Acct2   Fund4   $90     2

I've created a crosstab report that looks like this:

    Fund1   Fund2   Fund3   Fund4
Acct1   $20     $30     $40     $50
Acct2   $60     $70     $80     $90

I created a group for my "Group" column, but then my report includes all of the fund columns like this:

Group 1
    Fund1   Fund2   Fund3   Fund4
Acct1   $20     $30     0       0   
Acct2   $60     $70     0       0   
  
  
Group 2
    Fund1   Fund2   Fund3   Fund4
Acct1   0       0       $40     $50
Acct2   0       0       $80     $90

But what I want is the report to look like this:

Group 1
    Fund1   Fund2   
Acct1   $20     $30 
Acct2   $60     $70 
  
  
Group 2
    Fund3   Fund4
Acct1   $40     $50
Acct2   $80     $90

How do I do that?

5 Answers, 1 is accepted

Sort by
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 19 Nov 2012, 11:07 AM
Try applying a filter over the crosstabs. In the first crosstab you  filter Fund3 and Fund4 and in the first  Fund1 and Fund2. 
0
Travis
Top achievements
Rank 1
answered on 19 Nov 2012, 03:13 PM
I cannot filter by fund since fund is dynamic.  A report could have fund1, fund2, ...fundX.
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 21 Nov 2012, 08:56 AM
Try the following in the Column Group (Fund group) set the following filter:
=Sum(Fields.Amount) > 0.
0
Travis
Top achievements
Rank 1
answered on 26 Nov 2012, 03:28 PM
Sometimes I will have a valid $0 amount, so that doesn't work either.
0
Elian
Telerik team
answered on 28 Nov 2012, 10:12 AM
Hello Travis,

If you create report groups, which group by Category and all the grouped items do not contain specific Funds (for e.g. Fund3 and Fund4), then there shouldn't be columns in the crosstab for them. If however there is data for e.g. in the first group for Fund4, then naturally Fund4 column will appear. 
Please review the attached report showing your scenario implemented with a crosstab and report groups.
 
Regards,
Elian
the Telerik team

HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

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