July 28, 2009 at 7:41 am
I have two report parameters populated via two different datasets respectively. The requirement is such that, on run-time, when i select a value of param1, the available values in param2 change. And again in the same running instance, when i select a value in param2, the available values in param1 change.
I'm able to achieve the first condition, i.e. changing the values of param2 depending on selection in param1. But, the second case i.e changing param1 values depending on param2 seems to be difficult to achieve.
The order of these parameters in the Report Parameters dialog box is, param1 and then param2. So, i don't have problems in getting the value of param1 first and depending on its value, change the param2 values. But, when i write the same logic for the second case, param1 doesn't get the values for param2, since param2 is the next in parameter order. And i keep getting an error .... Valid values of param1 depend on param2. Forward dependencies are not valid. And this error seems quite obvious due to the order of parameters.
I got to read some articles which mention about creating a separate dataset and referring param1 to that dataset. This dataset shouldn't have any parameters and should only fetch the available values. Also, some of solutions read about creating a dummy parameter blah blah blah...
But it didn't actually serve my purpose and was not understandable. Could anyone please help me out in getting rid off this circular reference? This is urgent!
July 28, 2009 at 9:27 am
I'm not sure I understand why you need to this? Essentially you are saying that there is a parent-child relationship between parameter1 and parameter2, so how would changing a value in parameter2 make the parameter1 values change since all the values in parameter2 are directly related to the selected value in parameter1.
For example: parameter1 is a set of orders (1,2,3,4,5) and parameter2 is a set of order lines(1:1, 1:2, 2:1, 3:1, etc...) So when you select order 1, you get a list of the lines attached to order 1. Selecting line 2 would not change the order to which the lines apply.
Can you post some sample data to visually demonstrate the what and why of your problem?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply