I'm trying to modify an existing report that is currently using a single dataset. I have two additional sets of data that I need to add to the report that is completely different from the current report. These sets of data will have detail lines and totals. I need to use these totals in the current report. The current report is an invoice report. It groups its data on an invoice number column. In the group footer is an invoice total. The first additional set is a list of overpayments. This set of data will have a total of the amount column and that amount should be subtracted from the current invoice report's invoice amount. The second additional set is a list of underpayments. This set of data will have a total of the amount column for its data and that total amount should be subtracted from the current invoice report's invoice amount. Thus: Invoice Amount + Overpayments Total - Underpayments Total. I could easily add the overpayments and underpayments as two subreports but have read that it is not possible to use the subreports' data in the main report. I have read that adding additional datasets is the way to go but am not sure where to place the data. I've tried adding a row in the group footer of the main report for each additional dataset. When I add the data from the additional dataset, it adds the columns as =First or =Sum instead of just the column name. Any guidance you can provide would be welcome. Thank you

>>>When I add the data from the additional dataset, it adds the columns as =First or =Sum instead of just the column name. It is because you add the data set field to Text Box and not to the tablix. You can remove First/SUM and see how was it going.Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing

Hi There Thanks for your posting. There are two ways I would think you could achieve your requirement in SSRS 2005. You can combine you three dataset in one dataset inside your Stored procedure using temporary table and bind your dataset with the current table. If that is not what you after you can use separate table as Uri said inside your report for each dataset. Then you can use report items collection to take the sum of three table control in the bottom. So your final total might look like this expression Total Amount =Reportitems! InvoiceAmount.value + Reportitems!OverpaymentsTotal .value- Reportitems!UnderpaymentsTotal.value. You have to make sure that scope of all the three report items (Invoice Amount + Overpayments Total - Underpayments Total) must be same. If you have any question please do ask Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.