none
Reportin Services - Calculate the average value of a column, when placed on top of the report. RRS feed

  • Pregunta

  • In Reporting Services, I mustaddinthetop of the reportthe average of thevalues foundin a column.Butwhen the reporthas more than onesheet, the averageonly whatis calculatingper sheet, soon each sheetwherethe average valueappearsto show adifferent value, whichis incorrect.

    So Iask for your supportformeas I dotoindicatethat the average valueoftheindependentcolumnofthe number of sheetshaving thereportis calculated.

    Thks

    Liliana

    martes, 12 de mayo de 2015 17:45

Respuestas

  • Hello,

    If u use the page header you must use Variables from:

    Report-> Report Properties-> Variables-> Add.

    Try this:

    Name: AverColumn
    Value: =Avg(Fields!ColumnName.Value, "DataSet1")
    
    You must call:
    =Variables!AverColumn.Value

    Regards!


    Ayacucho - Perú
    Recuerda si mi solución atiende tu consulta por favor márcala como útil y como respuesta.

    http://litigiouslobo.blogspot.com/
    El Blog de Herbert Mendoza

    jueves, 11 de junio de 2015 14:59