parameter limiting

I have a few required parameters listed at the top of a report. I want to
make it where when one parameter is chosen in the drop down menu, the other
parameter(s) limit their choices accordingly. I can't seem to find a way to
do this though.
Any help would be great. Thanks.Use the first parameter in the SQL for the second
"scraejtp" wrote:
> I have a few required parameters listed at the top of a report. I want to
> make it where when one parameter is chosen in the drop down menu, the other
> parameter(s) limit their choices accordingly. I can't seem to find a way to
> do this though.
> Any help would be great. Thanks.
>|||Don't think I follow. This is at the top of a report, there are 4 parameters
they need to specify. I want it to somehow update the list of the other drop
down parameters when they choose one.
For example at the top of a report they will have a parameter "Automaker",
and it will have Ford, GM. Then another parameter at the top called "cars"
and it will contain neon, mustang, corvette, f150. When they pick Ford under
automatker, I want the other parameter drop down to only show the mustang and
f150 without going to a different report.
"Antoon" wrote:
> Use the first parameter in the SQL for the second
> "scraejtp" wrote:
> > I have a few required parameters listed at the top of a report. I want to
> > make it where when one parameter is chosen in the drop down menu, the other
> > parameter(s) limit their choices accordingly. I can't seem to find a way to
> > do this though.
> > Any help would be great. Thanks.
> >
> >|||Base the dependent parameters on queries. Then have the SQL for the query
use the report parameter value to define the list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> Don't think I follow. This is at the top of a report, there are 4
> parameters
> they need to specify. I want it to somehow update the list of the other
> drop
> down parameters when they choose one.
> For example at the top of a report they will have a parameter "Automaker",
> and it will have Ford, GM. Then another parameter at the top called "cars"
> and it will contain neon, mustang, corvette, f150. When they pick Ford
> under
> automatker, I want the other parameter drop down to only show the mustang
> and
> f150 without going to a different report.
> "Antoon" wrote:
>> Use the first parameter in the SQL for the second
>> "scraejtp" wrote:
>> > I have a few required parameters listed at the top of a report. I want
>> > to
>> > make it where when one parameter is chosen in the drop down menu, the
>> > other
>> > parameter(s) limit their choices accordingly. I can't seem to find a
>> > way to
>> > do this though.
>> > Any help would be great. Thanks.
>> >
>> >|||Got it. Thanks.
"Bruce L-C [MVP]" wrote:
> Base the dependent parameters on queries. Then have the SQL for the query
> use the report parameter value to define the list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > Don't think I follow. This is at the top of a report, there are 4
> > parameters
> > they need to specify. I want it to somehow update the list of the other
> > drop
> > down parameters when they choose one.
> >
> > For example at the top of a report they will have a parameter "Automaker",
> > and it will have Ford, GM. Then another parameter at the top called "cars"
> > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > under
> > automatker, I want the other parameter drop down to only show the mustang
> > and
> > f150 without going to a different report.
> >
> > "Antoon" wrote:
> >
> >> Use the first parameter in the SQL for the second
> >>
> >> "scraejtp" wrote:
> >>
> >> > I have a few required parameters listed at the top of a report. I want
> >> > to
> >> > make it where when one parameter is chosen in the drop down menu, the
> >> > other
> >> > parameter(s) limit their choices accordingly. I can't seem to find a
> >> > way to
> >> > do this though.
> >> > Any help would be great. Thanks.
> >> >
> >> >
>
>|||Also, I forgot to mention, it works completely in the preview without any
issues.
"scraejtp" wrote:
> Got it. Thanks.
> "Bruce L-C [MVP]" wrote:
> > Base the dependent parameters on queries. Then have the SQL for the query
> > use the report parameter value to define the list.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> > news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > > Don't think I follow. This is at the top of a report, there are 4
> > > parameters
> > > they need to specify. I want it to somehow update the list of the other
> > > drop
> > > down parameters when they choose one.
> > >
> > > For example at the top of a report they will have a parameter "Automaker",
> > > and it will have Ford, GM. Then another parameter at the top called "cars"
> > > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > > under
> > > automatker, I want the other parameter drop down to only show the mustang
> > > and
> > > f150 without going to a different report.
> > >
> > > "Antoon" wrote:
> > >
> > >> Use the first parameter in the SQL for the second
> > >>
> > >> "scraejtp" wrote:
> > >>
> > >> > I have a few required parameters listed at the top of a report. I want
> > >> > to
> > >> > make it where when one parameter is chosen in the drop down menu, the
> > >> > other
> > >> > parameter(s) limit their choices accordingly. I can't seem to find a
> > >> > way to
> > >> > do this though.
> > >> > Any help would be great. Thanks.
> > >> >
> > >> >
> >
> >
> >|||Ok, I got it to work, except for one small thing. Now when the screen opens
you have your choices like you should. If you chose a different parameter
than the one it opens with the list does not change accordingly. BUT if you
click anywhere on the screen first, and then change the parameter it will
change the list accordingly. And it only takes the one click and then you can
change the first parameter as many times as you like and it will change
accordingly. It is like it isn't updating until the screen is reselected. Any
insights?
"Bruce L-C [MVP]" wrote:
> Base the dependent parameters on queries. Then have the SQL for the query
> use the report parameter value to define the list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > Don't think I follow. This is at the top of a report, there are 4
> > parameters
> > they need to specify. I want it to somehow update the list of the other
> > drop
> > down parameters when they choose one.
> >
> > For example at the top of a report they will have a parameter "Automaker",
> > and it will have Ford, GM. Then another parameter at the top called "cars"
> > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > under
> > automatker, I want the other parameter drop down to only show the mustang
> > and
> > f150 without going to a different report.
> >
> > "Antoon" wrote:
> >
> >> Use the first parameter in the SQL for the second
> >>
> >> "scraejtp" wrote:
> >>
> >> > I have a few required parameters listed at the top of a report. I want
> >> > to
> >> > make it where when one parameter is chosen in the drop down menu, the
> >> > other
> >> > parameter(s) limit their choices accordingly. I can't seem to find a
> >> > way to
> >> > do this though.
> >> > Any help would be great. Thanks.
> >> >
> >> >
>
>