I have the following problem: Two reports: 1 master and 1 child, with the following steps 1) The report master produce a result (a table, e.g.: 3 columns). 2) From master report, the report child is open 3) The child report is open with 1 parameter: this parameter (parameter 1) lists all the values in the columns (e.g.: column 1) from the result of the report master 4) Based on the filter selection (parameter 1), the report filters on the result on step 1 (it means to pass the resulting table from report master to child one on which applying the filter to) My probles are: Step3: How pass to the child report all values from a column in the master report? Step4: How to pass a result data from the report master to the report child? IMPORTANT: Same report may be open at the same time from different location, so in this case a database table is not possible to be used Any help will be very appreciated. Many Thanks

I think you have to use Actions.Check the link and let me know http://msdn.microsoft.com/en-us/library/ms159847.aspx

thanks, but Unfortunately I went through the page but provides info only to pass parameters but not the entire reporting result (I mean the entire dataset resut: the table produced by the master report). Any further help will be very appreciated.

Hi, If you want your master dataset in your child report, you can use a new dataset with your master report query. Using drill through action, you can pass the parameters and selected cell data from your Master report. I am not clear about your requirement of passing the entire dataset from Master to Child report. Can you provide more details of your requirement? MSBI Developer

I would like to avoid creating a the same dataset in the child report as the master report. The child report use the entire dataset result from the master and then analyzing data by filtering. A reason is to run the same query that takes long as for milion of row. A solution may be to create a table, but the problem is that in a multi_enviromnment client, running the same report from different client bad result will get because the table is unique and should be populated by several master report taht run at same time. Any contribution will appreciated Thank

Hi, You did not mentioned about your design senario, if I look into your requirement then below is a workaround to achieve it. Create three new parameters with are of multi-value and for those parameters as default values assign the dataset apporpiate column names. Now when passing to the subreport pass these new parameters. so that you can pass the total results. In the subreport using Split function to get the individual values. Hope its clear & helpful.... Pavan Kokkula Tata Consultancy Services.

Thanks for your info, This may be useful for some task. Where Could I put the Split function? Carry on my problem: to complete the report as planned (otherwise I will change way) I need to pass the entire result from the master report, just explained before to avoid to run again the same query.

Hi fasttrack, Based on your requirement, I think you should create a subreport with different dataset, on the subreport you should create a parameter to receive the value passing from the main report, then utilize this parameter to your dataset's query or filter. Before you design the subrpeort, I would recommend read this articles: 1. How to: Add a Subreport and Parameters (Reporting Services) http://msdn.microsoft.com/en-us/library/ms160348.aspx 2. How to: Add a Filter (Reporting Services) http://msdn.microsoft.com/en-us/library/ms156270.aspx If you have any question, please feel free to ask. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.