Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

MATRIX TO CONTAIN 60 COLUMNS

13 replies [Last post]
Tue, 2005-03-15 01:26
Mohammed Muneeruddin
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 11 Jun 2003
Posts: 28
Groups: None
HI

I AM TRYING TO MAKE A MATRIX REPORT CONTAINING 60 COLUMNS AND 15 ROWS. IT SEEMS ONLY 25 COLUMNS ARE ALLOWED . IS THERE ANY WAY OUT . PLEASE LET ME KNOW.


THANKS

Top

Replies

Wed, 2005-05-18 01:51
#1
Mohammed Muneeruddin
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 11 Jun 2003
Posts: 28
Groups: None
HI PAUL

THANKS. THE PROCEDURE WHICH YOU HAVE DETAILED FOR HOW TO CONNECT THE ODBC TO EXCEL REALLY HELPED ME.
(REF : HTTP://WWW.EH.COM.AU


REGARDS
Top
Tue, 2005-05-17 14:08
#2
kamran hazini
User offline. Last seen 12 years 2 weeks ago. Offline
Joined: 10 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
Hi Bill,
Would you please also send me a copy of the files to kamranhazini@yahoo.com?
thanks in advance.
kamran
Top
Tue, 2005-05-17 08:57
#3
Alan Midgley
User offline. Last seen 2 years 17 weeks ago. Offline
Joined: 2 Jul 2002
Posts: 12
Groups: None
Bill,

Could also send a copy to myself at alangmidgley@yahoo.co.uk.

Thanks,

Alan

(Alan Midgley - planning manager for Bovis Lend Lease, UK)
Top
Mon, 2005-03-21 23:46
#4
Ravi Potwar
User offline. Last seen 4 years 5 hours ago. Offline
Joined: 7 Mar 2005
Posts: 30
Groups: None
Hi Bill,
I am not aware of ProjMods, Can you Please send me the File.Please direct me How to Installed & Use further.
Thanks
Ravi
Top
Mon, 2005-03-21 10:02
#5
Bill Guthrie
User offline. Last seen 8 years 20 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Fully aware of the export inport capabilites of P3, but what I am referring to is the 2 downloads
one is called ProjMods
the other is Project, I beleive. both are xls files that are on some p3 installation disc, and at one time was available as downloads direct from Primavera.

The two files allow one to go into P3 through the database and work, for example, projmods allows you to export the activity code structure and work on it, change it and import it back into p3. awsome way to update code works.

emal me and i will zip and send to you if you want.

regards bill
Top
Mon, 2005-03-21 04:13
#6
Andrew Podolny
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hi, Mohammed
The Crystal Report is more powerful utility (IMHO) than InfoMaker.
But you’ve to be familiar with database design in order to use it at full throttle.
You can read more about Crystal at: http://www.ripway.com/members/getfile.asp?file=\2005-3\268277\ProteanRep...

Cheers,
Andrew
Top
Mon, 2005-03-21 00:29
#7
Ravi Potwar
User offline. Last seen 4 years 5 hours ago. Offline
Joined: 7 Mar 2005
Posts: 30
Groups: None
Henk,
Are you explaining about Export/Emport.Yes I know it is there Tools-Utility-Export-Emport,I was Thinking some other utility Power programme..?

Thanks
Ravi
Top
Sun, 2005-03-20 18:22
#8
Henk van der Heide
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 7 Aug 2004
Posts: 101
Groups: Petro-Chem / Oil & Gas
Ravi,

You can do this within the program P3win.
tools/project utilities export/import


regards

Henk
Top
Sat, 2005-03-19 07:07
#9
Mohammed Muneeruddin
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 11 Jun 2003
Posts: 28
Groups: None
HI ANDREW

THANKS, INFOMAKER SEEMS TO BE DIFFICULT. WHAT ARE CRYSTAL REPORTS.


Top
Sun, 2005-03-20 00:17
#10
Ravi Potwar
User offline. Last seen 4 years 5 hours ago. Offline
Joined: 7 Mar 2005
Posts: 30
Groups: None
Bill, Can you please explain more about power programme.I am not aware of it. Wher is available ,And how to Get it & its Utility
Thanks
Top
Sat, 2005-03-19 12:39
#11
Bill Guthrie
User offline. Last seen 8 years 20 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Agres with JAco.

Most planners are not aware of the power programs that come in most P3 disc, basically downloads, that are p3 inport and export programs. With this, you can do almost anything in Excel then import back into p3.

Sometimes find it easy to work in xls then p3 and inport export. This is very good for 10 to 15000 activiy schedules that we come upon for large projects.

b
Top
Tue, 2005-03-15 06:14
#12
Andrew Podolny
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
I prefer to use Crystal reports v10 against P3 database.
With Crystal you’re able to produce well looking reports.
Or you may use InfoMaker (shipped with P3) instead.
Cheers,
Andrew
Top
Tue, 2005-03-15 05:50
#13
Jaco Stadler
User offline. Last seen 17 years 49 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Why not do the report in xls. And use p3 Export Function.

Cheers

Top