Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I want to develop SSRS reports where I can filter the records and the data by the Business Unit of the current logged in user. These reports will be displayed on the Dashboard.
Can I get the id of the current logged in user or its business unit in my SQL query at runtime, so that I can use it to filter the records such that when the user of say Business Unit A logs in, he is shown the reports but only with the data relevent to the users of Business Unit A. ?
If you use the filteredview, actually it will retrieve and return the data based on what the each user can see, it will be managed by Security Role and Business Unit thing.
So,let's say you use select * from filteredaccount, you set User A to BU A then give access to only BU Access.
Then the user A when run the report will see all Account under his BU ownership, owned by BU A.
While, other user, User B can only see records owned by BU-B and System Admin can see all accounts created and owned by any BU.
Anyway, you can get the current user id (logged used) data from:
CRM SQL function fn_FindUserGuid.
Hope this helps.
Looks good. I will check this as there are some complex reports and will get back here.
You're a great help :)
To create a report in SSRS, this is very important to use the filteredview and also use the CRM SQL built-in function.
Hope this can solve your problem.
Can you please reflect more on filteredview? Does this mean that we filter the date via SQL in SSRS query?
I want to the records of Incident (Case) based on the BU. There are several BUs and each BU manager needs to see the reports for the records of their own BU.
Yes, as I mentioned before.
FilteredView will be useful for you to filter the data easily using security role, not parameter at all in the SSRS.
can we make it work somehow in VS 2013 BIDS?
I think VS2013 BIDS doesn't support for Dynamics CRM report extension. try either VS2012 BIDS or 2015BIDS
Business Applications communities