all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

parameter question


parameter question Brian L
11/10/2006 10:38:02 AM
sql server reporting services:
I'm passing a parameter to a SP in SSRS '05. The parameter values are derived
from a query that selects values based upon a group membership. What I need
to be able to do is add a value to the list so that a NULL is passed back so
that those values not belonging to the group are selected (think 'not in') .
I've tried the Null and Allow blank values on parameter tab but that does not
work. I altered by SP so that the where statements reads: WHERE GroupID is
RE: parameter question William
11/10/2006 2:08:02 PM
There is a <Allow null value> radio button on the parameter tab. Is that what
you are looking for?

[quoted text, click to view]
AddThis Social Bookmark Button