Adhoc report for End users

Last post 09-18-2009 6:00 AM by fibrock. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

08-07-2009 6:15 AM

Hilldrup
Joined on 07-08-2009
Posts 1

Adhoc report for End users

Reply Contact

Hello everyone, I was wondering if any body is using an adhoc reprot tool for sql. We are trying to get our end user here to try to create some of thier adhoc reports. This tool would need to be at the end users level and not too technical. If anyone know of a program out there please reply. Have a good day

09-15-2009 8:02 AM In reply to

jbohanon
Joined on 11-13-2008
Richmond, VA
Posts 1

Re: Adhoc report for End users

Reply Contact

Actually SSRS has an ad hoc tool called Report Builder that is pretty good. I use it for my customer base. It has security filters that you can put on your report data model to limit the data that is returned so that you can isolate 1 users data from the next. Although the filter can be a little bit buggy.

Jason Bohanon
Database Systems Manager
Century Distribution Systems, Inc
Richmond, VA

09-18-2009 6:00 AM In reply to

fibrock
Joined on 03-20-2008
Richmond VA
Posts 98

Re: Adhoc report for End users

Reply Contact

We use a few different products. The one that I like the best is to create a number of different reporting services reports with multiple parameters with the column sort option for each column turned on. While this is not true ad-hoc report we have found it goes a long way in getting users the data they want, once they have defined the different data elements they want returned. To make this reporting process a little cleaner you can build a custom ASP.NET app that calls the different reports based on the data set the user selects and passes the parameters to the underlying reports. Once again this the user the ability to select different pre-defined data sets and filter the data using different parameter options. Just an idea.

Steve Fibich
http://stevefibich.net
http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/default.aspx
http://www.sqlservercentral.com/Authors/Articles/Steve_Fibich/525287/

Page 1 of 1 (3 items)

Join Our Mailing List!

We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!

Join Today!

RichmondSQL