August 9, 2011 at 7:57 am
Hi guys,
I have the following results from an SQL query:
Campaign | Cost | Description
C1 | 0.35 | Postage
C1 | 0.10 | Packaging
C1 | 0.03 | Datacapture
C1 | 0.07 | Processing
C2 | 0.28 | Postage
C2 | 0.03 | Packaging
C2 | 0.09 | Datacapture
C2 | 0.10 | Processing
C3 | 0.80 | Postage
C3 | 0.10 | Packaging
C3 | 0.15 | Datacapture
C3 | 0.09 | Processing
I'd like to produce a report that looks like:
Campaign | Postage | Packaging | Datacapture | Processing
C1 | 0.35 | 0.10 | 0.03 | 0.07
C2 | 0.28 | 0.03 | 0.09 | 0.10
C3 | 0.80 | 0.10 | 0.15 | 0.09
Have I gone about the query the wrong way, or is there something in the Layout section that I can do?
Thanks for your time,
Chris
August 9, 2011 at 8:03 am
No it's perfect.
In you SSRS report add a matrix.
The row group will be the campain.
The column group will be the Description
The data group will the the cost.
August 9, 2011 at 8:49 am
Ooo.. so it is. Never used the Matrix table. Very easy to use. Thank you.
August 9, 2011 at 8:50 am
HTH, come back anytime!
August 9, 2011 at 9:49 am
On the same topic, how do I set the order of the columns that the matrix creates? As not all the same Campaigns have the same charges...
August 9, 2011 at 9:55 am
Right click on the group, modify group, sort.
August 10, 2011 at 4:33 am
Thank you, that kind of helps. However, is there a way to set the actual order placement for each individual column? As there are about 30 columns with some that I would liked grouped together in the same matrix.
If not I will just name them with a through to z before the actual title.
Thanks
August 10, 2011 at 5:57 am
Well the details column you sort then manually when you insert them
The Grouped columns can be sorted on all levels. So I don't know where you are getting stuck on this. Maybe a screenshot would help me out (data view & design view)
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply