Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Sum or ReportValues

Author  Topic  Tonic Starting Member 26 Posts Posted - 2006-05-22 : 02:47:29 I have a report which receives data from a stored procedure. This report contains a drill through capability of two levels. The problem I have is that the 1st level is showing a sum of all of the budget information that is being provided by the query. What I would like to do is set it so that it is along the following logic Top Level:- DataRow1_BudgetRent =Sum(ReportItems!Datarows2_BudgetRent.Value) Middle Level:- DataRow2_BudgetRent =MAX(Fields!budgeted_net_rent.Value) Bottom Level:- DataRow3_BudgetRent Nothing The problem I have is that the Middle level works fine, but I want the Top level to be a staright sum of the values that are displayed in middle level. One of the errors I get return is that the name 'Report' is not declared. Regards Toni C aka Talisa