View Single Post
  #1 (permalink)  
Old November 13th, 2006, 05:15 AM
roy_mm roy_mm is offline
Authorized User
Join Date: Aug 2006
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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,

Reply With Quote