Adding parameter-based info to report header

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Can row height changes be saved in Project Pro 2003? After changing individual row heights in Project Pro 2003 and saving, I reopen the file only to find that the row adjustments have not been maintained. Is there a way to maintain the custom heights of individual rows? Thanks. Tag: Adding parameter-based info to report header Tag: 87345
  - 2
    - Web page to initiates my project team? I work in a new project team in a large organization. We would like to have our customers fill out a list of simple questions via the web then my manager be able to task and prioritize the tasks and if possible hook MS Project into it for updates. Is there such a program out there? Tag: Adding parameter-based info to report header Tag: 87344
  - 3
    - How can I make 1 task show as a diffrent color on the calender. How can I make 1 task show as a diffrent color on the calender without changing all the other task colors? Tag: Adding parameter-based info to report header Tag: 87342
  - 4
    - how do I schedule defragmentation, spryware, etc ? How do I schedule my pc to perform defrag, spyware, etc? Tag: Adding parameter-based info to report header Tag: 87331
  - 5
    - Does MS Project have possibility to draw S curve automatically? And if yes, how. I hope this question is clear on this forum. Tag: Adding parameter-based info to report header Tag: 87330
  - 6
    - Consolidating Projects / Resources In MS Project 2000 I am trying to consolidate two projects which use resources from the same resource pool (via Tools, Resources, Share Resources, Use Resources from). When I insert the project files in a third one, the consolidating file, I can see workload per resource and the origin of the load, i.e. the project name and the task ID. But, this only works when the project files use the same resource pool file. Because the project files were created on separate, not network connected PC's, there is not one resource pool files, but two. In that case the consolidating project file does not add up the load per resource name but keeps them separate. In the help files / Office Assistance on Internet in 'remove duplicate resources when consolidating projects' it is explained how you can eliminate the duplicate resource names, i.e. unlinking the subprojects from their source file. This works, but has the disadvantage that all tasks lose the connection to the original project file. The result is that the load per resource is correct and the tasks that cause the load are visible in the resource views. But not visible is to which project each task belongs (all tasks now belong to the consolidating project). Is there a solution for this, i.e. merging the resource pool files of the separate projects, adding a project ID to each task that ìs visible in the resource views, or otherwise? (At this time I am not considering using Enterprise Projects). Thanks for your help, Hans Flippo Tag: Adding parameter-based info to report header Tag: 87328
  - 7
    - Dawn I have a problem with cd cause i can't start it cause i don't have the acess code how do i get them for 2001 mircosoft works 6.0 Tag: Adding parameter-based info to report header Tag: 87324
  - 8
    - Manually allocating time over several months Hi, As part of some resource plannig we're doing, I'd like to be able to manually allocate effort to resources over the following few months. For example, ResourceA will have 21 days assigned to TaskA, and I want him to be assigned for 5 days in the first month, 4 days in the second month, 10 days in the third month and 2 days in the fourth month. I can't for the life of me figure out how to do this in Project, alothugh I recall being able to do this in ABT's (now Niku's) PMW/Workbench. Thanks in advance for any help! Roger Tag: Adding parameter-based info to report header Tag: 87322
  - 9
    - Problem with MSP_VIEW_* tables The vwnotify.exe is used to update MSP_VIEW_* tables. IsnÂ´t it? The problem is that sometimes the information corresponding to a project is not updated in those tables. Does anybody know which is the reason that makes this problem occur ? Thanks a lot. Tag: Adding parameter-based info to report header Tag: 87321
  - 10
    - Microsoft Project Standard 2003 addition problems I am unable to get a column to add the sum total at the bottom. I go into Tools/customize/Fields, then click formula, but just can't seem to figure out how to add the total of the column. I am familiar with excell, and have tried to use the formula for addition, but it will not work. I just need help in finding a simple solution to adding a column total that already exists. Thank you very much! Steve Tag: Adding parameter-based info to report header Tag: 87317
  - 11
    - Subprojects Hello, I am using MS PROJ 03 and MS PROJ SERVER 03. I am trying to setup an "Installation Project". This will easily allow my Installation manager the ability to schedule our two installation people from one place. I would like those assignments and the work and actual work to appear in the actuall customer project that it is applicable. Is there anyway to accomplish this? THere would likely be two installations per customer project. ie Lab install, Production Install Any help would be greatly appreciated. -- RRR Tag: Adding parameter-based info to report header Tag: 87315
  - 12
    - "Automatic" Calculations I'm using MSP 2003 Server. I'm created a custom field that can be used in the PWA project center to display whether or not a project needs to be published (i.e. has any task(s) where the Update Needed flag is set to "yes"). To do this, I did the following: Created a field called [Tasks Not Published] using [Enterprise Flag2]. The formula simply makes this field = [Update Needed] and then uses an "OR" in the rollup to get any "Yes" to rollup to the project/summary level. Created another field called [Published] using Enterprise Project Text8 with the formula ... IIf([Tasks Not Published],"No","Yes")). The above works fine except for one thing. In order to get it to do the calculation, I have to open each project and manually calculate. The problem starts with the OR in the [Tasks Not Published] field. For example, I move a task so that the [Update Needed] flag changes to yes for that task. At that point, the [Tasks Not Published] field for that tasks immediately changes to "Yes"; however, the OR is not automatically calculated, so the "Yes" does not roll up. If I manually calculate, the OR kicks in and the Yes rolls up. I have the calculation options set to Automatic for All Open Projects. So what does that mean? It doesn't really automatically calculate all open projects? If it does, what is it "automatically calculating"? I thought that maybe it didn't recalculate until you saved it and/or only when the project is opened, but it doesn't work either way. I'm having this same issue with other custom fields I've created. Any suggestions? Thanks. Dave Tag: Adding parameter-based info to report header Tag: 87312
  - 13
    - Mirosoft Project 2000 When opening the Microsoft Project .mpp file, we receive an error message that states the following: "The paste operation cannot be completed." When we click ok the Resource Names are no longer present. What is causing this problem and how can it be repaired? Tag: Adding parameter-based info to report header Tag: 87249
  - 14
    - VBA for Project Thanks, all you guys for your comments they really helped. Everything is working just the way i want it to Tag: Adding parameter-based info to report header Tag: 87241
  - 15
    - Exporting Time-phased data Hi, In the Task Usage view, the right pane shows cost, work, % complete, etc. but the only way I've found to 'export' this data is by copying and pasting the two panes (the left pane with the task rows, and the right pane with the time-phased data) into Excel. Is there a way to auto-magically export it all at once into a text file (.csv or .txt)? ~ Don Tag: Adding parameter-based info to report header Tag: 87239
  - 16
    - VBA for Project Hi, I am trying to customize my database using 2-4 filters at the same time. However, when I run it, the Filters Over-ride each other and give me the incorrect result. Is there anyway to go about solving this problem? I have read a book on VBA but it doesnt help. Is there a way of using VBA to solve it? Any Help would be Appreciated. Thanks Tag: Adding parameter-based info to report header Tag: 87233
  - 17
    - Cost factors of material resources hi, i got a situation. i have a pool of material resources. these materials have some standard cost on each unit being used. so i defined per use cost for each for them. but for some task if i use 2 units of that material resource, then the per use cost is accounted for only one unit. is there a way by which i can calculate the peruse cost for each unit of material resource being used?? someone pl help me out.. thnx & regards Eswar Tag: Adding parameter-based info to report header Tag: 87231
  - 18
    - Ignoring Resource Calenders While Scheduling hi, i have saved some test projects on to my test server and there are many common resources in those projects. wht i noticed is that the scheduling gets adjusted automatically based on the resource availability. so i removed this by checking "Scheduling ignores resource calanders", under Advance tab in Task Information Dialouge box. wht i want to know is: - are there any disadvantages of using this kind of scheduling? regards Eswar Tag: Adding parameter-based info to report header Tag: 87223
  - 19
    - MSP98 and 2000 compatible? I use MSP2000 at work and have to bring home the laptop every night. Big pain! I also found my old MSP98 CD, and still have the product key, license, etc. Q: can I save my schedules at work in the 98 version to be viewed at home? I don't want to install it unless this will work. thanks Tag: Adding parameter-based info to report header Tag: 87169
  - 20
    - Planning a wedding reception Has anyone tried using MS Project to help plan a wedding reception? Tag: Adding parameter-based info to report header Tag: 87149
  - 21
    - Enterprise Resources HELP! I recently imported a select number of resources from a project into the enterprise resource pool. This action made the balance of my resource non-viewable as enterprise resources - even when startin a new blank project I could not see my users using Build team from server. To UNDO the situation I used the Clean Up Project server.. and deleted the imported resources. This did not solve the problem. I still see no resources from PWS when I attempt to build team from PS. I wonder if this has anything to do with the fact I have a default set to administrator for Project server when I launch Project Office 2003. Does this affect the view to the enterprise? I don't see how but thought I would ask. Note: I am a user in PWS with administrator rights. I needed to set the project server accounts to Administrator in order to edit the global template. All I really want to do is get back to the state I was in prior to the Import of enterprise resources. There are only 15 users in PWS and it is not currently in use. What do you suggest I do? Tag: Adding parameter-based info to report header Tag: 87122
  - 22
    - How do I get my project summary bar back after deleting it in erro I've deleted my summary display bar in error. How do I get it back? All colors are set @ automatic. Tag: Adding parameter-based info to report header Tag: 87118
  - 23
    - Can I use project to track public event? Hi, I am wondering if I could user project 2003 to track public events. I guess I could enter each event as a task, and the internal contact as resource. But is there anyway I could enter the external attendees to each event? I am new to project, any help is much appreciated! -- -- Wei Tag: Adding parameter-based info to report header Tag: 87116
  - 24
    - Why is BCWP zero? I am just learning to manage costs using Project. I have baselined my project but my BCWP is still at $0.00 for all tasks. Naturally, that makes my CV equal to my ACWP. Any ideas to help? -- Jay R Tag: Adding parameter-based info to report header Tag: 87112
  - 25
    - vba datedifference type mismatch? hey! I want to use the datedifference function. and i want to use the "task calendar" as the calendar parmeter. something like this: ------------------------------------------------- dim activity as task For Each activity In ActiveProject.Tasks msgbox(application.datedifference("10.07.05","12.07.05",activity.Calendar) next --------------------------------------------------- but this result in a type mismatch error!!!! :( ("10.07.05","12.07.05",activeproject.Calendar) works fine. got a clue why? pls hlp -Bjorn , Norway Tag: Adding parameter-based info to report header Tag: 87104
- Next
  - 1
    - Installation question about location of Analysis Services/DSO Ok, I'm currently working on a project to install Project Server 2003 leaning more to a medium scale roadmap. I have only preformed small scale installs in the past having all services web and database on one server. Currently I have SQL 2000 Analysis Services/DSO, Project Server Front-End Service, and View Processing Services (everything but the sql ps database and sharepoint database) on one server. ServerX On ServerY I have SQL 2000 Server installed with Project Server database, SharePoint Content, and SharePoint Configuration databses installed. I'm now at chapter 8 Post installation task Page 130 in the Microsoft Office Project Server 2003 installation Guide. Section Migrate the Analysis Services Repository to a SQL Server Database. Question: I need to migrate the repository from ServerX where Analysis Services/DBO is installed to ServerY where SQL 2000 Databse is installed. There is no Analysis Services on ServerY with NO OLAP administrators group. The only OLAP group is on ServerX where all of the IIS services are installed. But the OLAP admin groups needs to be DB_OWNER for the repository. So, do I need to install all SQL Server services Analysis Services, DSO, and databases on ServerY to make this work? Am, I asking a question I already know the answer for? -- Hewitt Gordon Network/Desktop Analyst I HNTB Corporation 715 Kirk Dr. Kansas City, MO 64105 Tag: Adding parameter-based info to report header Tag: 87101
  - 2
    - MS Project 2003 I have just installed Project 2003 and am having a lot of problems. Initially these related to the program looking for GBUI://mainpage.htm/ but I managed to fix this using technical support. Now the program opens but the default entry screen is totally missing - the screen is totally blank. I have tried everything to resote - even if I load an existing Project - it appears to open but is completely blank. Help! Thanks Tag: Adding parameter-based info to report header Tag: 87098
  - 3
    - how can I show cost savings achieved for an efficiency programme I'm trying to use Project to report cost savings arising from a number of strands of an efficiency programme Tag: Adding parameter-based info to report header Tag: 87097
  - 4
    - Copying Environments to other users I am attempting to prepare our Department to use MS Project. I need an environment with everyone having access to several custom macros, tables and views as well as starting with the same Option settings. I copied the Global.mpt with all those objects and settings to a common network folder. To test it, I copied that Global.mpt to another person's PC (we have MS Project installed on each person's PC - no Enterprise version). When I opened project on their machine, it indeed showed the macros, tables and views as desired, but NONE of the option settings came through. Are these not kept on Global? Is there a way, outside of having each person set their own options using instructions I would supply, to set these options automatically? Tag: Adding parameter-based info to report header Tag: 87093
  - 5
    - Removing tasks from a timesheet Hi, does someone know a solution to the following problem: When tasks have been assigned to users within Microsoft Project, once a user has completed the task and is no longer going to be doing anymore work on the task, can this task be removed from the users timesheet. Thanks, Hema. Tag: Adding parameter-based info to report header Tag: 87092
  - 6
    - filter blank lines in gantt chart hi, I have a gant chartt with some empty task lines in it, this helps readability IMHO. Now when I run a filter to print only certain tasks is there a way to keep blank lines included? I don't want to add something in the blank line as this messes up the other fields for that task. thanks Tag: Adding parameter-based info to report header Tag: 87090
  - 7
    - Viewer for Project? My contractor uses MS Project and he wants to send me his draft schedule. How can I view the schedule he has created? Is there a Viwer that5 I can download? Or, can he export the Project schedule to an alternative program such as Excel? Bill Starbuck (MVP) Tag: Adding parameter-based info to report header Tag: 87089
  - 8
    - Need help using xlt. file I d/l a template from Microsoft office and when it asked me to save it, I saved it under my docs./my received files. I saved as : 01018311 XLT.file Now I can't open it. I don't have excel, but it said I could extract it. How?? Please can someone help? Thanks! Tag: Adding parameter-based info to report header Tag: 87088
  - 9
    - Comparison to Niku Workbench I am looking for the opinions of those who have experience with Niku Workbench (which is a project management software program similar to MS Project). How does Workbench compare to Project? Is there a big learning curve? Seems like there would be. How is the support? Can anyone suggest readings to compare the two products? I have not seen a single book on Workbench. Any viewpoints on the two products would be most appreciated. Thanks. - - - jzis Tag: Adding parameter-based info to report header Tag: 87087
  - 10
    - Remove a task from the critical path How can you remove a task from the critical path? I have a hammock task that moves with the end date, but its not critical. It moves with the end date because its a support task that needs to keep going as long as the project is going. However, because it extends to the end of the project, MSProject is marking it as a critical task. Any ideas? Tag: Adding parameter-based info to report header Tag: 87078
  - 11
    - Showing Resource allocations on one page Opening resource allocations indicates 200% useage for one person on one day, so okay, I goofed something, but the print version is about 30 pages! [almost a year] Yes, I can print just that one page, but is there an option that compresses resources to one graph? Or chart? Not pages of bars? Tag: Adding parameter-based info to report header Tag: 87077
  - 12
    - How do I find a template for an APA Research Paper? How do I find a template for an APA Research Paper? Tag: Adding parameter-based info to report header Tag: 87075
  - 13
    - How do I add a watermark symbol (Ex. "Draft") to MS Project file Tag: Adding parameter-based info to report header Tag: 87069
  - 14
    - Material Resource overload Hi, I have a question on overloading materials in MS project 2003. when you create work resources you can set max units so it will show you the overallocation of your resource. However, it is not possilbe to do that with material resources. lets say I create a material resource and want to set a max unit to use during the project so MS project can tell me that I exceeded that amount. is that possible. help is appreciated Tag: Adding parameter-based info to report header Tag: 87065
  - 15
    - Scheduling with a deadline while behind schedule Here is my problem: I'm currently scheduling so that production ends on the deadline however we are behind schedule. When I update the schedule to move all of the late tasks to the current date it just piles them up on that date with no regard for predecessors. I realize the problem is that I'm scheduling with conflicting constraints but is there some way to resolve this? I would like to spread everything throughout the time window and maybe adjust the max units of my resources to account for overallocations. Thanks for your help. Josh Tag: Adding parameter-based info to report header Tag: 87064
  - 16
    - Managing Consultants I'd like to set up consulting assignments as tasks in my project. I'd like to be able to record invoice amounts against the contract value. This does not need to take the place of the % completion calculation, but rather, provide a method to summarize the actual costs to date. Example: Hire an architect to design a building. The contract is for $30,000. At the end of the first month, I recieve an invoice for $7453.22. The second month I recieve an invoice for $6781.58. How can I show this in MS Project? Tag: Adding parameter-based info to report header Tag: 87063
  - 17
    - Excel VBA to create and populate a MS Project file What i have now is a Project file with "links" that whenever a change is made to the outlook file, it's reflected in the Project file, but it's not working out exactly how we'd like it to. I am unable to remove the links using a macro/VBA in excel (Where all of the operations are running from) so the file always asks if one would like to update the linked information whenever changes happen in the Excel file, which is not what we want. Once exported, the Project file should become static. A Project file that has all of the information that was displayed in the above table at the time of running the macro, but will not change or ask to be updated. Of course there probably are other ways to do this better, like Projects mapping feature to open an exported XLS file or possibly just simple copy/pasting within the macro, but i can't for the life of me figure my way around the syntax and funtionality of controlling Project from Excel. I'm going to try and summerise just to be clear. 1) Data in excel populates the a table with info for the tasks, start/end dates and resources of a specific project. 2) A button labelled "Export to MS Project" is clicked in the Excel file. 3) A series of VBA steps end with a MS Project file saved and closed which contains all of the Task Names (5 to 10 of them), Start and end dates, and resources from the excel file. Tag: Adding parameter-based info to report header Tag: 87059
  - 18
    - How do I change task name's background color? How do I change the background color of task name in gantt chart in Ms Project Tag: Adding parameter-based info to report header Tag: 87056
  - 19
    - Slip task I understand how to split a task, but here is my problem: Task Start date of 4/11/05 - Finish date of 5/24/05 (20 days duration) There was a interrupt to ONLY this task that delayed the task from starting/finishing on time, the delay started on 4/11/05 resume work on 4/28/05 (duration 13 days). Instead of an interrupt to the calendar (cause this will effect all of my task) I split the task - I can't get the split to start on that day, it wants to start on the 4/12. My question is: Is there any way of adding columns for split task that shows "Stop Work" (date), "Resume Work" (date), and "Duration of Interrupt" (days? And yet still be able to show on the Grant Chart as a split to the task on the bars? Tag: Adding parameter-based info to report header Tag: 87055
  - 20
    - Outlook Integration Wizard / Addin for Project 2003 I use Project 2003 Pro - standalone, with no server tiein. I would love to have the tasks synched up with outlook tasks. I have been hunting for the addin but I cannot find it. Is it a component of the server? or can I use it without the server component. The local help says to go to MS Project Web Access, but I cannot find this url; I'm thinking that this too is a part of the project server. I look forward to your feedback. Thanks again, Rick PS - Yes, Toby did eat my shoe :) Tag: Adding parameter-based info to report header Tag: 87054
  - 21
    - How to change pjDate_Www_dd ? A question that many people has asked in MP forums is not yet responded. When we choose the date format w5/1, MP shows dates in this new format, but the problem is that the week showed might not be the one we need. For example, as of this week, MP shows W29/4 for today, and what I understand, and also I need, is to show W30/4 (for the same date, July 21, 2005) Is there a way to create a macro to change how MP displays that date when the date format W5/1 (pjDate_Www_dd) is choosen ? Something like : new_ww = ww +1 pjDate_Www_dd = pjDate + _'W_' + new_ww + '_dd' ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=7d39f38c-10fa-4f83-9de5-5aff774abcdb&dg=microsoft.public.project Tag: Adding parameter-based info to report header Tag: 87053
  - 22
    - How can I get the Adobe PDF Maker 7.0 toolbar into MS Project 03? I have already uninstalled Adobe Standard 7.0 - installed Microsoft Project 2003 - and then reinstalled Adobe Standard 7.0 Tag: Adding parameter-based info to report header Tag: 87045
  - 23
    - Can null value cells be shown as blank. Much of the project plan I am building has cells with null values. So I'm seeing pages of "N/A"s or 0's. I'd love to reset the default for an empty cell to show nothing a so make the project as a whole far more readable. Is there a way to do this? Thx Tag: Adding parameter-based info to report header Tag: 87044
  - 24
    - Can I network 2 computers 1 with ME and one with XP? I am trying to set up a network where 2 computers have ME and one has XP. I can recoginze and access the ME system from the XP, but not visa versa. Tag: Adding parameter-based info to report header Tag: 87043
  - 25
    - Automatic Gannt Bar formatted based on the resource assigned? Is it possible to have the gannt bar format automatic based on the resource assigned to the task using Project Pro 2003? Tag: Adding parameter-based info to report header Tag: 87041

Is there a way to add code to a MS Project 2003 Professional report header to
prompt the user for input that would then appear in the customized report?
(Note: what would be input is not in an existing field.)

Top

Re: Adding parameter-based info to report header by Rod

Rod
Wed Jul 27 00:17:04 CDT 2005

Hi,

Yes, I would add code to prompt for the data and store it in something like
one of the file properties that can be displayed in Report headers
automatically (such as Subject etc). The code would then print the report or
print preview it.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

"Sandi" <Sandi@discussions.microsoft.com> wrote in message
news:7461309C-655A-45D7-A606-BD65B387DACC@microsoft.com...
> Is there a way to add code to a MS Project 2003 Professional report header
> to
> prompt the user for input that would then appear in the customized report?
> (Note: what would be input is not in an existing field.)

Top