Posts

How to drill-down in D365fo SSRS report.

Image
 In this blog we will see how we can create a drill-down report through precision design  in Dynamics 365 Finance and Operations. We will simply create a RDP report or Query report. In report data source we will provide our dataset (Figure 1.1). (Figure 1.1) We will create a precision design and add the grouping on required fields. In my case I have BDA, Sales man, Month and Customer account as you will see in Figure attached below (Figure1.2). (Figure1.2) Now we will look how to add toggle item regarding to the group we have added in our design. Our first group is BDA and we will set our Group properties as follow.                              After that ,for our  Sales Taker group property we will add toggle item as BDA  . For  Month Name group   we will add toggle item as our  Sales Taker  group. Our last group which is  Cust Account  we will add tog...