Default Value for a Queried Parameter

I have created a report parameter with a query for the list of available
values. This works well and you are able to see the values and select the
one you want and see the correct report lines. When I try to assign a
not-queried value to the default value the report preview acts like there is
nothing in the default value and you have to select the value from the drop
down list. I have made the default value entered is the correct case and
spelling. Any ideas?Have you tried using both the Lable and the value for the parameter?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pl" <pl@.discussions.microsoft.com> wrote in message
news:F849BD60-1588-49D2-8727-083DDA5F7A56@.microsoft.com...
>I have created a report parameter with a query for the list of available
> values. This works well and you are able to see the values and select the
> one you want and see the correct report lines. When I try to assign a
> not-queried value to the default value the report preview acts like there
> is
> nothing in the default value and you have to select the value from the
> drop
> down list. I have made the default value entered is the correct case and
> spelling. Any ideas?