Supress NullValue in List box

[#1]

Hi everyone,

I have an issue in my application. I have created a list Box for a Quarter. But it show an extra value Q,I dont understand why it is showing,I dont have any null date filed.So my question is,how to supress nullvalue in list box?

if any one have any idea please share your suggestion.

Thanks

Bhawna    

[MayilVahanan]

Hi

Try like this

Properties -> Presentation tab-> Supress null values

Edit:

Sorry, I thought in chart..

Load *,

'Q' & ceil(month(Datefield) / 3)

from tablename where Len(Trim(Datefield)) > 0 ;

[sushil353]

Hi,

You can use expression in listbox. to eliminate extra values.

HTH

Sushil

[#4]

But in list box there is no such option...

[avinashelite · Accepted solution]

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

or

if(isnull(filedname)=0,fildname)

[tresesco]

Try expression like:

=If(Len(Trim(YourField))>0,Field)

[qv_jagan]

Hi Bhawna,

Please attach the app in the discussion.

Thanks,

Jagan. V

[#8]

Thank you everyone....