Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to remove ? and null values in report ?
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
Check on the suppress When Value is Null..
In Dimension
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
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)
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.?
s mail is manojkumar27.m@gmail.com in mumbai present
In Sql
sql select * from fact_Reservation where eno Is Not NULL;