SQL Server Performance

Sum of Reportvalues

Discussion in 'SQL Server 2005 Reporting Services' started by Toni, May 21, 2006.

  1. Toni New Member

    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 Chaffin
    aka Toni
  2. smy New Member

    if your Datarows2_BudgetRent is from one of the dataset's fields, you can try this on the Top Level...

    =Sum(Fields!Datarows2_BudgetRent.Value, "Dataset_Of_Datarows2_BudgetRent")
  3. Toni New Member

    Unfortunatly it is normally a Sum of datarow3 and in the other method I am using it is a MAX statement of datarow3.

    I will work the logic, the answer lies somewhere in this mess I have created.

    Regards


    Toni Chaffin
    aka Toni

Share This Page