<div>
There is not a way to combine datasets within SSRS ... this would have to be done in a stored procedure, view or embeded SQL <i>(assuming that you have to reference dataset2 with a value in dataset 1)</i>
</div>


There is not a way to combine datasets within SSRS ... this would have to be done in a stored procedure, view or embeded SQL (assuming that you have to reference dataset2 with a value in dataset 1)

<div>
Actually you can use 2 or more datasets with SQL Server R2 and the new lookup functions. 
</div>


Actually you can use 2 or more datasets with SQL Server R2 and the new lookup functions.

<div>
<div class="content wysiwyg-content">
I have 2 datasets in my report. I would like to use DataSet2 to retrieve my details. Is there a way to do this? I will be using the same parameters to retrieve the data from DataSet1 and DataSet2. The data is very different so I cannot combine the datasets. For example:<br />
<br />
Col1 &nbsp; Col2 &nbsp;Col3<br />
<br />
If I click or rather expand Col3 I will be calling Dataset2 and retrieving the data based on Col3 as a parameter to dataset.<br />
<br />

</div>
</div>


I have 2 datasets in my report. I would like to use DataSet2 to retrieve my details. Is there a way to do this? I will be using the same parameters to retrieve the data from DataSet1 and DataSet2. The data is very different so I cannot combine the datasets. For example:

Col1   Col2  Col3

If I click or rather expand Col3 I will be calling Dataset2 and retrieving the data based on Col3 as a parameter to dataset.



SSRS 2008 R2 - Drill Down

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.