I use Stimulsoft Reports.net to make print reports in my management software (it is provided with this editor)
I need to count 8 variables (from custom fields in my management software) if and only if they are not zero
The variables are :
SaleDocument.ContactFields_Name
SaleDocument.ContactFields_Name1
SaleDocument.ContactFields_Name3
SaleDocument.ContactFields_Name5
SaleDocument.ContactFields_Name7
SaleDocument.ContactFields_Name9
SaleDocument.ContactFields_Name11
SaleDocument.ContactFields_Name13
I tried to do something like :
Code: Select all
{Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name1),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name3),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name5),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name7),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name9),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name11),"0","1")) +
Format("{0:N0}", IIF(String.IsNullOrEmpty(SaleDocument.ContactFields_Name13),"0","1"))}
11100000
Don't know how to do that
iLtG