Report with 'checkbox diagram'

  • 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?

  • 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

  • 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?

  • 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

  • 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