Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2013, 04:45 PM
tmanzan tmanzan is offline Summary Report for Individual Task Windows 7 32bit Summary Report for Individual Task Office 2010 32bit
Novice
Summary Report for Individual Task
 
Join Date: Jan 2013
Posts: 3
tmanzan is on a distinguished road
Default Summary Report for Individual Task


I'd like to create a summary report (milestones, resources, costs) for an individual task for which there are no differentiating features. I cannot seem to find a report that just gives me one task. Is this possible?
Reply With Quote
  #2  
Old 01-11-2013, 06:33 AM
JulieS JulieS is offline Summary Report for Individual Task Windows 7 64bit Summary Report for Individual Task Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I suggest setting up a table with the required fields (resource names, costs) and then filtering all other tasks out. You could add one of the spare flag fields (flag1) set the value in the flag field to "yes" and then filter on that field.
Reply With Quote
  #3  
Old 01-14-2013, 07:40 AM
tmanzan tmanzan is offline Summary Report for Individual Task Windows 7 32bit Summary Report for Individual Task Office 2010 32bit
Novice
Summary Report for Individual Task
 
Join Date: Jan 2013
Posts: 3
tmanzan is on a distinguished road
Default Still a bit confused

Thanks Julie, I've created a new column with "flag1" and set the desired task to "yes", but it doesn't seem I can filter a task report based on the flag I set. I have no problem filtering the task that I want flagged, but I don't know if that option exists when I'm trying to create a report. Any ideas?
Reply With Quote
  #4  
Old 01-14-2013, 10:25 AM
JulieS JulieS is offline Summary Report for Individual Task Windows 7 64bit Summary Report for Individual Task Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Can you just print the view?

If you want to use one of the standard reports, you'll need to save the filter and apply the filter through the report definition. (click Edit in the Reports dialog).

I personally am more inclined to set up the table and view and just print that than try to get the report to look exactly as I need.
Reply With Quote
  #5  
Old 01-14-2013, 04:48 PM
tmanzan tmanzan is offline Summary Report for Individual Task Windows 7 32bit Summary Report for Individual Task Office 2010 32bit
Novice
Summary Report for Individual Task
 
Join Date: Jan 2013
Posts: 3
tmanzan is on a distinguished road
Default It worked!

Thanks Julie, I finally got it to work! I appreciate your help.

Trevor
Reply With Quote
  #6  
Old 01-15-2013, 03:52 AM
JulieS JulieS is offline Summary Report for Individual Task Windows 7 64bit Summary Report for Individual Task Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome Trevor and thank you for the feedback.
Reply With Quote
  #7  
Old 01-15-2013, 08:08 AM
OTPM OTPM is offline Summary Report for Individual Task Windows 7 32bit Summary Report for Individual Task Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
For any future reporting issues you could consider exporting the data to Excel and then filtering to achieve the report you want.
Hope this helps.
Good luck.
Tony
Reply With Quote
  #8  
Old 01-15-2013, 12:45 PM
JulieS JulieS is offline Summary Report for Individual Task Windows 7 64bit Summary Report for Individual Task Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Tony,
Not sure why filtering in Excel is any better than filtering in Project. Is there something I'm missing?

Julie
Reply With Quote
Reply

Tags
individual, report, summary

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary Report for Individual Task Costs are not adding to the summary task in cost1 column ketanco Project 1 06-14-2012 03:23 PM
Summary Report for Individual Task summary task calculating from project start ketanco Project 1 01-02-2012 02:34 PM
Summary Report for Individual Task Report to Show Individual Assignments mikelanne Project 1 12-04-2011 11:51 AM
Task and Summary Durations JR_12 Project 0 10-15-2011 05:07 PM
VBA code to export individual task lists to Excel OTPM Excel Programming 0 05-24-2011 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft