not null

Jump to: Board index.NET FrameworkStimulsoft Reports.Web

Stimulsoft Reports.Web discussion

not null

Post Fri Oct 13, 2017 3:54 pm

How would I create an if formula with not null? Basically I have the formula below that says not = to 0. However that 0 is a null value.


{IIF(Closing_Balance.Day_5_Closing_Balance_Sum!=0,Closing_Balance.Day_5_Closing_Balance_Sum,IIF(Closing_Balance.Day_4_Closing_Balance_Sum!=0,Closing_Balance.Day_4_Closing_Balance_Sum,IIF(Closing_Balance.Day_3_Closing_Balance_Sum!=0,Closing_Balance.Day_3_Closing_Balance_Sum,IIF(Closing_Balance.Day_2_Closing_Balance_Sum!=0,Closing_Balance.Day_2_Closing_Balance_Sum,Closing_Balance.Day_1_Closing_Balance_Sum))))}
laducd
 
Posts: 111
Joined: Thu Oct 23, 2014 2:15 pm

Re: not null

Post Fri Oct 13, 2017 10:39 pm

Hi Laducd,

Please check out the following post: viewtopic.php?t=2265

And then please try to replace every value in your expression as follows:

Closing_Balance.Day_5_Closing_Balance_Sum!=0
to
Closing_Balance["Day_5_Closing_Balance_Sum"] == DBNull.Value ? 0 : Closing_Balance.Day_5_Closing_Balance_Sum != 0

Thank you,
Edward
Edward
 
Posts: 2730
Joined: Fri Jun 09, 2006 4:02 am

Re: not null

Post Tue Oct 31, 2017 4:33 pm

perfect thanks
laducd
 
Posts: 111
Joined: Thu Oct 23, 2014 2:15 pm

Re: not null

Post Tue Oct 31, 2017 7:50 pm

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
Alex K.
 
Posts: 6278
Joined: Thu Jul 29, 2010 2:37 am


Return to Stimulsoft Reports.Web

Who is online

Users browsing this forum: No registered users and 3 guests

cron