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 |
|
hypo
Starting Member
8 Posts |
 Posted - 2006-04-10 : 11:13:35
|
| I have four parameters for my report: StartDate, EndDate, TankID (the ID of a thank going from V01 to V20 and from S01 to S20) and Site (the location of the tanks, for example: the V-tanks are in Belgium (BE) and the S-tanks are in Spain (SP))The thing I want to do is: If I set parameter "Site" to "Belgium" then only the tanks in belgium will be shown as values in the dropdown of the "TankID" parameter. If site = Spain, only spanish tanks will be shown in tankid parameter dropdown box.I tried adding a new dataset which has as default value the parameter of the "Site". Also tried some other stuff but the only thing i get is this error:Error 4 [rsInvalidReportParameterDependency]The report parameter ‘BLABLA’ has a DefaultValue or a ValidValue that depends on the report parameter “BLEBLE”. Forward dependencies are not valid. So the thing I want to use are parameters that depend on eachother. If anyone made that possible, please let me know how!GreetsWim |
|
|
hypo
Starting Member
8 Posts |
Posted - 2006-04-11 : 03:55:37
|
| On an other forum I had a successfull response:Just Change the order of the report parametersi:e if Changing ParaA updates ParaB Drop-down values, then place ParaA before ParaB |
 |
|
|
|
|
|
Dependent Report Parameters Help