Having one dataset reference another dataset

[mckenneyj]

Is this possible

Trying to get dsB to use results from dsA on same report

i.e. For dsB something like Select * from dsA



Thanks,
John McKenney
Work Hard... Play Harder

 

[andrea96]

I use subreports for situations like this.

 

[xlbo]

yup - don't think it is possible in SSRS - there is no linking between datasets - just objects. I tend to try to do as much as possible in the SQL query rather than have the report working doubletime...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[mckenneyj]

Thanks

Thanks,
John McKenney
Work Hard... Play Harder