1,835
If the sale order line no is zero then header must be visible false...and sale order line no must not show here.
I m trying with column visibility property..but it is not working
=First(Fields!saleordlinno.Value, "DataSet_Result")<0
And for heading Sale Order NO is:
=IIF(String.IsNullOrEmpty(First(Fields!saleordlinno.Value, "DataSet_Result")), true,false)
Both are not working.
Manish
*This post is locked for comments
Very thanx. Binesh sir
issue is resolved.
manish
Hello Manish,
Follow the Saurabh solution.
In onafter trigger, Write something like:
If saleordlinno > 0 then
ShowLineCol := true
Else
Clear(ShowLineCol);
// ShowLineCol is a boolean variable.
Paas this variable in dataitem fields.
In. saleordlinno column visibility write something like
Iif(Fields!ShowLineCol.Value,False,True)
Hi Manish,
As it a column which may have diffrent values in diffrent report lines you cannot use it like the way you are trying.
In both the condition that you are specifying which row record system should consider for testing the condition.
The only way to acheive this is -
You need to check that all lines appearing in report have your field value zero in the developer environment and if that is true then pass a boolean variable as true which can then be used for column visiblity.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (