Post reply

Update a table from a report for a dashboard of alerts

  • March 1, 2012 at 7:59 am

    #253981

    Hi All

    This may or may not be possible but here goes.

    I'm creating a dashboard for a few monitoring metrics which will flash up alerts based on certain thresholds. What I want to do is to have a check box of some sorts next to the alert, that when I check it, it goes away and updates a column.

    The report will bring information like this

    SELECT col1, col2 FROM table1 WHERE DateCollected >= CONVERT(DATE,GETDATE()) AND cleared = 0

    Say this brings back 10 rows

    Then I want to update cleared for the 5th row to 1 done in the report, then the report is set to refresh every 60 seconds, in which case the report should then only show 9 rows.

    Hope this makes sence.

  • April 13, 2012 at 9:20 am

    #1473304

    Turley & Bruckner have a book "SQL Server Reporting Services Recipes" and this is covered in Part V Section: "Updating Data From a Report"

  • April 13, 2012 at 11:48 am

    #1473386

    mikeg 31960 (4/13/2012)

    Turley & Bruckner have a book "SQL Server Reporting Services Recipes" and this is covered in Part V Section: "Updating Data From a Report"

    If you are doing any type of advanced reporting work, this book is the place to go. You'll get value out it beyond just the check box examples. It's saved me a lot of trouble and expanded my skill set. Highly recommended.

    MWise

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

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