Parameters for Report Builder

Is there a way to set parameters for a Report Model? I have a database that includes data for a lot of users and I want to be able to use a Report Model but only allow the user to see data related to their UserID when they are using Report Builder to build a report.

Is this at all possible? Would I have to set up some custom authentication?

Thanks for any help.

Please take a look at Model Item Security.

http://msdn2.microsoft.com/en-us/library/ms156505.aspx

|||Ok, I understand I can limit access to certain parts of a report or datasource, but I want to be able to filter data based on what user is doing the ad hoc querying. So I can do a Select * From tbl_UserData Where UserID = @.UserID. I want to be able to set this @.UserID paramater somehow, but not have the user select it.

Is this possible? Or would I need to set up a different report model or data view for each user who can do ad hoc querying and only allow users to use the report model assigned to them?

If this was explained in the link you posted, I'm sorry but I didn't see how.

Thanks for any help.|||

This post should help:

http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx