Working with two data sources and dependencies par
This is a real hard nut to crack :)
I'm trying to do the following:
I have one dataSource name "dSource1" and second named "dSource2".
I have a report with one dataSet base on dSource1 and one dataSet base on dSource2.
Now, I want that the second dataSet will return a list of numbers and for the first dataSet to use those number in a query.
(example: second dataSet is "select num from t1" and the first dataSet is "select * from t2 where nums in (@allNums)".
and of course that @allNums should be the values returned from the second dataSet.
Whan I tried to set the @allNums parameter to get his default values from the query of the second dataSet I got the error that say "forward dependencies are not valid".
Whice mean that this thing can not be done :(
Is there any other way of doing this?
Thanks in advance,