Re: Export Budget Report

Thanks for the information. What I did was just make my export map to Excel
and cut it up. This is just one more thing that MS missed the mark on in
Project.

"John" <mjensen@xxxxxxxxxxxx> wrote in message
news:mjensen-C5BB3A.17190604062006@xxxxxxxxxxxxxxxxxxxxxxx
In article <uBkxcNCiGHA.1272@xxxxxxxxxxxxxxxxxxxx>,
"Allen" <almecum@xxxxxxx> wrote:

Hi all,
I want to export the budget report into Excel both are 2003 versions. I
have
created a project and assigned all of the cost for each task and now I
want
to produce a budget that I can send out or use in a ppt. The only thing I
see with the reports is the ability to print them out.

Thanks
Allen

Allen,
You are correct, the built-in reports cannot be exported or saved to
another application. However, in the case of the Budget report all you
need to do is to export the same data. Here is the basic process:

a. To get all the field names that appear as columns in the Budget
report, go to View/Table/More Tables. Select the Cost view table from
the More Tables selection list and hit "Edit". Make a note of the field
names.
b. To export that data, go to File/Save As and select Microsoft Excel
Workbook in the "Save as type" selection box at the bottom of the Save
As window. Hit "Save" - the Export Wizard will appear.
c. Follow the steps in the wizard and you should be all set. You can
either build you own export map based on the fields gathered in step "a"
above, or you may find the built-in "Cost data by task" map will give
you what you need.

Hope this helps.
John
Project MVP


.

Relevant Pages

  • Re: Export Budget Report
    ... I want to export the budget report into Excel both are 2003 versions. ... Select the Cost view table from ...
    (microsoft.public.project)
  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: Need Resource Group in Visual Reports
    ... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
    (microsoft.public.project)
  • Re: BCWP and BCWS
    ... Were you able to add the Tasks to Row labels in Excel? ... Report Filter, add to ROW Labels and Add to Column Labels. ... editing the report and inserting Actual Costs, Tacks AC, Task ... calculates actual duration and remaining duration. ...
    (microsoft.public.project)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)