Report with 'checkbox diagram'

Question

Post reply

Report with 'checkbox diagram'

htilburgs

Ten Centuries

Points: 1117
More actions
May 27, 2009 at 8:00 am

#221661

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?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 1

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.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

htilburgs Ten Centuries Points: 1117 More actions · Answer 2

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?

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 3

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

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

htilburgs Ten Centuries Points: 1117 More actions · Answer 4

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...

Report with 'checkbox diagram'

Cookies on SQLServerCentral