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 |
|
ilaughforu
Starting Member
3 Posts |
 Posted - 2009-11-25 : 08:54:48
|
| Hi, I am new to ssrs.I have a parameter with two choices (y/N)if Yes, another paramter should display a list of student depending upon 1st SQL statements. IF no, it should fill the parameter using diffenrent set of SQL. The choice of 1st affects only (which SQL to run)and the parameter is not used in query.. Please helpI am using SSRS 2008 |
|
|
DietSquirt
Starting Member
7 Posts |
Posted - 2009-11-25 : 11:14:02
|
| Good morning ilaughforu, I'm not on SSRS 2008 but in SSRS2005 this is a cascading parameter. I find them very useful and easy to set up once you know how. Here's a link to Microsoft's Books Online for 2008 describing the technique. When I was learning SSRS 2005 I found Books Online most helpful.http://msdn.microsoft.com/en-us/library/aa337169.aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-28 : 02:21:56
|
| also i dont think you can dynamically change the resultset of dataset for parameter. you need to use two different parameters to get the value and make them cascading to first param with y/n value |
|
|
|
|
|
|
SSRS different SQL