Querying in Project

D

Don W

I've heard there are query capabilities within MS Project
2002. Has anyone used these and is it easier than
exporting to Excel and manipulating? I looking for new
ways to get different cuts on data.
 
R

Rob Schneider

Don said:
I've heard there are query capabilities within MS Project
2002. Has anyone used these and is it easier than
exporting to Excel and manipulating? I looking for new
ways to get different cuts on data.
Click to expand...

It doesn't have querying as in SQL or like Microsoft Access works, but
it does have filtering, groups, and tables which can be set to define a
view ... not sure this is what you are expecting...
 
K

Kevin Flanagan

You can query directly to the SQL database. We are using
ASP pages for custom reports for the things we can't
slice and dice in Analyzer or Project/Resource center
views.
 
R

Rob Schneider

Kevin said:
You can query directly to the SQL database. We are using
ASP pages for custom reports for the things we can't
slice and dice in Analyzer or Project/Resource center
views.
Click to expand...
*snip*

Kevin,

Ah. Yes. in my reply I completely neglected to remember the server-side
store that some use. thanks.

rms
 
D

Don Wood

Do you have a good resource for table layouts and some
good queries for slicing/dicing? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slideshow with black border around it 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How can the font and size of (all) citation numbers be altered? 1
Need Help with Macro Security 1
Mail Merge query 1
Using project as a resource tracker 0
Merging from an Excel file with graphics 1

Top