Optional Parameters? -- sql server reporting services

gte401e
2/28/2006 1:43:02 PM

Hi,
Example. I have two searchable parameters in my report. (Skills) and
(Last Name). I would like to have the choice of searching by either one
or both parameters. When I just put in a value for (Skills), error
comes up "need to enter value for (Last Name)". In the report
parameters setup box, I have tried and set it to "allow null values"
but to no avail. What am I missing?
Any help would be greatly appreciated.
Thanks

daw
2/28/2006 2:58:27 PM

Did you include something like this in your WHERE statement:

(LastName=@LastName OR @LastName IS NULL) AND (Skills=@Skills OR @Skills IS
NULL)

[quoted text, click to view]

minority
2/28/2006 4:37:22 PM

how about setting the "allow blank values" ?

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 about sql server reporting services

sql server reporting services : Optional Parameters?