Hiding Row When field is null

[#1]

Hi Folks,

i have a query.

is it possible to hide a full row if a column was null.if so kindly guide me

am using a table object.

kindly find the attached  image for reference, the highlighted columns in the image are null and i want to remove the entire row against that

kindly help us to overcome on this.

thanks in Advance..

With Regards

DeepaK Subramoniam

[Chanty4u]

try to create one feild in script

Trim([sale]) as [sale1]

[Chanty4u]

chk dis

Hide entire row if one expression is null

[mightyqlikers]

hi deepak,

take a straight table and use that field as dimension and supress when value is null in dimension tab of chart properties.

you will get it.

$@M.

[sunny_talwar]

Is this in a table box or straight table? If it is straight table, please provide information about your expressions and dimensions

[boorgura]

For Table box - you can set to OMIT the row in the 'presentation' tab of object properties.

[#7]

tried but not working for me..

thanks in Advance..

WITH Regards

Deepak Subramoniam

[#8]

tried that already

Thanks in Advance...

With regards

Deepak Subramoniam

[boorgura]

Can you please share a sample QVW?

Also - is it a NULL or just a '-' ?