March 12, 2013 at 6:02 pm
Hi guys,
I'm looking to create a report that will detail how many times each SSRS report was executed over the last 12 months. I'm aware that by default the execution log only holds 2 months worth of data but we're going to be changing this to hold 12 months worth.
My initial thought was to do some kind of pivot but I'm not sure how to make this dynamic in terms of the dates. I'd like the report to look something like:
Report Name Jan 2013 Feb 2013 Mar 2013
Report1 12 15 10
....... and so on
What would be the best way for me to do this?
Thanks in advance
March 12, 2013 at 11:29 pm
Here is an example of something that has already been done.
It might not be exactly what you want, but give it a look and see if it will work.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2013 at 11:46 pm
Ok I'll check out the link. Thanks.
I also found an example of creating a dynamic column list within a pivot which I think should work.
If it does I'll report back with the solution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply