Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Advice Sought

edited January 2013 in End User
Hi

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
report?

Hope this makes sense.

Thanks in advance for your assistance.

Philip L Jackson

Comments

  • 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
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.