Make a list box not reqired.

I have a report that takes values from a list box to generate the report.
The list box gets its values from a table.
If the user does not coose anything from the list box and hits 'View Report'
It should be able to go and grab all data from the table.
How do I make RS do this?
I tried 'Allow Null Value' for that particular parameter, but it still does
not work.
Anyone knows how to do this?You could grap the value "%" as a default value of this list box and put it
in your query, nevertheless if you are usinga stored procedure you can
handle the "empty" paramters, or you use the ISNULL(Parameter,Value) in your
query. Today it´s kind of a hack to do this ;-)
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"appu" <appu@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6E985A61-49F3-4AE1-B504-29E0954EA649@.microsoft.com...
>I have a report that takes values from a list box to generate the report.
> The list box gets its values from a table.
> If the user does not coose anything from the list box and hits 'View
> Report'
> It should be able to go and grab all data from the table.
> How do I make RS do this?
> I tried 'Allow Null Value' for that particular parameter, but it still
> does
> not work.
> Anyone knows how to do this?|||Thanks! I got the answer.
I can do a union of 'all', '<select all>'
when I grab my parameters from the table.
"Jens Sü�meyer" wrote:
> You could grap the value "%" as a default value of this list box and put it
> in your query, nevertheless if you are usinga stored procedure you can
> handle the "empty" paramters, or you use the ISNULL(Parameter,Value) in your
> query. Today it´s kind of a hack to do this ;-)
> HTH, Jens Sü�meyer.
> --
> http://www.sqlserver2005.de
> --
> "appu" <appu@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6E985A61-49F3-4AE1-B504-29E0954EA649@.microsoft.com...
> >I have a report that takes values from a list box to generate the report.
> > The list box gets its values from a table.
> > If the user does not coose anything from the list box and hits 'View
> > Report'
> > It should be able to go and grab all data from the table.
> > How do I make RS do this?
> > I tried 'Allow Null Value' for that particular parameter, but it still
> > does
> > not work.
> > Anyone knows how to do this?
>
>