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 |
|
lekshmisp1982
Starting Member
2 Posts |
 Posted - 2007-03-21 : 13:40:18
|
hi all,In my report I want to make certain parameters to depend on the previous parameters. I think we can use those as cascading parameters. How to make a parameter a cascading parameter? and how to use those cascading parameter ? It would be nice of you if you can help me.Thanking you,Lekshmi  |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
|
|
lekshmisp1982
Starting Member
2 Posts |
Posted - 2007-03-21 : 17:27:36
|
| hi,Thanks for your immediate reply. But my question is whether we can use non queried parameter for cascading parameters.Actually in my application, we are getting the parameter values from a .net interface, not from a query.Is it possible to use cascading params in such situation? Then how?Thanks,Lekshmi |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2007-03-21 : 23:29:54
|
| Hi leksh. What you mean by cascading parameters? a Multi-value parameters? If so, yes it is possible.-Ron- |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-22 : 13:03:22
|
| You should be able to use a data processing extension (is that already what you are doing to get the data?) with cascading parameters.http://msdn2.microsoft.com/en-us/library/ms159219.aspx |
|
|
|
|
|
|
Cascading parameters