Force zeros instead of blank entries in user timesheets

[Riso]

Hello folks,
I have this little issue which needs to be solved in my company. We
are using non-managed time periods and don't want to switch to managed
ones (too much pain). However we also have requirement from Finance to
freeze previous periods.

So I am exploring the option to apply alternative method of freezing
actuals for previous time periods. This alternative solution is based
on changing the "WWORK_READONLY" flag inside MSP_WEB_WORK table for
all past assignments to a value of "1" which makes each daily record
in the timesheet read only.

However this approach only freezes cell which are not blank. Those
cells which are blank still remain in their R/W state so I am thinking
to force them to '0' in the database, right before I run the
WWORK_READONLY update.

Now here is my question. Is there a way to display timesheet in
timescaled form in the database and if so, how would I replace all
_null records with zeros?

Your help is much appreciated!

Thanks,
Riso...

 

[Mike Glen]

Hi Riso,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP