Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Oftentimes when a report is pulled in Microsoft Dynamics 365, there will be certain search criteria. When based on the 1st value selection, the 2nd option list should populate in the report parameters. In order to get those precise values, you need to use cascading parameters for reports in Dynamics 365. In today’s blog, we will show you how to use dependent parameters to pull these reports. Let’ get started!
Prerequisite: Create a report in Visual Studio BIDS (sample.rdl), in the example the report to display the orders for given year and given month. The sample report should show Months, only when Year is selected.
When to use: Dependent Parameters should be enabled after selecting the first parameter.
In our example today, we want to enable the Year and Month parameters.
Visual Studio BID>new report (rdl) file>report designer.
In the Select field, choose Year and month from the drop-down menu.
Now, we can select the appropriate Year and Month fields from a list of drop down options.
Next, enable the default value of the parameter and specify a value for which the parameter should be enabled.
That’s all it takes to set up a simple cascading parameter. Make sure to stop by our CRM for Dynamics 365 blog daily, for even more fun tips and tricks like this one!
Happy Dynamics 365’ing!
Business Applications communities