I am working on a project right now that involves several lists related to employee availability and asset availability (e.g. vacation, project travel, etc.). These lists are populated by various forms with extensive workflows behind them, and everything seems good. However, I am looking for a way to display all of this information in a schedule view, somewhat similar to a Gantt chart. As one view, I would like to be able to have a collapsible 'Trip', with associated assets and employees within this category, and have each individual asset / employee / trip have a schedule shown to the right (a broken line showing unavailable periods). I am not able to get code onto our server, so I have to do this all OOB.
Does anyone have any suggestions as to how to go about this? Is there a way to import all of this data to Project and aggregate it? Maybe it would be best to create some sort of Access report for viewing on SharePoint? Any suggestions would be appreciated.
EDIT: I have come across some screenshots of Team Planner from Project Pro 2010- that is exactly the sort of view that I am looking for. I can't find any information indicating that there is a way to get this view directly into SharePoint, but if my description wasn't clear enough, this is what I'm trying to get (without the drag-and-drop capability- I would like mine to be read-only):