SSRS – ad hoc reports | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
SSRS – ad hoc reportsHi,
I am in the process of analyzing the customer requirements for setting up ad hoc reports. I am not clear with respect to the following two requirements:
1. Is it possible to call ssrs ad hoc reports application from web ui?
Is every client machine needs this application installed?
If so, is there a way to show a message that the client machine need to download and install the application for ad-hoc reports to work?
and a message "Do you want to download the application" If Yes, then download the application from a FTP?
2. Is there a way to filter data that a ad-hoc report displays based on the user login – institution mapping?
When a user belonging to Institution A logs-in then that user should able to see data related to institution A only.
You have to control that process using a software and then control the reporting methodology from the server side.