Rolling Average in Report Layout


  • Hello,

    New to vsb.net...also new to the coding world.  Go easy on me! 

    I have a report that calculates call center rep statistics over a specific 3 month period.  This timeframe is called "Transition."  I have the columns that provide the data values for each month for each statistic.  I am trying to add a column that provides the cumulative average of these statistics at any given time when the report is generated during Transition. 

    I can insert an expression that calculates the average over a 3 month period.  That's no problem.  The part I'm having trouble with is an expression that calculates the cumulative average if the report is generated prior to the end of the 3 month period.  If the report is generated after only 2 months in transition...I need the average of the data values for only 2 months, not 3.  How can I create this dynamic expression in the expression dialog box for vsb.net 2005?

    I appreciate any assistance you can provide. 


    Wednesday, June 27, 2012 2:40 AM

All replies

  • Hi Ciw916,

    Welcome to the MSDN forum.

    Would you like to share what report control you used?

    Have a nice day!

    Mark Liu-lxf [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, June 28, 2012 3:30 AM