In few companies, people prefer to see the data in MS Excel sheet for their reporting needs.

In MS Project Server, we have reporting feature. Sometimes that is not enough to meet the reporting needs of a company. In that case, one can use some of the third party tools available in market. For basic reports one can use MS Excel using a hidden gem in it called MS Query.

If you know Excel then you have unlimited option for reports using MS Query. I’ll suggest the following articles on the topic.

Connect to the Project Server OLAP Cube with Excel 2000
Use MS Query to Treat Excel As a Relational Data Source

Leave a Reply

Sign up for Softvative Newsletter

Get notified about new articles and deals

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter