sql server reporting services: SQL If Statement -- sql server reporting services

SQL If Statement

SAcanuck
3/11/2005 4:01:02 PM

sql server reporting services:

How would I write a sql query in the criteria column of the following
table/field eg. Employee.Name

If (@pmGroupBy = 6) then (Employee.Name = @pmEmloyee) else (Employee.Name =
*)

Re: SQL If Statement

Mary Bray [MVP]
3/12/2005 1:25:48 PM

try some thing like:

select blah, blah,
'Name'=case @pmGroupBy when 6 then @pmEmloyee else Employee.Name end,
blah
from sometable

--

Mary Bray [SQL Server MVP]
Please reply only to newsgroups

[quoted text, click to view]