Hi Folks,

I have created the SSRS Report, that ssrs picks up the NT user login of the user running the report and uses that to filter some results from a view. in my view has "AD Login" Field.

My Idea is where AD LOgin = @NTuser --(who are running the report)

Can you please help me how to do it.

Hi SQLCHERU,

According to your description, you want to display different report data based on who runs the report, right?

In your scenario, since the "AD Login" Field has been established a relationship with the data in data source, you could use two ways to display user specific data:

• Use report filters to filter user-specific data based on the user accessing the report.
• Use query parameters to restrict data returned by the data source for the user accessing the report.

For more information, please refer to this article: Filtering User-Specific Report Data in SQL Server Reporting Services.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu