I have three tables. All three tables use the same data set but filter the dataset differently. How can I sum a box from the three tables into a textbox? Thanks.

Hi, I assume that data is not repeated among any of three tables. So you can use following expression to display sum: =Sum(Fields!FielName.Value, "DatasetName") Thanks

That's close, but because the tables are filtered and not the data set, that gives me the sum of the dataset and not the three tables. I'm returning a dataset with several thousand rows but only a few dozen meet the filter criteria for the tables.

Hmm.. Give it another try... Use the following expression instead. =Cdbl(ReportItems( "textboxname1").Value) + Cdbl(ReportItems("textboxname2").Value) + Cdbl(ReportItems("textboxname3").Value) Use the names of textboxes that display the value of SUM in each table, if there aren't any then create them and hide them if you don't need to display on your report. Make sure to write correct textbox name as it is case sensitive in the expression. Hope it will resolve the issue now. Thanks

Actually that doesn't generate an error message but also doesn't add up correctly.

Hi John, The solution provided by muhammadsalmanx should be workable. Why doesn't add up on your report? Please describe it in more details, and provide the version info about your sql server reporting services here so that we could do the test on the same environment with yours. thanks, Jerry

I had my table set up incorrectly. It did, indeed, work when I fixed my tables.