Solved

Converting from Access Microsoft Project Server

Posted on 2011-02-15
7
471 Views
Last Modified: 2013-11-15
I have an Access 2007 database which imports Microsoft Project data via an Excel spreadsheet. There is now a push to use Microsoft Project Server to manage the data and to create reports. Not having any experience with Microsoft Project Server, I have a few questions:
1) Is there the flexibility to create custom reports, as is the case with Access? If so, are they created using Microsoft Project itself or are there other tools within Project Server that are used to customize reports?
2) I have heard that SQL server has some type of connection with Project Server. Is the data in Project Server stored within SQL?
3) What is the best way to get up to speed with Project Server?

thanks.
0
Comment
Question by:newbie46
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:dbase118
ID: 34896754
newbie,

1.) Project Server does have the capability to produce reports and to some extent customize them but it is not fully customizable in the way that a database application like Access has a full-blown report builder. The Project Server Report Pack does contain many useful reports but if you anticipate doing a lot of work with custom fields you might be limited by the reporting features out of the box.

2.) Yes the Project data can be stored in SQL when you use Project Server. This would allow you to write your own SQL queries and do reporting in a third party application if you needed more customizable ability.

3.) As far as getting up to speed on Project Server, I always preferred a hands on training session to learn something new because you get to see and touch it vice just reading about it in a book. THere are others that can get a reference book and just go to town. I guess it partly depends on your background and how much exposure you have had to it in the past.

If you are looking for a reference book recommendation. I think the following book on Amazon is a good entry level reference.
Microsoft® Office Project Server 2007: The Complete Reference

Hope this helps
0
 

Author Comment

by:newbie46
ID: 34896837
dbase 118,
Thanks for the information.
So, you are saying that custom fields can be created in Project Server?
If I store the Project data in SQL, can I use Access to create the reports?
I also learn best with hands-on training. What do you recommend to be able to 'see and touch it'?
Is it just a matter of learning Microsoft Project? Where does the custom field formatting and reporting capabilities lie, within Microsoft Project itself  or within Project Server?

thanks.
0
 
LVL 15

Expert Comment

by:dbase118
ID: 34897188

Both local and enterprise custom fields can be created in Project Server. The built in reporting, however uses only Standard fields.

I haven't done it myself but I don't see any reason why you couldn't use Access to pull the SQL data. If you are writing SQL to pull data anyway you might be able to get the reports you need without exporting though. Hopefully someone else can chime in with real-life experience on interfacing Project to Access.

As far as training there are probablly hundreds of options. Just do a web search for Project Server 2007 training and you will get a listing of seminars, training centers, web based instruction or even CBT options. Cost can range from couple hundred dollars for a CBT to a couple thousand for a week long boot camp. Again I think it depends on what your current level of comfort is and what roles you need to learn. If you are going to administer as well as use them more training is probablly required.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:newbie46
ID: 34897360
dbase118,
This information is very helpful. One last question from above:
Is it just a matter of learning Microsoft Project? Where does the custom field formatting and reporting capabilities lie, within Microsoft Project itself  or within Project Server?

0
 
LVL 15

Accepted Solution

by:
dbase118 earned 500 total points
ID: 34897544

Certainly knowing MS Project first would be helpful, but there will be additional  learning involved with the Project Server. Custom field formatting and reporting is a part of both pieces. If you are going to use the SQL reporting services and Project Server report pack though you will want to be comfotable with setting up custom fields in Project Server. Particularly if you anticipate using Enterprise custom fields which would be available in all Projects set up on the server.

If you anticipate managing multiple projects with similar fields then establishing your custom fields on the server would prevent you from duplicating effort and recreating them which you would end up doing in the front end application.

0
 

Author Closing Comment

by:newbie46
ID: 34897672
Thank you.
0
 
LVL 15

Expert Comment

by:dbase118
ID: 34897681
Glad to help. Good luck with it!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question