sql server reporting services: Dataset -- sql server reporting services

Dataset

Jack Nielsen
9/21/2005 11:25:27 PM

sql server reporting services: When I make a dataset as parameter how can I make an ALL value which
doesn't
select the single values but all values instead.

Like

Month: all, jan, feb, etc.

when I choose all it's supposed to ignore it in the where clause, I tried
with case but it didn't work out, any clues on this one ?

Jack

--
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at fÃ¥ 45077 spam-mails.
Betalende brugere fÃ¥r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk

RE: Dataset

Koen
9/22/2005 2:19:01 AM

give it a null value and adapt your query so it says : "SELECT .... WHERE
month LIKE '@parameterMonth'"

[quoted text, click to view]

RE: Dataset

Ben Sullins
9/22/2005 9:47:06 AM

Similarly...

"Select * from mytable where (col1 = @parm or @parm is null)"

This can also be used w/ multiple parms

"Select * from mytable where (col1 = @parm or @parm is null) and (col2 =
@parm2 or @parm2 is null)"

I've used this method in many queries/procs to avoid using dynamic sql...

Cheers!
--
Ben Sullins

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.