90
Hello Experts,
I'm new to report designing.
I designed a simple report to generate item's quantity based on expiration date range. On generating the report, I'm getting items with quantity value and also zero quantities.
How can I filter this out? I only need items with values
Kindly advise
Hi, If you try to modify it in the Development Environment, a development license is required.
But if you just want to modify the RDLC file, you can use the following method to update, which does not require a development license and AL project.
Hope this will help.
Thanks.
ZHU
The RDLC solution does not require license.
Doing it in the AL code only requires license if you run on-prem.
Hi,
May I know do you need a development license to do the above?
Thank you!
Awesome
Thank you ZHU & Nitin, you guys are a life safer. Issue resolved...
Hi, The method provided by Nitin is the most common, it does not generate rows with zero quantities when generating report data.
Here is a method only on RDLC file, you can also refer to it.
Hope this helps.
Thanks.
ZHU
Hi,
please go to the item data item choose properties and then use property calcfield = inventory
after doing above steps just go to Onaftergetrecord trigger of the data item and here you can write below conditions
If rec.inventory =0 then
currreport.skip
it will skip those records which has 0 quantity
hope it will help you.
thanks
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
