Want to Add a Column to PWA View when exporting

Z

Ziebarth

Does anyone know how to add a column to exported PWA View. When I do an
export I only get the task Name, I want the remaining work column also. Any
assistance would be great.
 
D

Dale Howard [MVP]

Ziebarth --

You cannot to apply a PWA view that contains the columns you want to see.
If no such View exists currently, your Project Server administrator must
create the View for you. Hope this helps.
 
Z

Ziebarth

It is in the view, it is just that when I export it itsn't there, the only
visible field when I export is task name, I want to add the field work
remaining.
--
Ziebarth
Still Learning


Dale Howard said:
Ziebarth --

You cannot to apply a PWA view that contains the columns you want to see.
If no such View exists currently, your Project Server administrator must
create the View for you. Hope this helps.
Click to expand...
 
D

Dale Howard [MVP]

Ziebarth --

Well, I'm stumped. When you click the "Export Grid to Excel" link, the
system exports EVERY column in the currently applied View in PWA. Do you
have the same problem if you select other Views? By the way, from which PWA
page are you exporting the data and what View have you applied? Let us
know.




Ziebarth said:
It is in the view, it is just that when I export it itsn't there, the only
visible field when I export is task name, I want to add the field work
remaining.
Click to expand...
 
Z

Ziebarth

I am exporting from the resource assignments view and that is how all my
views look, are you saying this could be a customization. If it is would you
have an idea on where I alter it.
 
D

Dale Howard [MVP]

Ziebarth --

OK, you are navigating to the Project Center page and clicking the View
Resource Assignments link in the sidepane. Right? You select one or more
resources and then click the Apply button. Right? In the upper right
corner of the page, does the Choose A View pick list show the Summary view?
If so, by default the Summary view shows the following columns of data in
this order:

Indicators
Task Name
Submitted On
Project
Work
Remaining Work
Start
Finish
% Work Complete
Comments
Resource Name
Status

Do you see those columns on the left side of the page in the data grid? By
default, grouping is applied on the Resource column and then on the Project
column. Click the Filter, Group, Search tab to confirm that grouping is
applied correctly. Is it correct? When you click the Export Grid to Excel
link, the system should create an Excel spreadsheet containing all those
columns, with grouping by Resource name and then by Project name. Let me
know what you find based on my questions and comments above.
 
Z

Ziebarth

OK I found out the difference, when you print from the timesheet view you get
only the task name and the timesheet. When you print from Gantt you get the
full columns. I want the full columns with the time sheet.
thanks for helping me figuer this out it is driving me nuts
 
D

Dale Howard [MVP]

Ziebarth --

Believe me, it was driving ME nuts, too! :) Glad I could help.
 
Top