report the comment you have made in timesheet

[Henk]

(MSPS 2007)

Hi all,

In your timesheet you can add comment (at task level and at timesheet
level). So this is stored in de database. Is there a way to report
this comment?

I couldn't find it in the timesheet-cube.

Thanks for your help.

Henk

 

[Henk]

Kick.

Nobody, even the MVP's, knows if is is possible?

Best regards, Henk

 

[Jonathan Sofer [MVP]]

Comments stored against a timesheet line item can be accessed from the
Reporting database using SQL Server Reporting Services under
MPS_TimesheetLine but I don't believe they will not show up in the cubes.

Comments stored against the timesheet (i.e. on the submission form) are
stored as part of the transactional comment and can only be found in the
Published database in MSP_TIMESHEET_ACTIONS.TS_ACTION_COMMENT

Jonathan Sofer

 

[Henk]

Comments stored against a timesheet line item can be accessed from the
Reporting database using SQL Server Reporting Services under
MPS_TimesheetLine but I don't believe they will not show up in the cubes.

Comments stored against the timesheet (i.e. on the submission form) are
stored as part of the transactional comment and can only be found in the
Published database in MSP_TIMESHEET_ACTIONS.TS_ACTION_COMMENT

Jonathan Sofer









- Tekst uit oorspronkelijk bericht weergeven -

Thank you Jonathan, this helps me along!

Best regards, Henk