You’re offline. This is a read only version of the page.
4,184
Hi
In purchase order line, I have three lines, first line has quantity has 0, second with quantity as 100, third is 0,
The report should only display the contents of the line with quantity = 100, other lines should be hidden.
I applied visibility property on the report table as
=IIF(Fields!Quantity_ItemLedgerEntry.Value<>0,False,True)
then the whole report becomes invisible.
Any solution to this?
*This post is locked for comments
If you dont want those Lines (With Zero Quantity) in the Report why Bring those lines even in Dataset?
Filter your Data Item (Purchase Line) In Developer Environment with Quantity <> 0.
With That you dont need to apply any visiblity condition in Report layout.
So, depending on quantity, do you want to check whether to display additional info lines or not?
If yes, set the same visibility on those lines as well.
I assume you have created separate lines in table to display data from line items.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
If you put visibility on rows then entire rows will be hide if quantity is zero and vice versa.
Please apply visibility on Order Line grid and not on entire report dataitem.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
You need to apply visibility on rows and not on the entire dataitem. Apply it on Rows and checl
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (