Hi, I have 2 datasets that are computing totals, im displaying these in a single row in my report, how to i compute the sum of these totals. Regards Rebekah

You can do this by adding the dataset name to the field. For example: =(Field!<name>.Value, "Dataset1") + (Field!<name>.Value, "Dataset2")

Hi, If you are using ssrs 2008 R2, you can use lookupset, lookup or multilookup functions. For more details kindly have a look below link http://prologika.com/CS/blogs/blog/archive/2009/08/12/reporting-services-lookup-functions.aspx- Chintak (My Blog)