Do you have a desire to secure the data from Reporting database based on user rights in the Project Server? You might be interested in this:
Big thanks to Stephen C. Sanderlin, MSProjectExperts, who wrote this article and extensive code sample. It’s an excerpt from his forthcoming book, Developer's Guide to Microsoft Project Server 2010.
There is ValleySpeak Project Server that helps me to maintain all my tasks, vacations, meetings, schedules, very easily. I find it the best to use
Thanks jerry ValleySpeak Project server was of a great use ,at present even i am using it .Really its very user friendly and its the easy and cheapest way of managing the project i think its has a more advanced feature in it and a best collaborative tool even.