You’re offline. This is a read only version of the page.
313
Hi friends,
want to put if condition for two fields in SSRS report in nav 2016
=iif(sum(Fields!CashDiscountAmount.Value, "DataSet_Result") AND ReportItems!Textbox76.Value=0," ","CASH DISCOUNT" )
this is my expression i need to get that text if both filed have value or at least 1 filed have a value if both filed is 0 means i dont want to show this text(CASH DISCOUNT) in report. please give any solution
Thank you
*This post is locked for comments
Hi stefano
Thank you for your reply i got a solution.
Thank you
IIF must be only once at the end of the condition and inside the IIF block you need to place only Boolean conditions. So something like:
=iif((Fields!PrintAmountInLCY.Value = 1) OR ((Fields!PrintDetails.Value = 1) AND (AgedCustLedgEntry[5].value >= 3000)),true,false);
Hi Stefano,
Thank you for your reply , please tell me how to put the more than 2 if condition in row visibility in ssrs report.
=iif(Fields!PrintAmountInLCY.Value,false,true) or iif(Fields!PrintDetails.Value,false,true)&iif(AgedCustLedgEntry[5].value >= 3000,false,true);
i want write a expression like that but unfortunately im getting error in this.
Thank you
The sum is strange, because this is not a condition that you can place in AND with another. I don’t know your requirements but maybe:
=iif((sum(Fields!CashDiscountAmount.Value, "DataSet_Result")=0) AND ( ReportItems!Textbox76.Value=0)," ","CASH DISCOUNT" )
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
