Mark,

I have not read thru the entire article yet and so this question may be directly answered in it but a quick skim thru it did not seem to indicate the answer I seek is in the article.

I have been looking for some time now an application that will enable me to produce what i would think of as a dashboard. A dashboard being a window consisting of 1 or more parts in which each part is displaying the results of some ODBC/ado complaint data source (primarily a query or view from a SQL Server database) in either a grid or a chart/diagram that has some sorting and or filtering capabilities. Currently I often find myself copying the results from the data grid in SSMS to Excel and re-sorting them and even performing calculations and all because there is no way in SSMS to do anything with the results in the grid save for copy and paste to send them somewhere else for filtering and sorting and so on.

The best way to explain what I am looking for is to give an example.

Let’s say I have a SQL database hosted on SQL Server 2005. Within my database there are a number of tables that comprise reporting data such as who asked for what report and when as well as what criteria was specified each time. Currently I have a snippet of T-SQL consisting of a temp table and several query’s that pull from that temp table which when run altogether produce a number of results in the grid results area of a SSMS window. While the code snippet has most of the criteria hard coded such as dates (From – To) there is no way aside from manually editing it easily change the criteria or to filter the results (or re-sort them) without req-querying the source or the temp table.

What I would like if a dashboard that takes each query result in my code snippet and shows it in a separate grid which is sortable and filter-capable without having to re-run the query’s.

Does that sound like something that QlikView can do?

Thank you