SSRS – ad hoc reports | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSRS – ad hoc reports

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.


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |