A Guide to Tabular Reporting

Text Reporting

in Microsoft® Office Project

by Ismet Kocaman

An eBook for the users of all standalone desktop editions/versions

 

Released on August 12th, 2021

 

Available to purchase in pdf format

Download & read on your computer

 

 

 

 

What is in the eBook ?

 

Reporting capabilities of MS Project’s standalone desktop editions/versions have been greatly improved by the introduction of the graphical reports, starting from MS Project Standard/Professional 2013. The text reports feature supported by the earlier versions was discontinued by the introduction of this new reporting tool. Thus, MS Project 2010 is the last version of the product that includes the text reports. In this eBook, you will find all the information that you need in order to develop tabular reports in all versions and also to create views, visual reports and graphical reports that present the project information in tabular format in later versions so as to deliver the same or similar content as the text reports. This eBook will also show you how to produce new project data in MS Excel, by performing calculations on the data exported from MS Project by using either the Visual Reports or the field mapping feature.

 

Who should read ?

 

Professionals, who currently run MS Project 2010, and therefore, who want to gain a good understanding of this feature, and at the same time, who are currently considering or already planning/undergoing a transition to a later version of the product supporting the graphical reports feature may benefit from the content presented in the eBook. Although the later versions of the product no longer support the text reports feature, tabular reporting, that is, processing and then presenting project data in flat or crosstab tables, is an important part of project reporting, and therefore, users of all stand-alone desktop editions/versions may find this eBook useful as a reference on reporting the project data in tabular format by making use of the features that MS Project offers.   

 

This eBook assumes that you are currently using MS Project in planning and managing projects and you are already familiar with views, tables, filters, groups and sorting as well as all the reporting features available in the desktop edition/version of the product used. It is also assumed that you are familiar with handling MS Project formulas and working with the PivotTables in MS Excel.

 

Other Details on the eBook

 

The content of the eBook complies with the standalone desktop editions/versions, MS Project 2010 through 2019. The eBook contains 358 pages, including the cover pages, and the contents and index sections. There is no printed version of this eBook. The mpp files for the eBook are not available to purchase. A link to download a text file containing the codes listed in the eBook will be provided along with the eBook during the purchasing process.

 

The Contents and Introduction sections of the eBook are available here to review. Also see a LinkedIn article on the overallocated resources report here based on the excerpted material, and click the links below to see the screenshots from some of the table/crosstab reports developed in the eBook:

Cash Flow Report (a date-range applied OLAP-based PivotTable (a reusable template) that shows the cost values in two currencies)

Percent Allocation and Overallocation Report (a conditional-formatting applied OLAP-based PivotTable (a reusable template) that shows under- and over-allocations along with the number of hours overallocated)

Task Starting Next Week Report (a preview of the customized usage view)

Project Summary Report (a graphical report that shows the data calculated by the custom field formulas)

Graphical reports that show task timephased work data, task and assignment notes (VBA subroutines) and cost rates (VBA subroutines)

Any topic on planning, scheduling and managing projects with MS Project, any conceptual topics on project reporting and any project reporting implementations on specific areas that require focusing on the techniques and/or analyzing the report content rather than MS Project's reporting features are outside the scope of this eBook.

 

The details on the electronic book format of the eBook are as follows:

 

  • Page size of the eBook is 8.5 x 11 inches (the paper size Letter).  

  • eBook is in pdf format and no other electronic format of the eBook is available.

  • eBook can be viewed by any pdf viewer.

 

 

How to Buy the eBook

Important Note to Purchasers - All sales are final. The purchase of this eBook is not refundable and no returns are accepted for this eBook. Therefore, review the sample content thoroughly on your computer system and make sure that both the content and the format suit your needs before attempting to buy the eBook.

 

Click the ordering button below if you want to purchase the eBook (Price: US$24.99). You will receive an email with the download link as soon as you complete your purchase.

 

 

All transactions will take place through FastSpring's system (a BBB A+ accredited business in US) and the eBook file will be directly delivered from FastSpring's servers

 

 

 

Copyright © All Content - Ismet Kocaman | http://www.ismetkocaman.com

 

Microsoft® is a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries. The author of this document has no affiliation with Microsoft Corporation. All other trademarks mentioned herein are the property of their respective owners.