Sunday, December 6, 2009

SQL SSRS ad hoc report generation

In sql ssrs we have an option where the users can generate there own reports and store them in there own location. To develop ad hoc reports by end users the following need to be provided by the administrator.

Go to the report manager page.
Click on the datasource.
General a report model.

Also the user can generate the ad hoc reports provided he has the option given to generate reports and save them in the Myreports folder.

This will allow the users to generate ad hoc reports from their own web browsers.

1 comment:

  1. get the online dbf repair utility and start the parsing of affected documents if you’d like to repair not openable files. It does not take a lot of time

    ReplyDelete