sql server reporting services: Optional filtering by parameter -- sql server reporting services

Optional filtering by parameter

Dmitry Duginov
10/31/2007 2:13:05 PM

sql server reporting services: Can anybody suggest the easy way to add an optional parameter to the report?

Example: Without this "feature" the report contains records for the groups
A, B, C, etc. I'd like to add the parameter "SingleGroup". By default it is
null and the report should work exactly as before. If I set the value to
"A", the report should only show records for group "A".

I tried couple of approaches, but they don't work. Any input would be
appreciated.

D.

Re: Optional filtering by parameter

Alain Quesnel
10/31/2007 3:13:10 PM

There is an example on how to do this in BOL. It's pretty straightforward.
Look for Dynamic Query in the tutorials section for Reporting Services.

--

Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com

[quoted text, click to view]

Re: Optional filtering by parameter

Dmitry Duginov
10/31/2007 3:53:49 PM

[quoted text, click to view]

Thank you! Somehow I overlooked that.

D,

[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.