Advice Sought

edited January 2013 in End User

I have various project budgets in cumulative monthly values which I want to
show on graphs to compare budget with actuals,

Month, Labour , Sub Contract, Materials, Total Cum.
1 50 300 0 350
2 250 550 1000 1800
3 450 700 2000 3150

I have a detail table with monthly spend but these are values for the month
(- not cumulative)

Month, Labour , Sub Contract, Materials, Total Spend This Month
1 45 350 200 595
2 275 500 800 1575

Can you give me any pointers as to how I may (within Report Builder)
calculate the cumulative values at the time of the report or would I be
better adding some pre processing to calculate the values before I draw the

Hope this makes sense.

Thanks in advance for your assistance.

Philip L Jackson


  • edited January 2013
    To show the values in charts I would try building a summary query/dataset
    that contains the values. When you create a chart it can have series that
    connect to the datapipeline and field value. Based on your description I
    think doing more data processing will greatly simplify the report layout.

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.