November 30, 2004 at 7:30 am
Hi
We used to use an Access frontend to our reports. The frontend had some code that inserted a record into a table that tracked who ran which report. This worked well to give us figures on which reports were used, which weren't e.t.c.
We've now moved to Reporting Services and want to implement something similar. The 'History' functionality doesn't seem to do what we want, as we're not bothered with snapshots e.t.c. We simply want to record who ran which report, or even just a count of how many times a report has been run.
Is there a way to do this automatically with Reporting Services? If we had used stored procs as our source then we could have done it that way, but we just use views specific to each report.
Any thoughts/ideas? Apologies if this has been covered elsewhere, but a search failed to uncover a solution.
November 30, 2004 at 8:13 am
Ah, see if I'd just thought about it for a second or two before posting this message...
We've come up with a solution:
Create a logging table.
Create a stored proc to insert a record into the logging table.
Call the stored proc as the first line of SQL in a Report Dataset.
It works like a treat so far.
December 1, 2004 at 1:51 am
Try entering RSExecutionLog in Google or just go direct to here:-http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
This is a tool that comes with Reporting Services, which basically provides various reports on itself. Very good indeed.
December 1, 2004 at 1:57 am
Thanks for the link, I'll check it out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply