Parameters from Dropdownlist

In SSRS 2000 how can I have the parameter filled in the drop downlist from
the database table? My query is: I want the city field filled in from the
column. Thanks in advance.
SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
FROM MR_MEMBER_1
WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)Go into you parameter and check the box that says "From Query" then choose
the dataset you want to use and then choose the from the value field list
the field that you want to run the parameter off of! Hope that helps...
"Shan Afzal" <Shan Afzal@.discussions.microsoft.com> wrote in message
news:89935558-78A2-441D-A410-A7C51E056189@.microsoft.com...
> In SSRS 2000 how can I have the parameter filled in the drop downlist from
> the database table? My query is: I want the city field filled in from
> the
> column. Thanks in advance.
> SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
> FROM MR_MEMBER_1
> WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)|||Go into you parameter and check the box that says "From Query" then choose
the dataset you want to use and then choose the from the value field list
the field that you want to run the parameter off of! Hope that helps...
"Shan Afzal" <Shan Afzal@.discussions.microsoft.com> wrote in message
news:89935558-78A2-441D-A410-A7C51E056189@.microsoft.com...
> In SSRS 2000 how can I have the parameter filled in the drop downlist from
> the database table? My query is: I want the city field filled in from
> the
> column. Thanks in advance.
> SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
> FROM MR_MEMBER_1
> WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)|||Ben, It gives me the follwoing error when I do what you explained.
The report parameter â'CITYâ' has a DefaultValue or a ValidValue that depends
on the report parameter â'CITYâ'. Forward dependencies are not valid.
Build complete -- 1 errors, 0 warnings
Thanks
"Ben Watts" wrote:
> Go into you parameter and check the box that says "From Query" then choose
> the dataset you want to use and then choose the from the value field list
> the field that you want to run the parameter off of! Hope that helps...
> "Shan Afzal" <Shan Afzal@.discussions.microsoft.com> wrote in message
> news:89935558-78A2-441D-A410-A7C51E056189@.microsoft.com...
> > In SSRS 2000 how can I have the parameter filled in the drop downlist from
> > the database table? My query is: I want the city field filled in from
> > the
> > column. Thanks in advance.
> >
> > SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
> > FROM MR_MEMBER_1
> > WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)
>
>|||You could try and create a different dataset that is exactly the same as
your current one and name it city parameter or something like that. Then
inside your report parameter for the values, change the dataset to the one
you just created and choose the field from that! Let me know.....
"Shan Afzal" <ShanAfzal@.discussions.microsoft.com> wrote in message
news:3A6CE6FD-1BEA-459C-B223-B9B3952782CE@.microsoft.com...
> Ben, It gives me the follwoing error when I do what you explained.
> The report parameter 'CITY' has a DefaultValue or a ValidValue that
> depends
> on the report parameter "CITY". Forward dependencies are not valid.
> Build complete -- 1 errors, 0 warnings
> Thanks
> "Ben Watts" wrote:
>> Go into you parameter and check the box that says "From Query" then
>> choose
>> the dataset you want to use and then choose the from the value field list
>> the field that you want to run the parameter off of! Hope that helps...
>> "Shan Afzal" <Shan Afzal@.discussions.microsoft.com> wrote in message
>> news:89935558-78A2-441D-A410-A7C51E056189@.microsoft.com...
>> > In SSRS 2000 how can I have the parameter filled in the drop downlist
>> > from
>> > the database table? My query is: I want the city field filled in from
>> > the
>> > column. Thanks in advance.
>> >
>> > SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
>> > FROM MR_MEMBER_1
>> > WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)
>>|||Got it Ben. Work like a champ. Thanks for your help.
"Ben Watts" wrote:
> You could try and create a different dataset that is exactly the same as
> your current one and name it city parameter or something like that. Then
> inside your report parameter for the values, change the dataset to the one
> you just created and choose the field from that! Let me know.....
> "Shan Afzal" <ShanAfzal@.discussions.microsoft.com> wrote in message
> news:3A6CE6FD-1BEA-459C-B223-B9B3952782CE@.microsoft.com...
> > Ben, It gives me the follwoing error when I do what you explained.
> >
> > The report parameter 'CITY' has a DefaultValue or a ValidValue that
> > depends
> > on the report parameter "CITY". Forward dependencies are not valid.
> > Build complete -- 1 errors, 0 warnings
> >
> > Thanks
> >
> > "Ben Watts" wrote:
> >
> >> Go into you parameter and check the box that says "From Query" then
> >> choose
> >> the dataset you want to use and then choose the from the value field list
> >> the field that you want to run the parameter off of! Hope that helps...
> >>
> >> "Shan Afzal" <Shan Afzal@.discussions.microsoft.com> wrote in message
> >> news:89935558-78A2-441D-A410-A7C51E056189@.microsoft.com...
> >> > In SSRS 2000 how can I have the parameter filled in the drop downlist
> >> > from
> >> > the database table? My query is: I want the city field filled in from
> >> > the
> >> > column. Thanks in advance.
> >> >
> >> > SELECT FNAME, LNAME, .EMAIL, .PHONE_NBR, CITY
> >> > FROM MR_MEMBER_1
> >> > WHERE (MEMBER_STATUS = 'A') AND (CITY = @.CITY)
> >>
> >>
> >>
>
>