Modifying Reports

[Yvan B.]

Hi,

I woud like to create a weekly project status report in MSProject. The
table data is OK but I would like the possibility to add text data other then
the one liste in the on in Custom Report|SetUp|General. This is to avoid
using our Excel speradsheet that we are currently using. I would be
surprised if I'm the only one that is enquiring on this. Does that already
exist?
Thanks,
Y.

 

[John]

Hi,

I woud like to create a weekly project status report in MSProject. The
table data is OK but I would like the possibility to add text data other then
the one liste in the on in Custom Report|SetUp|General. This is to avoid
using our Excel speradsheet that we are currently using. I would be
surprised if I'm the only one that is enquiring on this. Does that already
exist?
Thanks,
Y.

Yvan,
Why not use the "Project fields" selection box instead of the "General"
selection box? Put whatever text you like in a spare text field (e.g.
Task Text1) on the Project summary task. If the Project summary task is
not displayed, it can be shown by going to Tools/Options/View tab.

Hope this helps.
John
Project MVP

 

[Yvan B.]

I'm not too sure I understand your point.

1. Which options on the Tools/Options/View tab should be checked and where
would I see the change?

2. The information would need to be different on a weekly basis and the
previous information would need to kept available. Would that be possible
with your solution? Wouldn't I be limited by the number of fields that are
available?

3. Do no know if any dvlp using VBA or any other third party (e.g. Crystal
Report) are currently available.

Thanks,
Y.

 

[John]

I'm not too sure I understand your point.

1. Which options on the Tools/Options/View tab should be checked and where
would I see the change?

2. The information would need to be different on a weekly basis and the
previous information would need to kept available. Would that be possible
with your solution? Wouldn't I be limited by the number of fields that are
available?

3. Do no know if any dvlp using VBA or any other third party (e.g. Crystal
Report) are currently available.

Thanks,
Y.

V,
1. On the Tools/Options/View tab in the lower right hand corner there is
an option called "Project summary task". Check it. On the Gantt Chart
view (or most other task type views) you will see a new task line with
an ID of "0". This is the Project summary line.

2. If you are doing a weekly report and you want to keep historical
data, the best way is to save a copy of the Project file every week. For
example, lets say that you want the report header to include "week 6 -
2005". If in the "Project fields" selection box for the header tab on
the Page Setup window, Text1 was selected, then whatever you put into
Text1 for the Project summary task will appear in the header. In this
case "week 6 - 2005". You do not need to use a different text field each
week because each week is a new snapshot of status and snapshots of
previous weeks have already been saved.

3. What is "dvlp"? I have no knowledge of Crystal Reports.

Hope this helps.
John
Project MVP