Milestone View

[BillV]

Does anyone know how to show Milestone Tasks across the top of a Project
Sheet and the Summary Tasks in their traditional spot? This view was
requested for quick tracking purposes. Can this be done in Excel by linking
Project and Excel?

 

[davegb]

Does anyone know how to show Milestone Tasks across the top of a Project
Sheet and the Summary Tasks in their traditional spot?  This view was
requested for quick tracking purposes.  Can this be done in Excel by linking
Project and Excel?  

Group them that way. Or simply drag all your Milestones to the top of
the list. As to the "Traditional spot" for summary lines, which
tradition?

I know of no way to change the position of tasks in Project by linking
them to Excel.

Hope this helps in your world.

 

[Jan De Messemaeker]

Hi,

Project Menu
Group by...
More groups
select milestones, click edit
check on "show summary tasks"
OK, Apply
Next time you can go immediately to Group by... Milestones
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[BillV]

Group them that way. Or simply drag all your Milestones to the top of
the list. As to the "Traditional spot" for summary lines, which
tradition?

I know of no way to change the position of tasks in Project by linking
them to Excel.

Hope this helps in your world.

I guess I did not make myself very clear, my bad. What I should have said
was, instead of the traditional Gantt Chart View; is there away to make the
Milestones (subtasks) their own column at the top of the view, chart, report,
etc. while keeping the Summary Tasks in the first column (far left)? What I
need to do is fill in dates under the subtasks with the corresponding Summary
Task (in this case it's a school name) I'll also have a column showing the %
complete.

 

[davegb]

I guess I did not make myself very clear, my bad.  What I should have said
was, instead of the traditional Gantt Chart View; is there away to make the
Milestones (subtasks) their own column at the top of the view, chart, report,
etc. while keeping the Summary Tasks in the first column (far left)?  What I
need to do is fill in dates under the subtasks with the corresponding Summary
Task (in this case it's a school name)  I'll also have a column showing the %
complete.



- Hide quoted text -

- Show quoted text -

I'm still having trouble picturing what you want. I don't know of any
way to arrange different types of tasks in different columns. And I'm
not clear what a "column at the top" would be. A row at the top makes
more sense.

Sounds to me like you need to copy your task names and %Completes over
to an XL spreadsheet and then place them in rows and columns anyway
you like.

Hope this helps in your world.

 

[BillV]

JDM, thanks for the advice but I wasn't very clear. Here's what I mean.
Can I place the Milestones (tasks) horozontally in a left to right row across
the top of the Project while the Summary Tasks (in this case the schools) are
listed in a column? The purpose is to read the Summary Task (School) and see
which subtasks have been completed at the school by date. These are all
duplicated subtasks.

 

[BillV]

Trevor,

Thanks for the feedback. I do not doubt the expertise of anyone, please
understand that, not one bit. My request for help with this issue was
because it was a request put to me. I can't say I have ever seen a layout as
I described but, it did not mean someone hadn't pulled it off. I can now
honestly say, it can't be done. I will try your suggestion as it may be a
great alternative to what was requested of me. Thanks for your help.

 

[Jan De Messemaeker]

Hi,

I don't see that, sorry.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Mark E. Read]

Hi,

I don't see that, sorry.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620






- Show quoted text -

Hate to chime in here at the last minute, but these layout requests we
get often, and where the traditional UIs (Project Pro and Project Web
Access) are challenged, we can usually overcome by developing the
report in SQL Reporting Services, which provides some tools for report
design and layout, as well as some nice tools for distribution
(subscriptions).

The challenge with SQL Reporting Services is you have to know SQL
first, and second you need to know the tables and views associated
within the Server to get at the data you need. Not a job for the
feint at heart, but a job nonetheless that is doable in most cases.

Depending on the value of the report in your organization, it might be
worth investing some developer time to be able to produce it...

Thanks!

--Mark