June 26, 2012 at 3:07 pm
The hardest thing about seeking answers is knowing how to ask and that’s easier said than done.
That said, does anyone know if there is way in SSRS to get Activity Monitor like functionality which pulls data from user defined data sources such like views? If it were possible to take Activity Monitor and change its data source and how it displays the data it gets then that would be perfect.
What I’m trying to do is take a bunch of T-SQL queries that I execute on a regular basis throughout the day and put them into an interactive auto-refreshing interface like Activity Monitor. These queries provide Activity Monitor like data but for Report Request by users who work in a third party accounting software package we use.
I haven’t been able to find a way to do this without using something expensive or hefty like QlikView so I’m kind of hoping that maybe there’s a way to do this with SSRS.
The queries I execute are not identical in the number of columns or type of data in each column so they can’t be stacked or joined via a UNION statement so I would need the ability to create a report like output that has multiple sections of data to accommodate the differences between the dozen or so queries I use.
If SSRS can do this then that’s all I need to know as I am happy to invest a good but of time to only discover that what I am trying to do is not possible in SSRS.
Any ideas?
Kindest Regards,
Just say No to Facebook!June 27, 2012 at 4:16 am
There is the autorefresh option on the properties of the report, so you can have it refresh every X amount of seconds.
So I guess it would just be a case of setting up your dashboard how you want and then setting that property to say 300 seconds if you want the data every 5 minutes.
Can create a parameter and pass it in as an expression.
June 28, 2012 at 7:12 am
I'd also like to do something like this. Any chance when you've got it working you can do a write up?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply