Solved

Converting from Access Microsoft Project Server

Posted on 2011-02-15
7
462 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now