I have site codes in my report and have prompt on site codes.
seems like in site code data item there is one value like blank or null. when I run the report I have to select the sitecode, in that prompt box I can see the blank row. I need to remove this blank row.
can you help me how to do this.
Thanks
Filter the query for prompt data item to remove the blank space such as:
[site code] is not NULL
and/or
[site code] <> '' (Two apostrophes)
Hi Suraj,
I filtered the query wiht below expression, but still I can see the balnk Site Code.
[Site Code] <>' ' and [Site Code] is not null
Quote from: d.laxmi on 07 Oct 2010 09:49:38 AM
Hi Suraj,
I filtered the query wiht below expression, but still I can see the balnk Site Code.
[Site Code] <>' ' and [Site Code] is not null
Your code is saying that site code should not be blank AND site code should not be null - not a likely scenario, I would think
Try first with [site code] <>''. Then try [site code] is not null and finally you can try [site code] <>'' OR [site code] is not null
HI Arsenal,
I tried below 3 ways still the I can see the blank Site Code row in the report.
[Site Code] <>' '
[Site Code] is not null
[Site Code] is not null or [Site Code] <>' '
Put the filter in the query for the Prompt, not the query that runs the report.