SSRS Chart help

  • Hi,

    I have to create a chart based on server performance as shown in the attachment.

    CREATE TABLE #SSRSChart ( Status VARCHAR(10),ServerName VARCHAR(10),HOUR INT)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',0)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',1)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',2)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',3)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',4)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',5)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',6)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',7)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'SUCCESS', 'Server B',0)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server B',1)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'WARNING', 'Server B',2)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server B',3)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server A',4)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'SUCCESS', 'Server B',5)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'SUCCESS', 'Server B',6)

    INSERT INTO #SSRSChart

    ( Status, ServerName, HOUR )

    VALUES ( 'ERROR', 'Server B',7)

    SELECT * FROM #SSRSChart ORDER BY 2

    DROP TABLE #SSRSChart

    Please help.

  • Why not just create a report? When I look at your attached picture, it looks like a straight-forward report to me.

    Rob

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

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