Custom reports MS Project

R

rothmanss

Hi there,

I have an question concerning reports (or views) at MS Project. I use that
SW as a capacity planener. So I need to create some custome reports (logo,
picture, own text, selected columns...). As I know at MS Acces it is no
issue. But what about MS Project.
When I did search at internet, I found 2 solutions:

1) Export to MS Excel selected data
2) Programm in VBA or a code

Are really only those 2 options? Do You have a tip how to create easilly
custom reports?

THX for support


__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) __________

Tuto zpravu proveril ESET NOD32 Antivirus.

http://www.eset.cz
 
J

John

rothmanss said:
Hi there,

I have an question concerning reports (or views) at MS Project. I use that
SW as a capacity planener. So I need to create some custome reports (logo,
picture, own text, selected columns...). As I know at MS Acces it is no
issue. But what about MS Project.
When I did search at internet, I found 2 solutions:

1) Export to MS Excel selected data
2) Programm in VBA or a code

Are really only those 2 options? Do You have a tip how to create easilly
custom reports?

THX for support
rothmanss,
Project is good at planning and managing a schedule but not so good at
supporting fully customized reports.

Although logos and pictures can be imported and pasted on a project view
or used in a header, doing so may tend to bloat the file and take away
from the real purpose of the application - managing schedule plans.

However if your focus is more on creating pretty pictures then yes, you
will have better luck by exporting project's base data to another, more
graphics friendly application.

Project 2007 expanded the export capability by adding the Visual Reports
functionality but it still takes some effort to format the exported data
into the exact report you want. In my opinion the best option for
creating custom reports is via VBA. It takes some effort to set it all
up but once the code is in place, creating the report(s) is basically a
one button operation.

Hope this helps.

John
Project MVP
 
R

rothmanss

John,

Thank Your for your answer and confirmation what I already thought. I am
going to dwonload trial of Project 2007 and check those Visual reports.
Anyway, if those Visual Reports will be OK 4 Me, than I will have another
issue. How to convince our corporate IT to buy Project 2007 instead of
current 2000 :-( .

Anyway, thank You again for Your help.

David

John said:
rothmanss,
Project is good at planning and managing a schedule but not so good at
supporting fully customized reports.

Although logos and pictures can be imported and pasted on a project view
or used in a header, doing so may tend to bloat the file and take away
from the real purpose of the application - managing schedule plans.

However if your focus is more on creating pretty pictures then yes, you
will have better luck by exporting project's base data to another, more
graphics friendly application.

Project 2007 expanded the export capability by adding the Visual Reports
functionality but it still takes some effort to format the exported data
into the exact report you want. In my opinion the best option for
creating custom reports is via VBA. It takes some effort to set it all
up but once the code is in place, creating the report(s) is basically a
one button operation.

Hope this helps.

John
Project MVP

__________ Informace od ESET NOD32 Antivirus, verze databaze 4197
(20090629) __________

Tuto zpravu proveril ESET NOD32 Antivirus.

http://www.eset.cz


__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) __________

Tuto zpravu proveril ESET NOD32 Antivirus.

http://www.eset.cz
 
R

Rob Schneider

Might work on the IT Dept: That version of Project was developed
primarily in the last century before the 1/1/2000. It probably has "Y2K
Bugs".

--rms
 
J

John

Rob Schneider said:
Might work on the IT Dept: That version of Project was developed
primarily in the last century before the 1/1/2000. It probably has "Y2K
Bugs".

--rms
Rob,
Actually it doesn't. Project 2000 was a very good release. The only
update was SR-1 and once that was installed Project 2000 had far fewer
problems than later releases, at least in my opinion. The extra whistles
and bells that were added in later versions seemed to multiply the
issues that popped up, and still are popping up.

However, in order to maintain compatibility with other users, (e.g.
clients, customers, etc.), it is probably better to go with the most
current version.

John
Project MVP
 
J

John

rothmanss said:
John,

Thank Your for your answer and confirmation what I already thought. I am
going to dwonload trial of Project 2007 and check those Visual reports.
Anyway, if those Visual Reports will be OK 4 Me, than I will have another
issue. How to convince our corporate IT to buy Project 2007 instead of
current 2000 :-( .

Anyway, thank You again for Your help.

David

David,
You're welcome and thanks for the feedback. Good luck with your "sales"
pitch to IT.

John
Project MVP
 
R

Rob Schneider

If I understood the original posting, I was thinking of how to help
someone who had an IT dept who would prefer they get the the
"standard-but-hopelessly-out-of-date" version because that is what they
"support" vs. getting the "current" version to do great work. During
the late 1990's we learned that we could get anything from IT if it was
a Y2K issue.

(supposed to be a wee joke for old people who remember the last century)

All that being said, I agree Project has not really improved or changed
since the late 1990's and in some respects has gone backwards. I fear
Project 2010 will also probably have features removed.


--rms
 
M

Mike Glen

Hi rothmanss,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my free series for beginners on Microsoft
Project in the TechTrax ezine, particularly #24 on customizing reports, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP
 
K

Krishna Kumar

Question : If a successor is set as complete before the predecessor, what
happens to the dates?
if Task1, Task2 & Task3 are to be executed in that sequence and I mark
Task2
as complete before Task1, what happens to the plan for Task1 and Task3?

Thanks for clarifying!

Krishna
(e-mail address removed)



Mike Glen wrote:

Re: Custom reports MS Project
09-Aug-09

Hi rothmanss

Welcome to this Microsoft Project newsgroup :

You might like to have a look at my free series for beginners on Microsof
Project in the TechTrax ezine, particularly #24 on customizing reports, a
this site: http://tinyurl.com/2xbhc or this
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=2
(Perhaps you would care to rate the article before leaving the site, :
Thanks.

FAQs, companion products and other useful Project information can be seen a
this web address: <http://www.mvps.org/project/

Hope this helps - please let us know how you get on :

Mike Gle
MS Project MVP

Previous Posts In This Thread:

Custom reports MS Project
Hi there

I have an question concerning reports (or views) at MS Project. I use tha
SW as a capacity planener. So I need to create some custome reports (logo
picture, own text, selected columns...). As I know at MS Acces it is n
issue. But what about MS Project
When I did search at internet, I found 2 solutions

1) Export to MS Excel selected dat
2) Programm in VBA or a cod

Are really only those 2 options? Do You have a tip how to create easill
custom reports

THX for suppor

__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) _________

Tuto zpravu proveril ESET NOD32 Antivirus

http://www.eset.cz

Re: Custom reports MS Project
rothmanss
Project is good at planning and managing a schedule but not so good a
supporting fully customized reports

Although logos and pictures can be imported and pasted on a project vie
or used in a header, doing so may tend to bloat the file and take awa
from the real purpose of the application - managing schedule plans

However if your focus is more on creating pretty pictures then yes, yo
will have better luck by exporting project's base data to another, mor
graphics friendly application

Project 2007 expanded the export capability by adding the Visual Report
functionality but it still takes some effort to format the exported dat
into the exact report you want. In my opinion the best option fo
creating custom reports is via VBA. It takes some effort to set it al
up but once the code is in place, creating the report(s) is basically
one button operation

Hope this helps

Joh
Project MVP

John,Thank Your for your answer and confirmation what I already thought.
John

Thank Your for your answer and confirmation what I already thought. I a
going to dwonload trial of Project 2007 and check those Visual reports
Anyway, if those Visual Reports will be OK 4 Me, than I will have anothe
issue. How to convince our corporate IT to buy Project 2007 instead o
current 2000 :-(

Anyway, thank You again for Your help

Davi


__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) _________

Tuto zpravu proveril ESET NOD32 Antivirus

http://www.eset.cz

Re: Custom reports MS Project
Might work on the IT Dept: That version of Project was develope
primarily in the last century before the 1/1/2000. It probably has "Y2
Bugs"

--rm


rothmanss wrote:

Re: Custom reports MS Project
Rob
Actually it does not. Project 2000 was a very good release. The onl
update was SR-1 and once that was installed Project 2000 had far fewe
problems than later releases, at least in my opinion. The extra whistle
and bells that were added in later versions seemed to multiply th
issues that popped up, and still are popping up

However, in order to maintain compatibility with other users, (e.g.
clients, customers, etc.), it is probably better to go with the most
current version.

John
Project MVP

Re: Custom reports MS Project
David,
You're welcome and thanks for the feedback. Good luck with your "sales"
pitch to IT.

John
Project MVP

If I understood the original posting, I was thinking of how to help someone
If I understood the original posting, I was thinking of how to help
someone who had an IT dept who would prefer they get the the
"standard-but-hopelessly-out-of-date" version because that is what they
"support" vs. getting the "current" version to do great work. During
the late 1990's we learned that we could get anything from IT if it was
a Y2K issue.

(supposed to be a wee joke for old people who remember the last century)

All that being said, I agree Project has not really improved or changed
since the late 1990's and in some respects has gone backwards. I fear
Project 2010 will also probably have features removed.


--rms




John wrote:

Re: Custom reports MS Project
Hi rothmanss,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my free series for beginners on Microsoft
Project in the TechTrax ezine, particularly #24 on customizing reports, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you would care to rate the article before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
Break the Roles in SharePoint Lists
http://www.eggheadcafe.com/tutorial...7-42f2d9110d79/break-the-roles-in-sharep.aspx
 
M

Mike Glen

Hi Krishna,

Hope this helps - please let us know how you get on :)

When I get asks such questions, I always respond "try it and see!" I opened a new file. entered the 3 tasks, linked them and then entered 100% complete for task 2. Result - the progress line for task 2 was shown for the completed task. What did you expect? As far as project is concerned, task 3 is still due to start when 2 is finished, and if the Finish date of Task 2 hasn't changed, Task3 will begin then. The fact that tasks 2 shouldn't have started is of no concern to Project as it assumes you know what you're doing.

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials



in message Question : If a successor is set as complete before the predecessor, what
happens to the dates?
if Task1, Task2 & Task3 are to be executed in that sequence and I mark
Task2
as complete before Task1, what happens to the plan for Task1 and Task3?

Thanks for clarifying!

Krishna
(e-mail address removed)
 
A

alan_willpa

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com
 
A

alan_willpa

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com
 
A

alan_willpa

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com
 
S

salgud

Question : If a successor is set as complete before the predecessor, what
happens to the dates?
if Task1, Task2 & Task3 are to be executed in that sequence and I mark
Task2
as complete before Task1, what happens to the plan for Task1 and Task3?

Thanks for clarifying!

Krishna
(e-mail address removed)



Mike Glen wrote:

Re: Custom reports MS Project
09-Aug-09

Hi rothmanss,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my free series for beginners on Microsoft
Project in the TechTrax ezine, particularly #24 on customizing reports, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you would care to rate the article before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP

Previous Posts In This Thread:

Custom reports MS Project
Hi there,

I have an question concerning reports (or views) at MS Project. I use that
SW as a capacity planener. So I need to create some custome reports (logo,
picture, own text, selected columns...). As I know at MS Acces it is no
issue. But what about MS Project.
When I did search at internet, I found 2 solutions:

1) Export to MS Excel selected data
2) Programm in VBA or a code

Are really only those 2 options? Do You have a tip how to create easilly
custom reports?

THX for support


__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) __________

Tuto zpravu proveril ESET NOD32 Antivirus.

http://www.eset.cz

Re: Custom reports MS Project
rothmanss,
Project is good at planning and managing a schedule but not so good at
supporting fully customized reports.

Although logos and pictures can be imported and pasted on a project view
or used in a header, doing so may tend to bloat the file and take away
from the real purpose of the application - managing schedule plans.

However if your focus is more on creating pretty pictures then yes, you
will have better luck by exporting project's base data to another, more
graphics friendly application.

Project 2007 expanded the export capability by adding the Visual Reports
functionality but it still takes some effort to format the exported data
into the exact report you want. In my opinion the best option for
creating custom reports is via VBA. It takes some effort to set it all
up but once the code is in place, creating the report(s) is basically a
one button operation.

Hope this helps.

John
Project MVP

John,Thank Your for your answer and confirmation what I already thought.
John,

Thank Your for your answer and confirmation what I already thought. I am
going to dwonload trial of Project 2007 and check those Visual reports.
Anyway, if those Visual Reports will be OK 4 Me, than I will have another
issue. How to convince our corporate IT to buy Project 2007 instead of
current 2000 :-( .

Anyway, thank You again for Your help.

David



__________ Informace od ESET NOD32 Antivirus, verze databaze 4197 (20090629) __________

Tuto zpravu proveril ESET NOD32 Antivirus.

http://www.eset.cz

Re: Custom reports MS Project
Might work on the IT Dept: That version of Project was developed
primarily in the last century before the 1/1/2000. It probably has "Y2K
Bugs".

--rms




rothmanss wrote:

Re: Custom reports MS Project
Rob,
Actually it does not. Project 2000 was a very good release. The only
update was SR-1 and once that was installed Project 2000 had far fewer
problems than later releases, at least in my opinion. The extra whistles
and bells that were added in later versions seemed to multiply the
issues that popped up, and still are popping up.

However, in order to maintain compatibility with other users, (e.g.
clients, customers, etc.), it is probably better to go with the most
current version.

John
Project MVP

Re: Custom reports MS Project
David,
You're welcome and thanks for the feedback. Good luck with your "sales"
pitch to IT.

John
Project MVP

If I understood the original posting, I was thinking of how to help someone
If I understood the original posting, I was thinking of how to help
someone who had an IT dept who would prefer they get the the
"standard-but-hopelessly-out-of-date" version because that is what they
"support" vs. getting the "current" version to do great work. During
the late 1990's we learned that we could get anything from IT if it was
a Y2K issue.

(supposed to be a wee joke for old people who remember the last century)

All that being said, I agree Project has not really improved or changed
since the late 1990's and in some respects has gone backwards. I fear
Project 2010 will also probably have features removed.


--rms




John wrote:

Re: Custom reports MS Project
Hi rothmanss,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my free series for beginners on Microsoft
Project in the TechTrax ezine, particularly #24 on customizing reports, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you would care to rate the article before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
Break the Roles in SharePoint Lists
http://www.eggheadcafe.com/tutorial...7-42f2d9110d79/break-the-roles-in-sharep.aspx

The answer is that if you'd done you're linking correctly in the first
place, this couldn't happen. Since it has, you need to rethink your
linking.
 
K

Krishna

Mike,

In such a scenario, at least MS Project should show some warnings!
Saying that "You are marking successor task complete before predecessor!"

isn't?

regards,
Krishna
 

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

Top