Prev: Sometimes charts are not rendered in a good way
Next: Large multi-select list box - performance
From: newdevu on 19 May 2010 15:25
Thanks for solution...

"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(a)discussions.microsoft.com> wrote in message
> news:3A6CE6FD-1BEA-459C-B223-B9B3952782CE(a)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(a)discussions.microsoft.com> wrote in message
> >> news:89935558-78A2-441D-A410-A7C51E056189(a)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)
> >>
> >>
> >>
>
>
>
 | 
Pages: 1
Prev: Sometimes charts are not rendered in a good way
Next: Large multi-select list box - performance