We have a need to show the Total Budget vs. Total Actuals on projects. I thought there would be an OOB Database View since I figured this was a pretty common use case, but I was unable to fine one to help.
I’m curious as to if/how folks using Project are reporting on Project Buget vs. Actual.
I created a Database View taking the pm_project table and joining it to the cost_plan table where the pm_project.task = cost_plan.task (this gives me a view of the budget). In the same Database View I joined pm_project to the fm_expense_line table the pm_project.task = fm_expense_line.task (this gives me a view of the actuals).
When running reports against this Database View, I am able to see all of the budget cost (in yellow below). But, when I pull in the expense lines (I only have one expense on this project so far) the report is repeating the same expense line five times, one once for each cost plan.
Is there some adjustment I can make to the Database View that ensures the report only list the software expense line once?
Any help or suggestions are greatly appreciated.
Thanks,
j
