Dependent report parameters help

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!

Greets
Wim

See this link on msdn:

http://msdn2.microsoft.com/en-us/library/ms155917.aspx

Scroll all the way down to the very last section entitled "Cascading Parameters". I believe this is what you are trying to do. Let me know if I can help further.

|||

Just Change the order of the report parameters

i:e if Changing ParaA updates ParaB Drop-down values, then place ParaA before ParaB

|||

I haven't read the msdn page yet, I just started with the second option (changing parameter order) to see if that works and IT DOES!!!!

You just have to place the depentent parameter below the one it depends on and all works fine! (so in my case I placed the tank parameter below the site parameter)

Thanks for your help
greets

Wim

|||

Hello

Can we make Multivalue parameters to play for cascading parameters. I am trying with different combinations of using query parameters and Report parameters.

Can any body help me?

Regards

Raj Deep.A