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.
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Fri, 2019-11-29 10:48
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
Member for
8 years 7 months
Member for8 years7 months
Submitted by Joel Roberts on Thu, 2019-11-21 13:52
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.
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Thu, 2019-11-21 13:22
Member for
20 years 6 monthsYou can simply copy all the
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.
Member for
22 years 9 monthsRobert,How do you export the
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
Member for
8 years 7 monthsHello Robert,You might also
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.
Member for
16 years 3 monthsjust do it in the data area
just do it in the data area as columns then highlight everything and copy and pate to excel