I Want to create a report using SQL Server Reporting Services. In Visual Studio I created a report to get SharePoint data from a list.
I want to get the current logged in user in SharePoint and check the user permission based on that permission I need to show the data in report. For that how can I write the query in query designer?
I have a user profile area list in that area name should be approved he able to create new contract using that area name.
This is Robert Login he able to see only General, HR, Legal. In above image in user profile area list finance is Denied for robert.
This is George login he able to see only General, HR, Legal, and Finance.
How can I write the query in Query Designer?
I was logged in Robert but in Report it was showing all Contract Areas.