REL Reporting Services 1

[allyne]

Hi Everyone,

Not sure if this is the right place to ask this but I'm new to the reporting module in sql server 2008 and have been asked to see if there is a way to create a report so that the end user can use and select their own fields and generate their own reports without downloading the reporting tool? Basically I would create a stored procedure and create some kind of report/dashboard that the user can add and take away any fields that they don't want to see within the stored procedure. Is this possible? If so how? Or can you point me in the right direction?

Thanks for your help!

 

[simian336]

In my experience as far as Reporting Services, no.

Reporting Services let you create and save HTML reports that can then be brought up from a web site.

You can add drop downs that might let you change the critera.

If you want the end user can use to be able select their own fields and generate their own reports you will probably need a 3rd party tool like Crystal Reports, etc.

Simi

 

[allyne]

Thanks for your help!