L
Lori
I would like to print my notes at the end of each subproject. Does anyone know how to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John
Lori,
What do you mean "at the end of each subproject"? Have you tried using
File/Page Setup/View and checking the 'Print Notes' option?
John
What do you mean "at the end of each subproject"? Have you tried using
File/Page Setup/View and checking the 'Print Notes' option?
John
L
Lori
I have a master project which contains about 30 subprojects which are actually large subtasks lists. They all roll up to just one major project. Each grouping of tasks are simply separated by a page break. I would like to have the notes for each grouping of tasks printed at the end of the page as opposed to at the end of the entire project. Basically I just want the notes to print with the subtask list.
Does this make sense?
Does this make sense?
J
John
Lori,
Kinda but it's still muddy. I guess I'd have to see your structure to
fully understand. For example, it is not clear whether the 30
subprojects are really subprojects (as defined in Project) or just the
groups of subtasks you describe.
Did you try the method I suggested (i.e. File/Page Setup/View-Print
Notes)?
If all else fails it is possible to do the equivalent of what you want
by using VBA. My suggestion would be to export the subtask list(s) and
Notes to Excel. As a matter of fact, a few months ago I wrote a similar
macro for a couple of other posters. If you are interested, contact me
direct.
Hope this helps.
John
Kinda but it's still muddy. I guess I'd have to see your structure to
fully understand. For example, it is not clear whether the 30
subprojects are really subprojects (as defined in Project) or just the
groups of subtasks you describe.
Did you try the method I suggested (i.e. File/Page Setup/View-Print
Notes)?
If all else fails it is possible to do the equivalent of what you want
by using VBA. My suggestion would be to export the subtask list(s) and
Notes to Excel. As a matter of fact, a few months ago I wrote a similar
macro for a couple of other posters. If you are interested, contact me
direct.
Hope this helps.
John
L
Lori
Thanks John. Yes, I have selected File/Page Setup/View Print notes, however all notes print at the end of the project, (at the end of all 50 pages). Team members feel this is too awkward to reference back to the last page. Maybe my structure is incorrect. I took over this file from another staff person and its my first. Let me research "subprojects" as defined by Project as you mentioned. Maybe there is a better way to do this.
J
John
Lori,
I didn't mean to imply that your file structure was incorrect, only that
I didn't have a clear picture of it from you description. There may or
may not be a better structure to use. It all depends on your needs.
With regard to the term "subprojects". In Project subprojects are
individual Project files that have been inserted into a master file.
This is normally done using the Insert/Project menu item. An easy way to
tell if this is your structure is to add the Subproject File field (i.e.
column) to the active view. Any entries in this field indicate the
insertion point of a subproject file.
John
I didn't mean to imply that your file structure was incorrect, only that
I didn't have a clear picture of it from you description. There may or
may not be a better structure to use. It all depends on your needs.
With regard to the term "subprojects". In Project subprojects are
individual Project files that have been inserted into a master file.
This is normally done using the Insert/Project menu item. An easy way to
tell if this is your structure is to add the Subproject File field (i.e.
column) to the active view. Any entries in this field indicate the
insertion point of a subproject file.
John
L
Lori
Thanks John. I did some more research and my project is simply a list of tasks. Not subprojects as I thought. What I would like to do is to print the notes at the end of each page (if there are notes on that page) as opposed to printing them all at the end.
J
John
Lori,
I'm assuming the text in the Notes field contains line feeds. If not,
you can simply set a view to display the Task name and Notes. Include
whatever other Project fields you want but if too much information is
displayed per Task row, the print will spill unto the next page.
If the Notes text does contain line feeds a VBA macro is needed because
line feeds do not display when the Notes field is included as a view
column. I have a macro that exports the Notes field to Excel along with
the Task name and a couple other fields. If you are interested write me
direct.
Hope this helps.
John
I'm assuming the text in the Notes field contains line feeds. If not,
you can simply set a view to display the Task name and Notes. Include
whatever other Project fields you want but if too much information is
displayed per Task row, the print will spill unto the next page.
If the Notes text does contain line feeds a VBA macro is needed because
line feeds do not display when the Notes field is included as a view
column. I have a macro that exports the Notes field to Excel along with
the Task name and a couple other fields. If you are interested write me
direct.
Hope this helps.
John
L
Lori
Thanks John. How do I set a view to display the Task name and Notes? My notes are pretty brief and I can remove line feeds.
J
John
Lori,
A single 'View' in Project is made up of three items, a 'screen' (e.g.
Gantt Chart, task sheet, etc.), a 'table' (e.g. entry, export, usage,
etc.) and a 'filter' (e.g. all tasks, summary tasks, etc.). You want to
create a custom table that only shows the Task Name and Notes. Depending
on whether you want to keep your custom view for use again at a later
time for example, or simply want to temporarily modify an existing view
(e.g. Gantt Chart View), different approaches are appropriate. Let's
take the approach of creating a permanent custom view. It will be saved
with the file so it will be available any time you need it and by using
the organizer, your custom view can be transferred to other files or to
your Global so it is usable with all files.
1. Go to View/Table/More Tables
2. Hit 'New'
3. In the Table definition window, give your table a name (e.g
Name&Notes)
4. If you want the Task ID to appear as the first column, put "ID" as
the Field name in the first row (or select ID from the selection list)
5. A Width of 5 is normally good for the ID column
6. Immediately under the ID, click the mouse to start another row and
select "Name" from the selection list
7. Depending on the length of task names in the file, a Width of 25 is
normally sufficient but this can be adjusted later
8. Under the Name, start another row and select "Notes"
9. A Width of 100 should be adequate for most notes text if it is not
too long.
10. If any Task name or Notes exceeds the column width settings, "word
wrap" can be applied by setting the row height to 2 or more in the lower
right corner of the Table definition window
11. Hit 'ok' and 'close'
12. Now go to View/More Views and hit 'New'
13. In the Define new view window that pops up, hit 'ok'
14. In the View definition window, give you view a name (e.g. Lori)
15. For 'Screen' select 'Task sheet'. This eliminates the Gantt graphic
16. For 'Table' select the table name created in item 3 above.
17. For 'Group' select 'No group'
18. For 'Filter' select 'All tasks'
19. If you want your view to appear as a menu item, check 'show in menu'
20. Hit 'ok' and 'apply'
That's it, you are all set
John
A single 'View' in Project is made up of three items, a 'screen' (e.g.
Gantt Chart, task sheet, etc.), a 'table' (e.g. entry, export, usage,
etc.) and a 'filter' (e.g. all tasks, summary tasks, etc.). You want to
create a custom table that only shows the Task Name and Notes. Depending
on whether you want to keep your custom view for use again at a later
time for example, or simply want to temporarily modify an existing view
(e.g. Gantt Chart View), different approaches are appropriate. Let's
take the approach of creating a permanent custom view. It will be saved
with the file so it will be available any time you need it and by using
the organizer, your custom view can be transferred to other files or to
your Global so it is usable with all files.
1. Go to View/Table/More Tables
2. Hit 'New'
3. In the Table definition window, give your table a name (e.g
Name&Notes)
4. If you want the Task ID to appear as the first column, put "ID" as
the Field name in the first row (or select ID from the selection list)
5. A Width of 5 is normally good for the ID column
6. Immediately under the ID, click the mouse to start another row and
select "Name" from the selection list
7. Depending on the length of task names in the file, a Width of 25 is
normally sufficient but this can be adjusted later
8. Under the Name, start another row and select "Notes"
9. A Width of 100 should be adequate for most notes text if it is not
too long.
10. If any Task name or Notes exceeds the column width settings, "word
wrap" can be applied by setting the row height to 2 or more in the lower
right corner of the Table definition window
11. Hit 'ok' and 'close'
12. Now go to View/More Views and hit 'New'
13. In the Define new view window that pops up, hit 'ok'
14. In the View definition window, give you view a name (e.g. Lori)
15. For 'Screen' select 'Task sheet'. This eliminates the Gantt graphic
16. For 'Table' select the table name created in item 3 above.
17. For 'Group' select 'No group'
18. For 'Filter' select 'All tasks'
19. If you want your view to appear as a menu item, check 'show in menu'
20. Hit 'ok' and 'apply'
That's it, you are all set
John
J
John
Lori,
Alexander was great, I'm just a guy trying to help and, you're welcome.
John
Alexander was great, I'm just a guy trying to help and, you're welcome.
John
T
TKeire
John
I have also used your info, nice one, the problem I have is that I have
multiple Note entries for each task. I start a new line within the Note
field for each entry. when I set up this view the Note field only shows the
first entry. any more ideas
Thanks
I have also used your info, nice one, the problem I have is that I have
multiple Note entries for each task. I start a new line within the Note
field for each entry. when I set up this view the Note field only shows the
first entry. any more ideas
Thanks
J
John
TKeire said:John
I have also used your info, nice one, the problem I have is that I have
multiple Note entries for each task. I start a new line within the Note
field for each entry. when I set up this view the Note field only shows the
first entry. any more ideas
Thanks
TKeire,
When you say you have multiple entries in the Notes field I assume you
you mean you entered those under Project/Task Information/Notes tab.
Unfortunately that is also the only way to view those multiple entries.
Simply adding the Notes field as a column in a view will truncate at the
first line feed. The only other option for seeing the full notes text is
to use VBA or an SQL query on the Project database itself.
John
Project MVP
R
RobV
John kindly offered a VBA macro in one of the posts in this thread. I'd like
to get a copy of the macro, but his e-mail address does not seem to be
functioning. Anyone know his co-ordinates?
to get a copy of the macro, but his e-mail address does not seem to be
functioning. Anyone know his co-ordinates?
J
John
RobV said:John kindly offered a VBA macro in one of the posts in this thread. I'd like
to get a copy of the macro, but his e-mail address does not seem to be
functioning. Anyone know his co-ordinates?
RobV,
Boy, who is this John guy anyway - so elusive.
Actually my e-mail address works fine but it isn't the one you see in
the header.
John
Project MVP
jensenj6atatcomcastdotdotnet
remove obvious redundancies
O
okie
Hi, not sure if you are still on the discussion board... the info was very
helpful but I have a question... before I ask I wanted to say that I'm very
new to Projects. So when you say use "VBA or an SQL query on the Project
database itself," I have no idea what you are referring to. Also, when
following your directions, you suggested to use "word wrap," I couldn't
figure out where to set this...
So here's my question: I have a similar situation as posted by TKeire
(4/3/06). I have multiple notes that I want to include when printing out. Or
is there a way to "archive" my notes and only keep the most recent note(s) in
the "notes" tab? If I happen to have two notes in the "notes" tab I would
like to print all notes... what do you suggest? Thanks.
helpful but I have a question... before I ask I wanted to say that I'm very
new to Projects. So when you say use "VBA or an SQL query on the Project
database itself," I have no idea what you are referring to. Also, when
following your directions, you suggested to use "word wrap," I couldn't
figure out where to set this...
So here's my question: I have a similar situation as posted by TKeire
(4/3/06). I have multiple notes that I want to include when printing out. Or
is there a way to "archive" my notes and only keep the most recent note(s) in
the "notes" tab? If I happen to have two notes in the "notes" tab I would
like to print all notes... what do you suggest? Thanks.
R
Rob Schneider
The "notes" field in Project is just a place to put up to (I think)
64,000 characters of formatted text and graphics. It does not do
versioning, and it does not provide ways to "print all notes" (unless
you use VBA and SQL queries which you say our out of bounds).
Best, I think, to keep your notes in a Word Processor?
Or put a link in the Notes box that point to a file or URL where the
notes you want are kept?
--rms
www.rmschneider.com
64,000 characters of formatted text and graphics. It does not do
versioning, and it does not provide ways to "print all notes" (unless
you use VBA and SQL queries which you say our out of bounds).
Best, I think, to keep your notes in a Word Processor?
Or put a link in the Notes box that point to a file or URL where the
notes you want are kept?
--rms
www.rmschneider.com
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.