May 13, 2010 at 11:41 am
Hi,
How to create a group on muliple variables in reporting service 2005?
thanks,
Wei
May 13, 2010 at 11:45 am
when you say group on a variable can you give an example of what you mean?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
May 13, 2010 at 11:52 am
Bascially I have detail data like this
field1 field2 field3 field4 field5
a1 b1 c1 d1 e1
a1 b1 c1 d2 e2
a1 b1 c1 d3 e3
a2 b2 c2 d4 e4
a2 b2 c2 d5 e5
I want my report to display like the following
field1 field2 field3 field4 field5
a1 b1 c1 d1 e1
d2 e2
d3 e3
a2 b2 c2 d4 e4
d5 e5
I am thinking using grouping and group on filed1, field2 and field3 to get the desired result.
that's why I have the original question. I am not sure whether that's the right way, or there is better way to handle this. any suggestions are welcome.
thanks,
Wei
May 13, 2010 at 11:58 am
based on your sample data what you are looking for is way more complicated then simple grouping. Grouping would only group details that are alike in field 1. So if you grouped field 1 you would get a group af all rows containing exactly a1. I aologize in that I do not readily have a suggestion on how to do what you need but I can tell you that simple grouping would not give the result you have listed.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply