The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Now Available in Community - New TechTalk Videos for 2020
Read More about New TechTalks for 2020
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
SSRS reports are used to display data in an organized way. It helps the users to get the data as per their own business formats and scenarios. In Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012, SSRS reports play a vital role for the users. Without this, business applications are incomplete. Moreover, running an SSRS report from the selected record of a form is very commonly required by the users.
There are multiple default reports in Microsoft D365FO and Microsoft DAX2012. In my previous article, I have shown you how to Customize SSRS report using extension in D365FO.
In my this tutorial, I will show you how to run an SSRS report from the selected record in a form in Microsoft D365FO and in Microsoft DAX2012. It is very helpful as this is very common requirement.
I am creating a new report from scratch. I am using the Microsoft D365FO environment for the development of the report from scratch. For example, I am creating a Purchase order report.
I have already shared an article about how to Create SSRS report in D365FO. You need to follow that article completely and then come back to this tutorial.
All the steps are mentioned in the article: Create SSRS report in D365FO.
After completing all the steps of the article create SSRS report in D365FO, you would have the following elements in your project:
After that, you have to override a function of controller class. Just copy and paste the following function in the controller class:
protected void prePromptModifyContract()
PurchaseOrderContract contract = this.parmReportContract().parmRdpContract() as PurchaseOrderContract;
if(this.parmArgs().dataset() == tableNum(PurchTable))
PurchTable purchTable = this.parmArgs().record() as PurchTable;
I have already mentioned the properties of the Output Menu Item and the form’s Menu Item Button in Create SSRS report in D365FO. But, because it is too much important, so I am mentioning them again below:
Set the properties of output menu item as follows:
Create an extension of form in which you want to show the output menu item. In this scenario, you should add the button where the Main Data Source table is PurchTable. As, we are fetching the record from the form using the prePromptModifyContract() function.
We have created the Purchase Order Report with the Purchase Order Number (PurchId) as the parameter. So, we should use the PurchTable form.
So, create extension of the form by right-clicking the PurchTable in AOT->User Interface->Forms. Then click the Create extension. In the project, an extension of the PurchTable form would be created. In the form, create Menu Item Button and set the properties as follows:
Note: Needs Record and Data Source properties are only required if you are running an SSRS report from the selected record of a form. Otherwise, it’s not mandatory.
Also, see the article about how to Create SSRS report in D365FO and how to Customize SSRS report using extension in D365FO.
Running an SSRS report from the selected record is well-explained above. If you found any ambiguity or a better solution, please let me know. If this helps you, please Like, Comment and Share to help other community members.
Blog: Click here
YouTube: Click here
GitHub: Click here
I never dreamed about success. I worked for it. – Estée Lauder
The post Running an SSRS report from the selected record appeared first on NevoiTech Blog.
Business Applications communities