all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Working with two data sources and dependencies parameters


Working with two data sources and dependencies parameters nicknack
11/13/2006 1:11:37 AM
sql server reporting services: Hello.
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,
Re: Working with two data sources and dependencies parameters nicknack
11/13/2006 10:23:21 PM
Problem solved.

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

Thanks.
nicknack =EB=FA=E1:
[quoted text, click to view]
AddThis Social Bookmark Button