Task Notes Extraction

[Abi Sabado]

Hello,

I am currently working on creating status reports for our IT Managers
and they would like to see comments as well so I thought of making the PM's
enter all their comments in the Task Notes of a specific Summary Task (i.e.
Project Management) then in my SQL query I will extract the value entered
there from the MSP_TEXT_FIELDS (by joining it with appropriate tables --
MSP_WEB_PROJECTS etc.)

BUT when I displayed the data in an the report, it truncated the Task Notes.
For example:
__________________________
Actual Contents:
6/7/2005 - progress notes
5/30/2005 - previous week progress notes
5/23/2005 - developer;s on leave. will resume next week.

Displayed Contents:
6/7/2005 - progress notes
__________________________

How do I extract the full content of the task notes field so I can display
it properly?

Thanks

 

[Ed Morrison]

Hi Abi,
Notes are stored in the msp_tasks.Task_RTF_Notes. Unfortunately, this field
is a binary. The abbreviated notes text in msp_text_fields is used for the
notes icon tag in PWA. Try using an on_save macro to copy the notes field
into a enterprise custom text field. Then report on the text field. You
will of course loose your Rich Text Formatting on the note.

Glad to hear that you are using SQL Reporting Services. Good Luck.

 

[Abi Sabado]

Hi Ed,
Thanks so much for replying. I actually checked the Task_RTF_Notes and tried
converting it back to its actual value by trying out SQL commands...
but I still haven't figured out how.
If I copy the notes to a text field using on_save and lose all formatting,
that means in the report i am creating, I will have to re-apply the
formatting?
Wow seems like a lot of programming! because then I have to parse the text
field, format it before the contents get displayed... is this correct?

Oh by the way thank you for informing me about SQL Reporting Services,
I am actually recommending SQL Reporting Service for the Tender Automated
reports
I think it's such a big help. But we're still planning things for now.

thanks so much.