I have to show/hide ssrs report in AX 2012. The condition is I have the menu item button which displays label values from the Transfer order. There are multiple lines for each transfer order. For eg. we take one transfer order with 4 lines and when we select the line we see the view details form of the field Pallet id. There is the field on WMSPallet form which is INDTareWeight. If INDTAREWEIGHT >0 for any line only that line value should come in report and remaining should not show. If 3rd line value displays tare weight value > 0 than 1st and 3rd value should come in report. How to modify this condition in SSRS report?
What do you mean by "show/hide SSRS report" and "How to modify this condition in SSRS report"?
Do you want to hide a button that launches the report? Or do you want to change the report contents based on the condition?
If it's about showing/hiding the button, you already asked it one time, got an answer and marked the answer as verified: community.dynamics.com/.../disable-button-from-code
If you have some open questions about it, please post it in the same discussion.
Hi Nikolaos, Need to change the report contents based on the condition. If TareWeight is > 0 for suppose 1st and 3rd line the content of these two line comes in the report while 2nd and 4th remains hidden. kindly guide me for the same.
The solution depends on your report. For example, if you have a report that is based on a temp table, simply don't create temp table records for those lines where TareWeight is 0.
If the report is based on a query, you have to modify the query in a way that it filters out such records.
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 Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 756 Super User 2025 Season 2
CA Neeraj Kumar 678
Martin Dráb 526 Most Valuable Professional
