To get reports of all open and in-progress projects :

1. Go to Admin  >> Projects & Meetings >>  Reports
2. Clicking on open, In-progress or closed projects link will show you the complete project database.