I am trying to take a few select fields from multiple copies of the same template, a Project Status Report (PSR), and build an Executive Status Report. I want to build a Portfolio Status Report with a row for each individual PSR and the fields taken from each individual PSR.
Proj Name, Schedule Status, Resource Status, Project Stage, Due Date and Project Manager are examples of the fields I would like to gather from each PSR and put into a table in the Portfolio Status report. Ideally, there would be one row in the destination table for each individual PSR. I would also like to alphabetize the resulting table by Project name after the destination table is completed. Do I still use the GetInputParameter command, the SubmitToSharePointList command, something else or is this too difficult to do without custom code?
Mark E. David MCTS, MBA, PMP
Indianapolis, IN 46168
[email protected]