I’m not sure how best to word this so here goes, does anyone have any reccomendations on the best way to create something (be it an Infopath from, an Excel Spreadsheet, or anything else) that will allow for live (or as close to live as possible) monitoring of data from a SQL Database.
Currently we have a view that pulls together data from several tables. This view is basicaly showing a queue of requests. The queue changes constantly as new requests come in and existing requests are completed. Currently I use a SELECT statement on the view in the SQL Server Query Tool that comes with SQL Server 2005/2008. I’m looking for an easier way to do this, something like a form that when loaded/opened will re-query the View and show the results. I’m not too concerned about looks or formatting and so an Excel Spreadsheet like layout would be fine however if I could use something that would allow some formatting control and or grouping that would be nice but I’m not married to that idea.
We have the complete suite of Office products so I have a lot of choice however none seem to be easily setup to do this or at least its not obvious. I tried to do something in InfoPath and stopped when it showed what looked like a 2 way connection, enabling the pushing down of data as well as pulling and that is a NO-NO in thsi case. I need a READ ONLY view of this View in the database.
It would also be nice if the ‘THING’ I came up with had the ability to automatically re-query the View every X seconds so I don’t have to continually reload or re-open the item to re-query the view.
I would think that in all of the MS Office suite there would be something that would easily allow for setting up a monitoring form or Window for this kind of thing but if there is it isn’t very obvious.
Any suggestions?
Thanks
