Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zs
Starting Member
3 Posts |
 Posted - 2005-05-25 : 10:30:14
|
| How can we control visibility of report parameters ? E.G when we choose cities from country that has no states and we want to skip the state parameter? |
|
|
jhermiz
3564 Posts |
Posted - 2005-05-26 : 08:42:02
|
Huh ?I don't understand what you're asking.You don't have to necessairly fulfill the parameters request. A little bit of boolean and defaulting the parameter does the trick:...@YourParam varchar(15) = NULL --set the default...--more code here...WHERE(YourTable.YourField=@YourParam OR @YourParam IS NULL)....
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-31 : 17:22:51
|
| I see what you are trying to get at. I wish there's a way to hide the parameters base on certain criterias, but yes only workable way is what Jon stated. Don't know if there's any other workaround. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-31 : 19:27:07
|
| You can always create your own front-end web page to collect the parameters and then post the form to the report server to generate the report. That way you have full control of what the user sees while collecting parameters and can hide and display things at your will.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Report Parameters Visibility