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 |
|
ecomajor
Starting Member
12 Posts |
 Posted - 2009-03-09 : 11:29:35
|
| Hi,I am trying to do a report with cascading dynamic parameters. THe weird thing is that they dont seem to work unless I make my intermediate variables non hidden and non internal.For exampleI have a dataset that returns location information. The user picks a specific location on the dropdown which has a field which dictates the paycycle (bi weekly, weekly, monthly etc). I then take that paycycle id and feed that to a query that returns the proper dates based on the paycycle id. For some reason I cant get the dates query to refresh unless the paycycle id variable is visible on the report. Any ideas. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 04:58:56
|
| i think thats because paycycle parameter datset is dependent on location parameter. check if you'repassing location value as one of parameter for paycycle dataset |
 |
|
|
|
|
|
Cascading dynamic parameters