Filtering data according to parameters being selected on a dialog

Dynamics 365 for Finance and Operations/AX Developer Forum
1

I have a dialog with two dropdown fields and a show details checkbox. The dropdowns are multiselect. When I select one or more than one values from the dropdown, I expect the report to show up data pertaining to the selected information (from the dialogs) only. Currently it shows up everything instead, even when I have the filters for ProjMgr and ProjId. Any suggestions as to how I can fix this will be greatly appreciated.

Attaching a screenshot for better understanding.

filters trouble.PNG
filters trouble.PNG1563×710 33.9 KB
datasetsandparameters.PNG

Thank you

2

I suggest you filter the data already in AX. If your data source is a query, add corresponding query ranges (or just let users to set ranges instead of giving them dialog fields). If it’s a report data provider class, change processReport() to take your parameters into account.