Visual Reports in 2007

[burns5133]

Can i query 2 tables in a visual report? ALso, when I coose Resourc
summary for a new report, I select the group field but I can't see it o
filter on it in the excel pivot table

 

[Dale Howard [MVP]]

burns5133 --

I have no idea what you mean by "query 2 tables" in your question. A Visual
Report collects aggregate information across all tasks and all resources in
a project for Totals information like Work and Cost. To answer your second
question, I will assume you have displayed the Resource Remaining Work
Report in Excel, as this is the only default Visual Report for Resource
Summary information. Select the Resource Summary worksheet tab in Excel,
then right-click in the Resources column. In the shortcut menu, select the
Show Properties in Report item and then click the Group field on the flyout
menu. This will add the Group field to the PivotTable. Hope this helps.