How to check NULL value in RDLC

Question

1.00/5 (2 votes)

See more:

C#

Hi,

How to check NULL value in RDLC report?

Posted 15-Feb-11 0:13am

Rajni from delhi

Updated 17-Sep-19 7:19am

Sandeep Mewara

v2

Add a Solution

Comments

rohit24c 13-Jun-12 8:12am

i want to check for dataset if it is empty .
please help

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-02-15T00:16:00

Solution 1

Try:

VB

iif(Fields!ABC.Value Is Nothing, "value is NULL", "value is not NULL")

UPDATE:
Just for your reference and confirmation that what I suggested, it works:http://msdn.microsoft.com/en-us/library/ms157328%28v=sql.90%29.aspx[^]
Check 'Decision functions' part.

Posted 15-Feb-11 0:16am

Sandeep Mewara

Updated 15-Feb-11 19:23pm

v5

Comments

Rajni from delhi 16-Feb-11 0:37am

Not able to achieve,still getting #ERROR

Pratik Bhuva 31-Dec-13 1:47am

Thanks Sandeep

Sandeep Mewara 16-Feb-11 1:13am

What I suggested was for a field that has a defined dataset. Did you gave that?

Tell me what was your expression and if a dataset was defined for the base control or not.

[no name] 16-Feb-11 1:24am

What Error?

Sandeep Mewara 16-Feb-11 1:58am

In SSRS if there is a mistake in expression you just see #Error. :)

Sandeep Mewara 16-Feb-11 2:00am

Dude, just noticed that you revised my answer.

Now, it clearly looks like you don't have any idea of SSRS or the answer I gave.
It's IIF that is used and correct - was intentional. It would not be 'IF'

Please avoid updates like these if you are not sure.

rohit24c 13-Jun-12 8:17am

Yeah u rite Sandeep!! i waqnt to check for a dataset if that is empty then i dnt want to display Table in rdlc based on condition.

Sandeep Mewara 16-Feb-11 1:15am

Updated my answer.

Rajni from delhi 16-Feb-11 2:12am

ok.. m snding u the expression which m using ....
=IIF(Fields!NonTechHours.Value is Nothing ,"Raj",(IIF(Right(Fields!NonTechHours.Value,InStr(Fields!NonTechHours.Value,"."))>0,Fields!NonTechHours.Value,Left(Fields!NonTechHours.Value,InStr(Fields!NonTechHours.Value,".")-1))))

Sandeep Mewara 16-Feb-11 2:32am

See, the error is here:
Left(Fields!NonTechHours.Value,InStr(Fields!NonTechHours.Value,".")-1)

When there is no '.' in the value, InStr(Fields!NonTechHours.Value,".") would return ZERO. And thus your expression for InStr(Fields!NonTechHours.Value,".")-1 is -1
Now, you try to do something like:
Left(Fields!NonTechHours.Value,-1)

hence the error. There is no -1 as valid value for getting number of characters.

Rajni from delhi 16-Feb-11 4:21am

Act.,my values contain the double value like 16.52.so upper syntax is correct.only in case of null value,that #ERROR Poblem comes

Sandeep Mewara 16-Feb-11 5:45am

I am not sure what you mean by it. Assuming you are 200% sure that what I told is not the reason and some issue with 'Is Nothing' then you can try one more thing to check/verify:
Do something like:
=IIF(Len(Fields!NonTechHours.Value)>0,"Raj","Sandeep")

Rajni from delhi 16-Feb-11 5:50am

it's a problem of nested iif.Is Nothing is ok . how can i write in another way ..plz help

Sandeep Mewara 16-Feb-11 6:01am

I already said the issue. I have written much more complex experssions and nesteds iifs. They work.

Move stepwise, try without RIGHT and LEFt and see how it goes. I dont have data or cannot see your system, you can. surely somewhere its failing and you need to find which statement is the reason.

How to check NULL value in RDLC

1 solution

Solution 1

Add your solution here

Preview 0

How to check NULL value in RDLC

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us