SSRS Report Model - filter

Question

Please help !!!

I am using SSRS Model and customer requirement is to filter the data based on the userID. Is it possible to apply the filter in the SSRS Report Model ? I need to consume the report model in the report builder.

For namedquery :

e.g. User1

select * from CompanyInformation where userID = @param1

Thanks Vin

Answer 1

As far as I understood, what you need is a classic parameter use example in SSRS:

For more clarifications, please refer to the following article: https://msdn.microsoft.com/en-us/library/dd220464.aspx

Answer 2

What about making a Parameter @UserID where the User enters their User ID and then it runs the report based on that.

   select * from CompanyInformation 
   where userID = @UserID