Custom grouping data by column value help
Hi, I'm having a lot of trouble figuring out how to properly setup grouping so that it gives me the data format I need. I'm using SSRS 2008 Here's an example of the data I'm sending to the report Day | Index | Value 1 | 1 | 15 1 | 2 | 23 1 | 3 | 18 2 | 1 | 16 2 | 2 | 50 2 | 3 | 19 By creating a row group on 'Day' and a column group on 'Index' I get this (Index) Day | 1 | 2 | 3 1 | 15 | 23 | 18 2 | 16 | 50 | 19 This is close to what I need. What I would like to be able to do is setup the columns individually. I.e. instead of setting up a generic 'Index" column group I'd like to be able to set up columns for indexes 1,2,3 beforehand. I may need some of the the columns to be different sizes and need to be able to set up their order however I like. I'm not sure how to do this. I've tried writing different iif expressions for the column groups, but can't get that to work. Please let me know if any of this doesn't make sense and thanks in advance for any responses.
July 17th, 2012 1:11pm

Hi Robert, Based on your scenario, you can insert another two column groups to the matrix, add filters to the column groups so that each column group displays only one "Index" value. The filter is like below: Expression: [Index] Operator: = Value: 1 To modify the order of the columns, you can adjust the filter of each column group. The screenshot below is for your reference: Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 10:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics