URGENT: Specific Models in Report Builder

Is there any way to display specific models in Report Builder, depending on the permissions granted to users on different folders. For e.g. If the user has been granted permission on folder A, not B, then he/she should not see the models from B, when launching Report Builder from web application.

Any help or suggestions or pointers is highly appreciated. Thanks in advance.

[390 byte] By [RajeebSharma] at [2007-12-19]
# 1

Model visibility is controlled just like any other items on the report server (e.g. reports, data sources, folders). If a user does not have read permission on a model, it will not appear in the list of models displayed in Report Builder. You can set these permissions in SQL Management Studio.

BobMeyersMSFT at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2

Thanks Bob,

I have set permission on the folder (as per my question post) for specific users. The Report Builder still displays all the models to all users. Am I missing out something ?

Well, the scenario is am launching Report Builder (ReportServer/ReportBuilder/ReportBuilder.application) from a web application, which is working on Forms Authentication. Is this creating a problem ? If yes, any work-around?

Please suggest. Its very URGENT !! Thanks in advance.

RajeebSharma at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

Thanks Bob,

I got the solution. I was testing with the account was a member of Local Administrator group.

Thanks again.

RajeebSharma at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified