Removing a - from a table.

[amars]

Hi all,

I am able to remove the "-" from a chart by going to the presentation tab & removing the "-" from  the Null Symbol text box. Now I wish to do the same for a Table box . How shoul I do that.? Please suggest. Thanks in advance.

Amar

[mike_garcia]

Go to Properties > Fields > Select your field and mark "Omit Rows Where Field is Null".

Mike

[#3]

Hi,

You can skipp blank in script it self. Take null as space in script.

isnull(field,' ')

[montubhardwaj]

You can filter it in the script as well:

Load a,b,c

From abc

where a<>'';