How can I get rid of this blank spaces in my report

[trishita]

I have also attached my qvw for reference

[Anonymous · Accepted solution]

do you want to get rid of the complete row if column Difference Log contains spaces?

like this?

Then you Need to assign null values for this column:

if (len([Difference Log vs Survey])=0,null(),[Difference Log vs Survey])

in the other colums like flag you also Need to assign null if the column Difference Log is null like

if (len([Difference Log vs Survey])=0,null(),
   if (isnull(SOUNDING_START_DATE),1,0))

fürthermore you need  to suppress Zero values for all dimensions

Sorry, I cannot upload your qvw!

[trishita]

Yes I want to delete the records which have no value for olumn Difference Log..Ok let me check what you have done