Project Server 2007 Multiple resource rate

[Arun]

Hi,
We are using project server 2007. Our resources are working in
onsite/offshore with different rates. I set the resource rates in the
resource rate table(A,B,C,D,and E) and assigned the resource rate throug task
usage. Every week we are submiting timesheet. Now I want to generate a report
with the project name, resource name, hours worked, resource rate(must) and
cost. Before setting the different rates I used the crystal report and query
from the reporting database and generate the above report. Now I coudn't get
the resource rate table information(it is in binary format in published
database) to get the resource rate. How can I generate the above report or is
there is any way to get the resource rate table for each assignment.

Thanks in advance,
arun

 

[Stephen Sanderlin]

Unfortunately, this information is only available from the PSI. There
are a variety of methods one can use to get this information into the
reporting database, but all of them would require some degree of custom
development.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[Arun]

hi Stephen,
Thanks for your reply, can you share the procedure to get the
information through PSI with me.

Thanks in advance,
arun

 

[Stephen Sanderlin]

Sure. You want to call ReadResources() in the Resources web service.
This will return a ResourceDataSet which should have all the rate
information in the ResourceRates table. Information on the rows in this
table is here:
http://msdn.microsoft.com/en-us/library/websvcresource.resourcedataset.resourceratesrow.aspx.


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com