Format Notes Page??

[ARBrock]

In the Gantt Chart view, I have turned on the print notes page under page
setup/view/print notes.

Is there a way to format this page at all? Specifcally, I want to print the
task start and finish dates next to the task name so that people looking at
the note page do not have to cross reference back to the printed Gantt
chart...

Thanks!

-AR

 

[JulieS]

Hello AR,

To the best of my knowledge, no, the notes page is not customizable. An
option that may possibly work for your situation would be to add the
Notes field to the table (left side) portion of the Gantt view. If you
use short notes (255 characters or less) you could then show the note
next to the task name and print from there.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[ARBrock]

Thanks Julie.

I think we are going to need to come up with a different solution. Fun fun

-AR

 

[JulieS]

You're welcome. Sorry there wasn't a "magic" answer

Julie

 

[DavidC]

Hi,

Best I have found so far is to save the file as an access database, use some
VBA code in access to extract the notes from the binary file that the notes
are stored in, then use the report features of access to develop my own
reports. It is not very elegant, but it does seem to work, and allows access
to the full capacity of the notes field without the limitations of 256
characters or carriage return whichever comes first.

Hope this is of some help.

Regards

DavidC

 

[JulieS]

Hello AR,

I don't know why I didn't think of this earlier. If your objective is
to be able to print the notes for tasks along with additional task
information (Start, Finish, etc) - have you looked into creating a
custom task report? You could create a custom table with just task
name, start, finish, and a few other fields of interest. Use that table
as the basis of the task report. On the details tab of the report
setup, select to print Task Notes.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[DavidC]

Hi Julie,

I just tried your suggestion using notes with three paragraphs and it gave
the expected result. Unfortunately the way Project handles notes means that
if the notes exceed 256 characters or has a carriage return in it, then the
notes field only shows the first 256 characters or up to the first carriage
return. The notes from the notes tab of the task information is stored in a
binary field and the problem is accessing that data to write a report.

have you found a way of getting that data out inside Project? I would be
interested as so far I have only been able to get it out into a report using
VBA to extract the data from the binary file.

regards

DavidC

 

[JulieS]

Hi DavidC,

I just created a custom Task report and when adding the Notes to the
report through the Details tab, I was able to view/print over 2000
characters, including carriage returns, in the report.

I'm not sure which suggestion (adding Notes through the report
Definition or adding the Notes field to a table) you followed. You are
correct, the notes field added as a field in the table will truncate at
255 characters or the first carriage return. However, selecting Notes
on the Details tab of the Task Report dialog box will return all text
entered into the Notes tab on the Task Information dialog box.
--
I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[DougK]

Dear David,

I'd LOVE to have an Access report of my Project file. I know how to save as
an mdb but I can't get the notes to print at all. Would you kindly post the
VBA or email to me? I would be ever so appreciative.

Thanks in advance,
Doug
(e-mail address removed)

 

[DougK]

Hi Julie,

I would LOVE to have the VBA in Access to print the notes in Project. It's a
BLOB object, I assume, but I have not a clue how to print that column. Would
you be so kind as to send me some sample VB to print? Dumbly, I added all
kinds of highly cool things in notes e.g. image clips, hyper links and all
kinds of formatted text.

Many thanks,
Doug
(e-mail address removed)

 

[DavidC]

Thanks, it worked. Don't know why it didn't work the last time, guess I just
hit the wrong keys again.

 

[JulieS]

You're welcome David. Glad you were able to get it working and thanks
for the feedback.
Julie
Project MVP

 

[JulieS]

Hi Doug,

I *just* started working with the database structure in Project, so I
may not be the best reference.

I first suggest taking a lengthy read of the PJDB.HTM file which should
be stored at the install point for MS Project. (search for PJDB.HTM -
assuming you are using Project 2003.) In that file there is sample code
for extracting data from the RTF notes field. Search the PJDB.HTM file
for RTF and you should be able to hit upon it relatively quickly.

You could also try posting your specific question to the Project
Developer newsgroup as that ng is more focused on VBA code.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Stanizlas]

Hi David,
could you give us more detailed information about the way you solved this
issue to be able to get the task's notes in a report.
I have been trying for weeks to get these notes in a Report developped and
deployed in Reporting Services without success, and may be your solution will
help me to solve this big issue.
Thanks

 

[JulieS]

Hello Stanizlas,

It sounds as though you are attempting to view the Notes from
outside Project using SQL Server Reporting Services? That is a very
different process than DavidC is discussing below. The thread below
is about **printing** notes from within Microsoft Project.

Have you checked the Project 2007 SDK? I believe there is quite a
bit of information about using the reporting db.

You may also find the following post from Christophe Fiessigner's
blog helpful:
http://blogs.msdn.com/chrisfie/arch...t-project-task-s-notes-field-in-a-report.aspx

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project