340
Hi all,
I have created SSRS Report but i need to show that report based on user role. When any user open that report in CRM then the Report want parameters based on City , State. The report should display results based on the Security role of that user who want to view the report means the Sales Person in one region should not see the report of another region.
*This post is locked for comments
Can you tell what exactly u r getting as result: No record or all the records?
If it is all record then it means the credential of current user are not being passed rather system admin account is being used to run report. Can you go to http://servername/Reports and configure Connection String.
You can refer here :rajeevpentyala.com/.../ssrs
Thanks,
PS
No , I am using FilteredView approach.
They are only individual or organization report.
While Individual report, can only owned by A TEAM or A USER.
Refer the following thread:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (