A point to note: "Notes" fields are Rich Text Format, and are stored in a
binary form in the database. You will need a translation DLL to convert to
clear text.
JTC
jpa said:Paul, Thanks for your inputs
Now I am a little bit confused...
In a previous post [Which report to list tasks "Comments" and "Notes"
fields? 7/17/2008 1:09 AM PST] I received following positive answer
A point to note: "Notes" fields are Rich Text Format, and are stored in a
binary form in the database. You will need a translation DLL to convert to
clear text.
JTC
Could anybody send me such an example I could test?
thanks a lot
jpa
Paul Conroy said:Task comments/notes aren't available in the reporting database and cannot be
passed by the PSI, so I doubt this is possible.
Another approach would be to make use of risks/issues lists.
Paul Conroy said:Tasks are stored in the Published Database in the MSP_Tasks table as binary
objects. Microsoft will not publish the schema for this DB and will
certainly not support queries against this data.
Whilst technically possible, it certainly isn't supported. If MSFT change
the schema of the DB, then you may to re-architect any solution you have
implemented.
--
Please rate this post if it has helped
http://theprojectserverguru.spaces.live.com
jpa said:Paul, Thanks for your inputs
Now I am a little bit confused...
In a previous post [Which report to list tasks "Comments" and "Notes"
fields? 7/17/2008 1:09 AM PST] I received following positive answer
A point to note: "Notes" fields are Rich Text Format, and are stored in a
binary form in the database. You will need a translation DLL to convert to
clear text.
JTC
:
To get a neat report, a suitable option would be to get a custom built
report using reporting tools such as SQL Reporting Services.
Could anybody send me such an example I could test?
thanks a lot
jpa
Paul Conroy said:Task comments/notes aren't available in the reporting database and cannot be
passed by the PSI, so I doubt this is possible.
Another approach would be to make use of risks/issues lists.
--
Please rate this post if it has helped
http://theprojectserverguru.spaces.live.com
:
Hi all,
(PS2007 SP1)
I am looking for examples of SRS reports (and SQL requests) able to list
"comment" text fields for all the tasks of a given project and/or managed by
a given resource...
Thanks for your help
jpa
jpa said:Paul,
Many thanks for the clarification
I understand that MS actually doesn't provide any mean to retrieve task's
"comment" field.
So I really wonder why MS provide (and store) such task text field if it
cannot later be used within any report...
Can you confirm that such limitation is also true when using a task custom
text field ?
thanks in advance
jpa
Paul Conroy said:Tasks are stored in the Published Database in the MSP_Tasks table as binary
objects. Microsoft will not publish the schema for this DB and will
certainly not support queries against this data.
Whilst technically possible, it certainly isn't supported. If MSFT change
the schema of the DB, then you may to re-architect any solution you have
implemented.
--
Please rate this post if it has helped
http://theprojectserverguru.spaces.live.com
jpa said:Paul, Thanks for your inputs
Now I am a little bit confused...
In a previous post [Which report to list tasks "Comments" and "Notes"
fields? 7/17/2008 1:09 AM PST] I received following positive answer
A point to note: "Notes" fields are Rich Text Format, and are stored in a
binary form in the database. You will need a translation DLL to convert to
clear text.
JTC
:
To get a neat report, a suitable option would be to get a custom built
report using reporting tools such as SQL Reporting Services.
Could anybody send me such an example I could test?
thanks a lot
jpa
:
Task comments/notes aren't available in the reporting database and cannot be
passed by the PSI, so I doubt this is possible.
Another approach would be to make use of risks/issues lists.
--
Please rate this post if it has helped
http://theprojectserverguru.spaces.live.com
:
Hi all,
(PS2007 SP1)
I am looking for examples of SRS reports (and SQL requests) able to list
"comment" text fields for all the tasks of a given project and/or managed by
a given resource...
Thanks for your help
jpa
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.