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.

Producing Reports from P6

4 replies [Last post]
Robert Corran
User offline. Last seen 2 weeks 3 days ago. Offline
Joined: 6 Dec 2003
Posts: 22
Groups: None
  Good Morning All I am using P6 v16.2 I cannot get a report out of it formatted as I want it to be, it is a simple report showing planned units for labour and materials, when I export to excelas an xls file the data on each line is one long line of text, why? In all previous P6 applications I have used it has come in as a tabluar report withthe data in the correct columns etc The way I have got round it at the moment is to take off the file extension, then dump it into wordpad, then import the text back into excel, seems a pointless long winded way of doing things,is there something Iam missing here, a setting somewhere for example? Any Help would be appreciated

Replies

Santosh Bhat
User offline. Last seen 8 hours 56 min ago. Offline
Joined: 15 Apr 2005
Posts: 226

You can simply copy all the data from the activity (or resource assignments) view and paste into Excel. Or Alternatively, setup a layout with your required columns, grouping, filtering etc, then select TOOLS>REPORT WIZARD and select the "Use Current Screen" option.

Alexandre Faulx-B...
User offline. Last seen 3 days 2 hours ago. Offline
Joined: 20 Jan 2003
Posts: 1263

Robert,

How do you export the report as an Excel file with xls or xlsx extension? IN P6, the only file format to export a report to is csv.

I guess the problem comes from Excel: do not open the csv file directly as you would do with an xls file, but go to Data, Get External data, From text, and navigate to your csv file; then let the import wizard guide you.

Alexandre 

Joel Roberts
User offline. Last seen 4 days 4 hours ago. Offline
Joined: 17 Mar 2017
Posts: 23
Groups: None

Hello Robert,

You might also want to consider trying out the reports in the pro version of ScheduleReader. It is a handy companion tool to your P6 and could potentialy simplify your reports creation process.

Zoltan Palffy
User offline. Last seen 2 days 1 hour ago. Offline
Joined: 13 Jul 2009
Posts: 2480
Groups: None

just do it in the data area as columns then highlight everything and copy and pate to excel