p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Reporting Services (http://p2p.wrox.com/forumdisplay.php?f=205)
-   -   Working with two data sources and dependencies par (http://p2p.wrox.com/showthread.php?t=50202)

roy_mm November 13th, 2006 05:15 AM

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,

roy_mm November 14th, 2006 02:27 AM

Problem solved.

It was all a metter of running order between the parameters :)


All times are GMT -4. The time now is 01:09 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.