I am totally new to reporting services and trying to figure out how to create a report with the row count of a table at specific intervals of a day. So what i am trying to do is i have a table which is highly transactional(it has inserts, deletes) and wanted to find out the count of it for every 30 minutes and represent it on a report server with in a graph. How can i do that?
sounds like what you want is schedule a sql server agent job which populate a table with your required count value. Then you can create a report to show this value and add a subscription to make it render at required intervals automatically with latest count value from table
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Can't we do this with out creating any table by directly running a query for every 30 minutes?
why do you want to simply aggregate entire data each time? By having an intermediate table you'll only need to do aggregation for deltas (changes) since last run (ie last 30 minute period). Running it on the fly mean you aggregate entire data each time which would be bit of performance bottleneck with all thode high freq large DML operations (insert/update etc) happening in parallel.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Simple count in a report
Posted - 05/24/2012 : 21:14:21
