Notifications
Announcements
No record found.
Hey! I am new to Microsoft Dynamics and I have a problem. I need to make a report that has the filter fields. When selecting a customer, only his sales and not all sales should be displayed. how should I think and write the code? Is there a class that executes the same logic and where can I look?
Are you saying that you're going to develop an SSRS report and you have no idea how to do it? Or do you have any particular problem, e.g. with the filter?
If you want an SSRS report, there are two approaches to consider. Either having a parameter where users can select a customer, or - which is much more flexible - using a query where uses can set any filter they like. You'll give them a default query range for customer number, where they can select a single customer, as with the parameter, but they could also use several customers at once, use wild cards, filter by other fields and so on.
If using an SSRS report isn't required, using a form may be easier. There even already is functionality for that - you can go to a customer and open a list of related orders.
Hi Pavel Ioana,
Please check the below link which explain about filtering field on the report based on the selection of the another parameters.
So you can add the look up for the table "SalesTable" and add range to the custAccount field.
https://vasantharivali.wordpress.com/2014/09/24/filter-second-lookup-based-on-first-value-ax-2012-ssrs/
Thanks,
Girish S.
This blog post seems to be unrelated to the topic of this thread, therefore my recommendation to Pavel is ignoring it.
Thanks Girish, this is what I need!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
