is it possible to import a value present in the column/table of a report to another report. The is just to avoid the creation of datasets again in the second report.

Hi, In Reporting Services 2008R2, we can use the new feature Shared Datasets to reuse one dataset in separate reports. A shared dataset provides a way to share a query to help provide a consistent set of data for multiple reports. For more information about Managing Shared Datasets, please see: http://msdn.microsoft.com/en-us/library/ee636147.aspx However, if you are not using Reporting Services 2008R2, in order to import a dataset from another report, please refer to the steps below. 1. Backup both source report and destination report. 2. In Business Intelligence Development Studio, right click the source report in the Solution Explore and select View Code. 3. Find the node <Datesets>, and then copy all text from <Datasets> to </Datasets>. 4. Right click the destination report in the Solution Explore and select View Code. 5. Paste the text copied text in the same position in the destination file. Then save the file. We can also copy the datasource in the same way. If there is an existing in the destination report, please configure the dataset to use the correct datasource. If anything unclear, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Thanks a lot Tony. Shall try it :)

Do we have to copy all the datasets or only the ones required from the source report?