RS 2005 SP2 - Multivalue (Select All) I want to set it as Default

I am using a Reporting Services 2005 with the SP2.
I want to select as default (Select All) row on the multivalue dropdown
list, which is going to virtually select all my options on the dropdown list.
Is there any way to accomplish that?
Thanks a lot.On Oct 10, 10:17 am, Francisco Cruz <Francisco
C...@.discussions.microsoft.com> wrote:
> I am using a Reporting Services 2005 with the SP2.
> I want to select as default (Select All) row on the multivalue dropdown
> list, which is going to virtually select all my options on the dropdown list.
> Is there any way to accomplish that?
> Thanks a lot.
You should just be able to select 'Default values:' >> 'From query' as
part of the Report Parameters and set the Dataset and Value fields to
the same values as the 'Available values.' Also, make sure that the
Multi-value radio button is selected. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Oct 10, 10:17 am, Francisco Cruz <Francisco
> C...@.discussions.microsoft.com> wrote:
> > I am using a Reporting Services 2005 with the SP2.
> > I want to select as default (Select All) row on the multivalue dropdown
> > list, which is going to virtually select all my options on the dropdown list.
> > Is there any way to accomplish that?
> > Thanks a lot.
>
> You should just be able to select 'Default values:' >> 'From query' as
> part of the Report Parameters and set the Dataset and Value fields to
> the same values as the 'Available values.' Also, make sure that the
> Multi-value radio button is selected. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Thanks a lot Enrique,
It works great.
In other words, the Available Values Data Source must be used on the Default
Values as well.
This how I have it and it works, ***DepartmentDataSet*** is used twice
Report Parameters Window:
Properties
Name: pDepartment
Data Type: String
Prompt: Department
Multi Value: Check
Available Values
From Query:
Data Set: ***DepartmentDataSet***
Value Field: Department_Id
Label Field: Department_Name
Default Values
From Query:
Data Set: ***DepartmentDataSet***
Value Field: Department_Id