Forum Discussion
RobertOrnelas
Jun 07, 2022Iron Contributor
Schedule Report
Is a view/report similar to this possible in MS Project? our plant is used to seeing an Excel spreadsheet like this, which is very efficient. Basically, it's a Gantt chart where each cell is a task...
- Jun 08, 2022RobertOrnelas,
Yeah Project has a lot of subtle options that can make all the difference.
1. Double click on the summary line to bring up the task information window. Check the "Hide Bar" option. That will hide the summary line bar but allow rolled up subtask bars to appear, as long as the Rollup field is marked ad "yes" for the summary and all subtasks.
2. There is no "Subtask Name" field, the field is simply "Name", as shown in my screenshot.
Does that help?
John
ProjectFuture
Brass Contributor
Why wouldn't you suggest PowerBI?
Paul_Mather
Jun 07, 2022MVP
Hey ProjectFuture ,
As a guess, Dale_HowardMVP probably didn't suggest Power BI for one of the following reasons:
- Power BI is read-only - this Excel sheet is probably interactive / editable data
- To use Power BI, the organisation would need to use Project Web App. The post only mentioned MS Project which is just the desktop project tool.
Or maybe there was another reason..
Hope that helps
Paul
- ProjectFutureJun 07, 2022Brass ContributorThanks for the guess, Paul. Since the question was about a view in MS Project and not MS Project Professional, I assumed Project Online would be involved and could be a source of data without needing Project Web App. My bad, I guess.