Resource Summary View - Timesheet

[SandraAJones]

No matter what I try, the Administrative projects fall to the bottom of the
view instead of bing sorted in with the other projects by Resource Name. It
is driving me buggy.

My work around is to export data to Excel, but have run into a conversion
issue as the hours come across with "h" after the number and am having issue
with getting this to calculate as a number in Excel.

Help on either issue would be greatly appreciated.

Thanks.

 

[Gary L. Chefetz [MVP]]

Sandra:

Use search and replace to rid yourself of the 'h'

 

[SandraAJones]

What I actually did to solve the problem was go into the SQL Table for
Project ID and changed the 1 under the last column to a 0 to make it like the
other projects. Since I need to be able to consolidate the hours information
rather than separate Admin from non-Admin projects this works for us. The
sort now actually works as I want it to in PWA and I do not have to export
the data to Excel.

 

[Gary L. Chefetz [MVP]]

Sandra:

That changes the behavior of the projects in other ways. Perhaps you simply
need to use regular projects instead of Admin projects, which is something
we generally recommend anyway.