Hi We are using SSRS 2005. My requirement is like this: I have list control which is grouped on checkNumber. This list control has 4 tables. First table to show Title and column Headers. 2, 3, 4th table show status of transaction across various systems. I need to show total amount of Sys3 (table 3) in table 1 title. I am not sure how to do this. Report looks like this: List Control Table1: Transactions for Check Number:1234 Amount:5 (4 + 1) ID CheckNumber Amount Bank City Table2: Sys1 Transactions 11 4 ABC Austin 12 1 ABB Houston Table3: Sys2 Transactions 11 4 ABC Austin 12 1 ABB Houston Table4: Sys3 Transactions 11 1234 4 ABC Austin 12 1234 1 ABB Houston Sys3 will always have data. That is the origin. The transactions may not have made to sys1. In that case table1 will not have data. So, I need to sum on table3 (sys3) and show in table1 title. I don't know how to do that. I appreciate your response. Thanks, Spunny

Spunny, could you use the same dataset for table1 that you use for table4(sys3)? Group by check number and use =sum(fields!amount.value)-Report Writer 'SSRS User'

Thanks for response (SSRS USer). I can try that and see if it works. Thanks, Spunny

SSRS User, I used same dataset for table1. Can you please tell me where to do =sum(fields!amount.value). I only have table headers for title and another table header for column headers. Spunny

Spunny, Right click on table1 Select Add group. GroupOn expression, select checknumber. This will add a row to your table on the far left of the row their should be a 1. Now place the expression in a group field that lines up with where you want it. -Report Writer 'SSRS User'

SSRS User, Thanks for your response. I got totals from database and showing it in table header. Spunny