c# - Report if one value is null don't show other value -


i'm trying build report asp.net report.

if check image:

enter image description here

i'm showing table tickets , charge. charge column has these value:

=fields!charge.value 

what want achieve show charge value if ticket value not null. see in image, there 4 tickets visible , want show charge 4 tickets not charges.

any idea how can achieve that?

you can use following in charge column

 =iif(isnothing(fields!ticket.value), "", fields!charge.value) 

it should have worked otherwise can try fields!ticket.value == "" or fields!ticket.value.tostring() == ""


Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -