"Ryan Mcbee" wrote:

> I am using 2005, any ideas of where the select all option is?
> Thanks,
> Ryan
>
> "William" wrote:
>
> > If you are using the 2005 version, I believe that there is an all option
> > provided.
> >
> > Pre 2005, which I use, you need to supply the "ALL" value to your drop down
> > data source. If the drop down comes from a sql data source add a union for
> > the value. IE:
> >
> > SELECT user_id FROM Tbl_Name
> > UNION
> > SELECT 'ALL'
> >
> > Then you must test in your selection criteria as
> >
> > WHERE ...
> > AND (data.user = @UserParam or @UserParam = 'ALL')
> >
> >
> >
> > "Ryan McBee" wrote:
> >
> > > I entered a Parameter drop down for my report, but I do not have the option
> > > to select all when I go to generate my report. Any ideas on how to get the