Can you use Crystal reports with MS project.

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
    - Determining what is a project Hello, I am working in a faily new company that determines a project (other than has a start and finish date) as something over 6 months long and greater than a specific dollar value eg. 200K. We are looking at revisiting this criteria. Does anyone have any experience or ideas on how other companies define a project? Thanks, Marc Tag: Can you use Crystal reports with MS project. Tag: 105326
  - 2
    - Help Getting EVM Started I'm trying to calculate EV in a WBS project plan that I've already completed. Do I have to save my baseline in order for the EVM table to calculate??? I've bought 3 books and no where does it give you a step by step breakdown of how to actually make the EV table work. Can someone offer a step by step take on how I should approach this or a website or publication in which I can get a better understanding. Ms. Conquest - Dept. Homeland Security Tag: Can you use Crystal reports with MS project. Tag: 105323
  - 3
    - How do I unlink subprojects to a master plan When I click on the subprojects it brings up "my documents" and is searching for a new file Tag: Can you use Crystal reports with MS project. Tag: 105322
  - 4
    - Cost vs Billing Hello, Currently I'm using project to track my resources, time estimates, and some invoicing projections. I wanted to expand it to track the cost of a project against what we billed for the project, to track the gain/loss. Some of the things I want to include are Hardware purchase price Hardware resale price Employee Hourly cost to my company Employee Hourly billable rate to the customer Fixed price cost of a task. I would then like to correlate this into a report to perhaps show monthly or quarterly the financial status of a project, as well as the work load status. Is this even possible with Project? If it is, does anyone have recomendataions on some tutorials or books I can get my hands on to bring myself up to speed? Mike Tag: Can you use Crystal reports with MS project. Tag: 105321
  - 5
    - Vacation view How can I combine the task view and the Gantt?? I=B4d like to make a new view containing only the task Vacation/Holiday fra the Adm project and the resources listed below the task (taskview) but I=B4d like to have a gantt view instead of a timeshett to the right- how can I do that Tag: Can you use Crystal reports with MS project. Tag: 105315
  - 6
    - earned value if i have task of 4day duration,it starts on 1jul & ends on 4jul & resource to it is 2labour at Rs 100/d.when i track it on 3jul it is delayed in start by 1day & %complete is 25%.if i see BCWP earned value on jul3 it should show me rs.200. but if u see according to status date it gives rs.600/- at 3jul. guide me Tag: Can you use Crystal reports with MS project. Tag: 105311
  - 7
    - Project 2002: Removing resource recalculates project durations... ...Prior to baselining, I have assigned a number of resources at 100% across a number of tasks, maximum one resource per task. If I remove a resource from a task, then durations are increased dramatically for no apparent reason and undoing makes no difference. I can't see why this is happening - can anyone explain? TIA, Amanda Tag: Can you use Crystal reports with MS project. Tag: 105310
  - 8
    - How I tract our Progress against baseline 1 in MS project I saved a baseline in my project and after a month few critical chages incorporated and save a new base line (baseline 1), now I would like to track actuals progress with latest base line instead of original baseline Tag: Can you use Crystal reports with MS project. Tag: 105301
  - 9
    - Project Server 2007 Where is the documentation for how to configure Project Server 2007? I have Sharepoint up and running and Project Server installed but don't know where to go from here... Thanks Tag: Can you use Crystal reports with MS project. Tag: 105298
  - 10
    - Linking Holidays into schedule by date I wanted to link holidays into the schedule by date and not task. Example: Christmas Holidays 5 Days - 25 Dec - 30 Dec Fabrication 40 Days - 01 Dec - 15 Jan How do I link them to count the holidays as well? Tag: Can you use Crystal reports with MS project. Tag: 105297
  - 11
    - status indicators formula Hello I need some help on a formula that can show graphical indicators for the below. I know how to set graphical indicators once a criteria is returned and I also know that there is a 'Status Indicator' column that can be used to provide about 60-70% of my requirements but am having trouble with setting up a formulat that can enable me to identify tasks as per below: NO INDICATOR - Tasks where the start date is greater than 3 weeks from today, i.e. Future Tasks RED - a) All tasks that have a Baseline finish or start that is different to the scheduled finish or start or b) Tasks that are not started and the start date is earlier than today. YELLOW - a) Tasks that are started but the end date is coming up in 3 weeks, or b) the expected % complete is less than the actual % complete for today. TICKING CLOCK - Task start date is coming up within 3 weeks but is greater than today's date. GREEN - All other tasks. Thanks in advance! Tag: Can you use Crystal reports with MS project. Tag: 105289
  - 12
    - email collaboration I am using email collaboration for external resources because our Project Server is not setup with an external facing web site. Many of these resources use HTTP email to communicate. Getting the WorkGroup emails to them is not a problem and neither is opening it and replying. But the reply always goes to the Outlook outbox. Is there a way to get it routed to the Outlook Express outbox instead? Or is there a way to move the mail from the Outlook outbox to the Outlook Express outbox. Or any other solution that allows the reply to be sent using HTTP. Thanks, JimS Tag: Can you use Crystal reports with MS project. Tag: 105284
  - 13
    - Reschedule Unstarted tasks - dont like the constraint Hello Experts, I like to use the "Reschedule Uncompleted work" command in MS Project but i have two problems with it. 1- I dont want to reschedule tasks that have already started. I only want to do so for unstarted tasks (Actual Start = NA) 2- I dont like the fact that Project assigns a constraint for the tasks. is there a way (probably a macro) that can push the task to the desired date(data date) by extending its predecessor(s) duration. That is one of the distinctions between Primavera and microsoft Project. Primavera will not let you keep an unstarted task in the past. help is always appreciated. Tag: Can you use Crystal reports with MS project. Tag: 105272
  - 14
    - How can I calculate the number of days missing the deadline? I am trying to create a report that shows deadlines and assigns a value of On Target, Yellow or Red. If I miss the deadline date I want to programatically assign a value of Red. How do I determine if a task is a deadline and how do I identify when it is late? I keep getting ERROR on any calculations. Tag: Can you use Crystal reports with MS project. Tag: 105267
  - 15
    - Organizing Project Plans We have implemented project server 2003. Currently we have 20 Plans. Out of the 20 plans a) 10 plans belongs to 4 divisions (Information Technology, Research, Products, and Field Operations) b) 10 Plans belongs to different product groups (Project Management, Program Management, BPR, Outsourcing, Six Sigma, Analytics, Modeling, RFID, Mobile, and Internal) Is there some way we can group these projects into 2 (folders or Categories or views) so that the project managers will be able to click on the top level and view the projects for that group. in other words, can the project manager view the information in the following format (tree structure similar to Windows Explorer view) 1) Divisional Plans 1a) Information Technology 1b) Research 1c) Products, and 1d)Field Operations 2) Major Products Plans 2a) Project Management 2b) Program Management 2c) BPR 2d) Outsourcing 2e) Six Sigma 2f) Analytics 2g) Modeling 2h) RFID 2i) Mobile 2j)Internal If there is a better way of displaying the same information, please suggest me. Thank you Sunny Tag: Can you use Crystal reports with MS project. Tag: 105265
  - 16
    - is this the right software for me? I am an IT guy for a development company who has about 4 developers, 2 sales and an acquisitions person (more employees coming soon). I am looking for a good project management software that has "bug tracking" capabilies for my developers. I want to know if this is relatively easy to use and will it do what I am looking for it to do. Right now I have the Microsoft Action Pack and have Access to the Microsoft Projects. Since I have not used a lot of Project Management software, I want to know what you guys think is the best thing to try to use and implement. What has worked for you and what hasnâ??t? Even thought this is a MS site and fourm, does anyone know of a better project management software with bug tracking capabilities? Thanks in advanced! Jess NTransit_TN@comcast.net Tag: Can you use Crystal reports with MS project. Tag: 105252
  - 17
    - How do I Change my forecasted start dates when work doesn't begin? I have a project task forecasted to start on 5/8, but work has been delayed and will not start until 6/9. Should I leave the forecasted date alone and put in an actual start date when work has begun? Or should I change the forecasted start date, knowning it has not yet beguN? Tag: Can you use Crystal reports with MS project. Tag: 105251
  - 18
    - "File Not Found" Message when Open etc. I have a project file that gives me a "File Not Found" message when I open it - sometimes repeatedly. I believe it's related to Visual Basic because I also get the message whenever I try to run a macro in this project. Can this be corrected without reconstructing this project file? Thanks, Will Tag: Can you use Crystal reports with MS project. Tag: 105250
  - 19
    - Customizing Task Details Form Is there a way to customize the Task Details Form. I know that you can copy or edit the custom forms, but the standard Task Details Form doesn't seem to fall in this category. I would like to be able to view predecessor, successor, and resources all at once (without pulling up another window or dialog box). Thanks, Will Tag: Can you use Crystal reports with MS project. Tag: 105249
  - 20
    - Limiting Resource Usage View to a Specicf project on Project Svr I'm the Project Server Admin for our company. When I review Resource Usage on my cptr. it only displays the task the resources are assigned to for that project (2003). When other users look at Resource Usage their view shows all tasks on all projects their resources have been assigned to. Ideally I would like to be able to look as Resource Usage from both a project specific level (to aid project leveling) and from a portfolio perspective (to better allocate all resources within the company) Thanks in advance for any thought or help. Tag: Can you use Crystal reports with MS project. Tag: 105248
  - 21
    - How do you import multiple resources from Excel to MS Project? Hi, I am trying to import tasks into Project 2003 with multiple resources assigned. I have a map that very successfully brings task name, start, and duration from Excel into my Project file. I have another map that adds in Resource Name, Work, and Actual Work. If I just have one resource per task, I don't have a problem; however, if I have two or more, it will only import the first resource and ignore the rest. Is there a way to do this? Thanks! Tag: Can you use Crystal reports with MS project. Tag: 105245
  - 22
    - Project server config - beginner question Hi all, i am a asp.net / C# Developer who recently was charged with setting up and configuring project server. I know only the basics of project and need some help. So couple questions: 1) I set it up in enterprise mode. I read the admin guide and decided on this because we have about 10 core members (who will be using project) we all work on many different projects and i wanted a consistant calendar for all projects. Now that its set up im having problems understanding the Global Template and the fact that i cannot upload my projects because they dont conform to the global template. Was this the best approach? 2) Web access for my project server always crashes in the admin section when trying to display anything in a dataGrid type list. 3) How do i modify the global template and what should i set in it to properly allow a variety of projects to be added? thanks in advance mcm Tag: Can you use Crystal reports with MS project. Tag: 105237
  - 23
    - What is Owner, Manager and Project Manager We have just started using MSProject and Project Web access. I noticed that this question is similar to some of the other questions already out there. What is the definition of Owner, Manager and Project Manager as the software sees it. I have read some of the other correspondence and found it helpful but need further clarification. Where does Project Web pull from MS Project information to populate the Lead Resource field. Tag: Can you use Crystal reports with MS project. Tag: 105236
  - 24
    - Project Calander I created some calanders by going to "tools", and then "change working time". I'm using Project Enterprise 2003. I want to rename and delete some of the calanders. Is there a way for me to do that. Thanks in advance for your help. Tag: Can you use Crystal reports with MS project. Tag: 105231
  - 25
    - Superior task, where start date and end date defines the earliest start and the latest date of subordinate tasks I am trying again. Now WITH a subject :-) Hi I have some tasks that has to be executed within a time span defined by a start date and an end date. I want to see a superior (Level 1) task, where start date and end date defines the earliest start date and the latest end date of all subordinate (Level 2) tasks. If I accidentally go beyond the bound dates given by the superior task the tasks should be marked specially or a warning should pop up. Have anyone "out there" an idea how I solve this problem? In the very end I am going to write a VBA-macro, that create both the superior task and the subordinate tasks. Then it is only manual work to push and pull the subordinate tasks to fit in the superior time span. Using: MS Project prof 2003 Ebbe Tag: Can you use Crystal reports with MS project. Tag: 105216
- Next
  - 1
    - Saving Project as a PDF I have a need to be able to email my MS Project file to some folks who don't have Project on their computer and was told that it's possible to save as a PDF file. Looking at 'save as' options, I haven't seen that - can anyone help? TIA Tag: Can you use Crystal reports with MS project. Tag: 105215
  - 2
    - Able to change default rule for collapsing and expanding tasks Hello, When I click on a Summary Task by default every task underneath it is expanded. This results in my having to go to each '-' sign and select it so that the tasks collapse again. I know I can use the outline levels but this doesn't work well for me b/c in one project I basically have several different events I am planning for. I am looking for a rule/option that says by default all summary tasks are collapsed versus expanded. Does it exist? Thanks, Paul Tag: Can you use Crystal reports with MS project. Tag: 105213
  - 3
    - PWA Timesheet and not entering a Zero value in actual Work Hi We are going to start using PWA for the first time in our enterprise and I'm a newbie with tools. I heard through the grapevine that if an assigned resource on a current task doesnâ??t enter the value 0 in the act. work, this could have an impact on the schedule or in the way background calculation is done. In other word, if no value is entered (keeping the field to NULL), we can have some issue. I want to ask to resources to enter a zero when they have not work on a task during a day. As you can imagine, they will probably be have some objections to do it asking to me why PWA doesn't understand a null to be as a zero. What is the impact of not enter a zero. Is the impact is affecting the schedule? I did some test and the progress into MS-Project is working correctly using Null or a zero in Percentage completed. Is the impact is then more related on budget or on resource usage calculation? Can you please, explain to me the importance to enter a zero instead of just keeping the null value into PWA? Thank you to all for you great support thought this forum. Tag: Can you use Crystal reports with MS project. Tag: 105212
  - 4
    - Making row height adjustments permanent Can anyone tell me how I can make my manual row height adjustments permanent so that they remain after I close and reopen my schedule? About 50 of my 300 activities need row heights of 2 to show the wrapped text. After manually adjusting them all, saving, closing, and re-opening the file, they have all reverted to a row height of 1. Thanks very much. Tag: Can you use Crystal reports with MS project. Tag: 105209
  - 5
    - Scheduling back from a milestone date I am using a contractors Programme of key delivery dates to setup a commissioning programme for our company. Basically I am working back from these key dates to look to what needs to be done, the relationship I have been using is a start to finish relationship which seemed to work fine. I was however also using a late as possible constraint to move my tasks forward to this date. This is fine for a simple programme but I found that for our contractors programme the sub task which drive the completion date defaults to the larger hammock on the contractors programme. Any suggestions, was on the right track at the start? Tag: Can you use Crystal reports with MS project. Tag: 105203
  - 6
    - Solutio Explorer i want to project run in one solution ,is it possibel, if posible,how to code,please answer me. Tag: Can you use Crystal reports with MS project. Tag: 105200
  - 7
    - How do I use Project03 with Pre-Project98 programs I don't have access to the version used in 1997 but need to access the programs. How do I do this? Tag: Can you use Crystal reports with MS project. Tag: 105199
  - 8
    - Project cannot open the file We just installed Project Server 2003 in our team. I created a resource pool and, resource groups which are : Project Managers and Team members. We use Windows authentication. Only Project Managers have access to Project Professional 2003. Others have access to PWA. To the rest of the Project Managers (around 20people), they can access the server and the files in the server. For 2 Project Managers they can access the server but they can't access the file in the server. The error message given are : Project cannot open the file. Check that the file name and path are correct. Check that the file format is recognised by Project....etc. Can you help? Grin Tag: Can you use Crystal reports with MS project. Tag: 105195
  - 9
    - Circular Relationships I've inherited yet another bastardized Project file! This time when I open the file I get a mesage each time informing me that there is a circular reference problem (sample message below). Each time I resolve a circular reference, I save the file & close out. Upon re-opening, I'm greeted with yet another CR problem...it's a never-ending cycle. All suggestions or ideas appreciated. --Randy No calculations can be performed now. There is a circular reference in task 569 Labeling of <project file name>. The successors of this task refer back to the task or its predecessors, causing a circular reference. To remove the link that is causing the circular reference, select the two tasks that are causing the circular link, and then click Unlink Tasks on the Standard Toolbar. Tag: Can you use Crystal reports with MS project. Tag: 105188
  - 10
    - Modify project properties company name in VBA Hi, I'm having a hard time determining how to modify the company field in the project properties summary tab through VBA. I'm trying to create a macro that would modify this field if there were more than 16 characters. Any help is appreciated. Tag: Can you use Crystal reports with MS project. Tag: 105186
  - 11
    - Is there a way to overlay 2 projects together? Is there a way to overlay 2 projects together? I screwed up and did a basline in one file and the actual schedule in another. I want to know if I can link or overlay these together to see them both. Tag: Can you use Crystal reports with MS project. Tag: 105178
  - 12
    - Why do headings to summary tasks calculate incorrectly? When I put in work, actual work, and remaining work hours, project calculates incorrectly for main header task. For example, I have a heading, sub-heading, then task list. I have work hours entered for the task list, and the sub-heading calculates correctly. However, the main header calculates way too many hours (for example I have manually put in 14 hours of actuals, and the main heading says there are 74...sub heading says the correct 14 hours), and can be manipulated by changing start and finish dates. I don't want start and finish dates to affect ANY work numbers. I only want dates as references, not as active parts of the project. I only care about work, actual work, and estimated work to complete. Tag: Can you use Crystal reports with MS project. Tag: 105177
  - 13
    - Date Differences for work days only I want to compare two dates to determine the number of work days that they differ by - similar to the NETWORKDAYS function in excel. I am using this to generate status based on the difference and I don't want to have weekends or holidays to negatively impact the calculation. Tag: Can you use Crystal reports with MS project. Tag: 105175
  - 14
    - Start Date contraint Is there a way in Project to specify that a task can only be performed on a certain day of the week? In other words, I link Task B to Task A, and Task A finishes on Mon., which puts Task B starting on Tues. However, this particular task can only be performed on Wednesdays. Other than hard-coding the Start Date (which I don't want to do because that removes the flexibility of Project), what options do I have. Thanks Tag: Can you use Crystal reports with MS project. Tag: 105172
  - 15
    - Sharing files with non-Poject users I need to share a Project file with non-Project users? Is there a way to export to another program? What format would I use? Thanks. Tag: Can you use Crystal reports with MS project. Tag: 105169
  - 16
    - Single column Indenture from MS Project to Excel I am trying to keep the indenture that MS Project has when I export to Excel. I have seen several macros that indent by moving the indenture into the next cell. I want to keep all of the task names in one column and indent with spaces so that I can do searches and filters on all of the tasks names at once. Is there a way to do this automatically? I also want to know if anyone has a macro that can add spaces to the task name based on the outline code. Thanks, Carlos Tag: Can you use Crystal reports with MS project. Tag: 105162
  - 17
    - Can I use Microsoft Project on both pcs and macs at the same time Tag: Can you use Crystal reports with MS project. Tag: 105157
  - 18
    - Importing workplan from excel I am having an issue brining in my workplan from excel into project so that it formats correcly, does someone have documentation on how to do this? Tag: Can you use Crystal reports with MS project. Tag: 105154
  - 19
    - insert watermark into Microsoft Project 2003 How do I insert watermark into Microsoft Project 2003 doc? Tag: Can you use Crystal reports with MS project. Tag: 105153
  - 20
    - Shading of Task Rows Is it possible for Microsoft to allow Shading or Colours to be inserted into task rows to make each task easier to distinguish ie able to fill the task background with colour -- Ashley Planner Australia ---------------- 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=5c87de5c-2a82-4e9b-ac70-3f37af94801f&dg=microsoft.public.project Tag: Can you use Crystal reports with MS project. Tag: 105151
  - 21
    - SQL Query To Recreate Task Usage I am trying to recreate the MS Project Server 2003 Task Usage Report outside of MS Project. I have a SQL query that works for most days but it seems to stop reporting correctly when I get close to the current date. Does anyone know of a better query to use or another table that I should be looking in? Here is my query: SELECT AssignmentTimeStart, SUM(AssignmentTimeCost) * 0.00016665 AS Work FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY WHERE (ProjectUniqueID = 758) AND (AssignmentTimeStart > CONVERT(DATETIME, '2006-02-15 00:00:00', 102)) AND (AssignmentTimeFinish < CONVERT(DATETIME, '2006-07-26 00:00:00', 102)) GROUP BY AssignmentTimeStar Tag: Can you use Crystal reports with MS project. Tag: 105150
  - 22
    - Cost 1 Field Hi, Is there anyway I can get the Cost 1 Column to roll to the Summary level? I need to track Travel Cost separately, and up to this point I've been copying the column to excel to caculate. Thanks -- Cid Bell Tag: Can you use Crystal reports with MS project. Tag: 105149
  - 23
    - Shading every second row in the Task Line Please let me know if it is possible to do this as the people I work for have reverted to Exel because Management prefer the ability to highlight every second row so it is easy to distinghish between the Tasks I know this is a bit wierd but if someone can help it would be much appreciated as it is far easier to work in project for scheduling than exel Tag: Can you use Crystal reports with MS project. Tag: 105142
  - 24
    - maximum of days per resource ? Hi there, does anybody know whether I can set a maximum number of work days for a resource ? Thank you. Udo Tag: Can you use Crystal reports with MS project. Tag: 105135
  - 25
    - Task Duration Graphic On the Gantt view the graphic shows the tasks shorter than expected although it's correct in the duration column a dotted line similar to a split task appears. I have seen this several times before and don't understandIs is this a bug in MSP? Phil Tag: Can you use Crystal reports with MS project. Tag: 105123

Can you use Crytal reports with MS project and if so what type of data base
doy you slect? Do you have to have anything special to do this?

Top

RE: Can you use Crystal reports with MS project. by Ratheesh

Ratheesh
Thu Jun 08 13:06:02 CDT 2006

Crystal Reports is used to design and generate reports based on a wide scale
of data sources, such as databases like Microsoft SQL Server, Microsoft
Access, MySQL and Oracle, spreadsheets like Microsoft Excel, text files,
You can save your MS project as a .mdb file ( file -> save as -> select the
type as .mdb) and use Crystal Reports

Hope this helps.

"tomo" wrote:

> Can you use Crytal reports with MS project and if so what type of data base
> doy you slect? Do you have to have anything special to do this?

Top