The "Big Fajitas" Report (Part 2)
Last week I blogged about the Big Fajitas report that I'd been using to track forum participation over on communityserver.org. Since some folks were interested in the "code", I did a little cleaning tonight and decided to make it available. The only change I made was to add a dropdownlist with common date ranges (pictured below).
By default, the report will set the role to "SystemAdministrator" and the date range to "Today". Since it does the calculation on load, this made the most sense as it should be the smallest subset. If you look at the code it should be clear where to change those defaults.
In the downloadable package I've included three files:
- web.config - secures the /ControlPanel/BigFajitas directory from unauthorized access
- default.aspx - the report with inline code
- bigfajitas.sql - the stored procedure that generates the data
In order to get the Big Fajitas report working on your Community Server 2.1 site, just download the attachment, unzip it, and place the BigFajitas folder and its contents in the /ControlPanel directory. You'll also need to run the included sql script (once) in Query Analyzer in order to "install" the stored procedure. (You can delete the bigfajitas.sql file after running it in your database). Then just login to your site and browse to [YourSite]/ControlPanel/BigFajitas. Voila!
Based on feedback, I may continue to improve this report as I'd like to add a couple of previously mentioned items.
Disclaimer:
This report is *not* part of Community Server. It's something that I whipped up on my own. As such, if you find any issues please post them here, not on the forums at cs.org. Also, I didn't take the time to guarantee the performance against huge databases or check all possible edge cases.