Category: Business Intelligence

If you’ve ever attempted to include content from a Project multi-line text custom field or Issues multi-line fields in an Excel report, you will get a result that looks like this: <div><p>Vendor is having issues with deliveries to the East Coast.</p></div> At the 2012 Project Conference, I presented a SQL based solution that converts the […]

If you are planning to write reports over your Project Server data, you will need to know about the Reporting Database or RDB for short.   A Little History In Project Server 2003, all of the data was typically in one database.  Since this database was optimized to support Project Server transactions, reporting on that data […]

If you’ve ever been asked for information to support work you are doing or perhaps, to keep people informed of your efforts, you may have struggled with the process to define and deliver the information needed.  If you identify with this issue, this post will cover three key questions you should answer to help set […]