|
|
You're in the
sql server reporting services
group:parameter limiting
sql server reporting services:
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
[quoted text, click to view] "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. [quoted text, click to view] "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.
[quoted text, click to view] "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. > >> > > >> > > >
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 [quoted text, click to view] "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. [quoted text, click to view] "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? [quoted text, click to view] "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. > >> > > >> > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |