how to remove ? and null values in report ?

[#1]

how to remove  ?  and  null values  in  report ?

[ramasaisaksoft]

Hi Manoj,

           if u want remove "Null " values from a particular column ,you can do this in Script like below

Load sal,eno from fact_Reservation;

sql select * from fact_Reservation where eno<>'NULL';

or

sql select * from fact_Reservation where eno<>NULL;

please check like this may be it will helpful to u

[Anonymous]

Check on the suppress When Value is Null..

In Dimension

[ramasaisaksoft]

Hi Sreekanth ,

         i Hope u r asking in code.Any way thanks for u r reply.I hope u r a Telugu person am i wright?if yes reply to me

[ramasaisaksoft]

This  solution only applicable for Chart.

             But my solution in code is applicable for all sheet objects('Null'  values are filter in Listbox,Tables ....etc)

[vardhancse]

Hi,

If we want to remove null values from all the fields, then we should mention and condition in the where condition.

Is there any alternate for this.?

[#7]

s mail is  manojkumar27.m@gmail.com  in mumbai  present

[anbu1984]

In Sql

sql select * from fact_Reservation where eno Is Not NULL;