Is nested DataSets possible in SSRS 2005?

Is it possible to have an outer table mapped to a dataset and use another table insi开发者_开发问答de the outer table which maps to a second dataset,where the second dataset should take the feild value from the first dataset(as parameter) to pull data?

Please comment

Thanks in advance, San

---

You should be able to do this with a subreport. Pass in a parameter to use as a filter. If you're using a filter rather than a query parameter, it should be able to use the same Intermediate Report (ie, RDL + Data) for each subreport, thereby achieving your goal.

---

It's not possible. Reporting Services doesn't support multiple datasets. You'll need to get creative with your SQL to create a single dataset of all data.