Dear Experts,
I want to develop a report which will show raw materials for BOM and FORMULA, as we click on BOM lines it shows BOM raw materials when be click on Formula line it shows Formula Raw Materials.In the same manner when i choose Formula or BOM in parameter it shows its raw Materials. What will be the proess to develop this report. This will be developed by using data contract and dp class or query will be enough, please help.
Best Regards,
Shabir Ahmad
Hello Shabir Ahmad,
Please let us know your AX version ? Thank you.
Hi Shabir,
I have an idea for you reference. make this control on SSRS side.
that means, DP provide both BOM and Formula data to SSRS.
in SSRS there is a parameter, if click BOM lines checked box, then on SSRS field property setup this field show or disable.
Hi Michal Krejza,
The version of ax is 2012 R3.
Shabir
Hi Hery Xie,
So, first i should make a temp table query and drag all table to it as datasource then make DP class and Contract class with to parameter member one for BOM check box and another for formula check box ??
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 783
André Arnaud de Cal... 715 Super User 2025 Season 2
Sohaib Cheema 519 User Group Leader
