May 27, 2009 at 8:00 am
I have a report, that displays the results of a sql query in a matrix.
SQL Result: see picture1.png
When I'm creating a matrix, with "Group by column, adjacent right", then I'm getting the results as to be seen in picture2.png
What I like to have is ordening like picture3.png
(Hiding duplicates and using a kind of checkbox diagram, checking the options that are true).
Does anybody know if I can do this with Reporting Services?
Or do I have to do it in my SQL Query?
May 29, 2009 at 1:59 am
Hey man.
I don't know how to get the output as you specified. But I attached my output and that layout.
Hope that will be useful to you.
Waiting for your test result.
June 1, 2009 at 4:14 am
For as far as I can see is your output just what I like to see.
I can't see how you do it, the .bmp is not telling the information for the last column.
Can you tell me what you did?
June 1, 2009 at 4:34 am
Hi htilburgs
I attached my source file for you. Find it.
Create a below table and add the values as you like.
I hope this will help.
Still any doubt feel free to reply me
Waiting for your test result
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ForumHardwareService](
[Name] [varchar](100) NULL,
[Category] [varchar](200) NULL,
[Description] [varchar](200) NULL,
[Service] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
June 2, 2009 at 4:51 am
Wow!
This is what I wanted. I've converted it to my own report and it looks great!
I also changed the "X" with the ServiceWindow, so I get 2in1. Many thanks.
(I've included a screendump)
Regards, Harm...
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy