Blank row in value prompt

[jd]

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

[Suraj]

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)

[jd]

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

[Arsenal]

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

[jd]

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] <>' '

[cognostechie]

Put the filter in the query for the Prompt, not the query that runs the report.