Grouping to eliminate null

[member27]

Hi all, Iam using Sql reporting services .iam having a field Invoicereq in one table.I want to group only the invoicereq="y" and get the result.. I have given the group field as invoicereq="y" in reporting services and got the result but i am getting a null value along with it . (totally only one row but the result produce is 2 rows (one row null)) how to eliminate nuull values? in where condition i cant use the invoicereq="y" option because i want all th rows from tat table but group tat separate can anyone help me?

[Ennis Ray Lynch Jr]

Exclude the null records from your query using where table.column is not null Another option, if you want the nulls returned is isnull(table.column, 'null') To which you could then report on.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.