Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have another req... as i have null values at DB level...i would like to get the null records count at report level..
anybody has done earlier on this?
Hi,
you can use the NullCount function, or another option is to transform your nulls in the script to real data 'Null' for example so they are selectable and easier to investigate
eg if(isnull([Field 1]),'Null',[Field 1]) As [Field 1]
hope that helps
Joe
Have a look at NullCount() as well.