SQL Server Reporting Services: Your Favourite Reports
To make things simpler for our end-users, we have a report in Reporting Services that queries the ReportServer database and presents the users with a simple list of reports. We call it "Report Portal", and it's a lot simpler than the Report Manager UI that you get by default.
Something I've added to it just recently is a section at the top that lists the six reports you run the most often, based on your Windows login. I call it "Your Favourite Reports", and here's the query:
select top 6 c.Name, c.Path from ExecutionLog l with (nolock) inner join Catalog c with (nolock) on c.ItemID = l.ReportID
and c.Path like '/SomeFolder/%'
and c.Hidden = 0 and c.Name <> 'Report Portal' where l.UserName = @Username group by c.Name, c.Path order by count(*) desc
For the "@Username" parameter, we pass in User!UserID from Reporting Services.
I can recommend this approach - it's a way of giving your users a "menu" of reports that keeps the same "branding" as all your other reports. This "faves" list only adds to the experience.
Comments
#
24/05/2007 8:31 AM
Thats a brillant idea. I'm suprised that nobody has requested this or have they ?
The upside i spose is that eventually you could do stats on reports that have never been run that users requested because "Its always been there". You could then possibly archive or remove them.
This would also depend on the type of report also, you might have a year end report that has not yet been ran !