How can remove a row from my report if the results is empty or a n

How can remove a row from my report if the results is empty or a null?
If i have a null value , then i get a white space row in report - this is
not looking good !
Can somebody help me, please !?
Thank you!victoras wrote:
> How can remove a row from my report if the results is empty or a null?
> If i have a null value , then i get a white space row in report - this is
> not looking good !
> Can somebody help me, please !?
You need to write your SQL query to exclude that row, something like:
SELECT col1, col2 ... FROM mytable WHERE col1 IS NOT NULL
Luke|||or just use an iif statement on the row which toggles the visibility.
click the row, go to properties and visibility. choose expression
type
=iif(fields!afield.value is system.dbnull.value or fields!afield.value = "",
true, false)
basically says if your field is null or an empty string then do not show
else do show. True means don't show and false means do show.
"Luke Plant" <luke@.mailinator.com> wrote in message
news:do8hgo$9vq$1$8302bc10@.news.demon.co.uk...
> victoras wrote:
>> How can remove a row from my report if the results is empty or a null?
>> If i have a null value , then i get a white space row in report - this is
>> not looking good !
>> Can somebody help me, please !?
> You need to write your SQL query to exclude that row, something like:
> SELECT col1, col2 ... FROM mytable WHERE col1 IS NOT NULL
> Luke