Hi All,
how to get SSRS reports like Managerial Hierarchy, like manager can only his child records and other users can able to see only their child user records. and admin can all the records
Regards,
Praveen.
*This post is locked for comments
What error it is throwing. Share your rdl file here
I mean rdl file into crm
while importing this Rdl file it is throwing error
select fullname,BusinessUnitId,ParentSystemUserId,SystemUserId from filteredSystemUser where domainname<>'' and ParentSystemUserId = @User
select fullname,BusinessUnitId,ParentSystemUserId,SystemUserId
from filteredSystemUser
where domainname<>'' and ParentSystemUserId = dbo.fn_FindUserGuid()
I want Parent Records Along with their child records
Yes, That Query is fine. If you want to run it for some specific user then create a user parameter with this dataset:
select fullname,SystemUserId from filteredSystemUser where statecode = 0
Use this Parameter to filter the main query:
select fullname,BusinessUnitId,ParentSystemUserId,SystemUserId from filteredSystemUser where domainname<>'' and SystemUserId = @User
To get the the report for the current user use this query:
Share
Report
All responses (
Answers (
systemuserid = dbo.fn_FindUserGuid()
for this query i am getting all user
select fullname,BusinessUnitId,ParentSystemUserId,SystemUserId from SystemUser where domainname<>''
can you please provide SQL Query
Refer this:
nishantrana.me/.../hierarchical-report-in-ssrs-to-show-users-and-their-managers-crm
Use this Query for CRM online:
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="systemuser">
<attribute name="fullname"/>
<attribute name="systemuserid"/>
<attribute name="parentsystemuserid"/>
<order descending="false" attribute="fullname"/>
</entity>
</fetch>
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156