Primavera Project Planner - P3 Member for 20 years 7 months Member for 20 years 7 months Submitted by Zhang Haixiang on Wed, 2005-10-05 23:40 Permalink RE: export from P3 into xls including grouping str What you need to do is just sort your activities then add a group title. if you have too many to add, try excels outline worksheet function.( Im using excel 2002,it has the ability to group rows/columns) Member for 23 years 8 months Member for 23 years 8 months Submitted by MK TSE on Fri, 2005-09-30 12:57 Permalink RE: export from P3 into xls including grouping str Is web publish is an alternative? Member for 21 years 4 months Member for 21 years 5 months Submitted by Razi Khan on Sun, 2005-05-29 08:24 Permalink RE: export from P3 into xls including grouping str Then why dont you give report in pdf format instead of Excel. Member for 20 years 5 months Member for 20 years 5 months Submitted by Eckart Schenck on Sun, 2005-05-29 05:12 Permalink RE: export from P3 into xls including grouping str Im familiar with sorting by act codes in xls. The problem comes when you communicate with somebody who doesnt know well the act code structure and doesnt have P3 either. In such case it would be good to have an excel export with the grouping... Heinz Member for 21 years 4 months Member for 21 years 5 months Submitted by Razi Khan on Sun, 2005-05-29 04:49 Permalink RE: export from P3 into xls including grouping str Hi, Export with "Activity Code" Columns also and then sort and group in Excel as per requirement. Cheers. Member for 21 years 2 months Member for 21 years 2 months Submitted by Jaco Stadler on Sun, 2005-05-29 04:47 Permalink RE: export from P3 into xls including grouping str Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure Log in or register to post comments
Member for 20 years 7 months Member for 20 years 7 months Submitted by Zhang Haixiang on Wed, 2005-10-05 23:40 Permalink RE: export from P3 into xls including grouping str What you need to do is just sort your activities then add a group title. if you have too many to add, try excels outline worksheet function.( Im using excel 2002,it has the ability to group rows/columns)
Member for 23 years 8 months Member for 23 years 8 months Submitted by MK TSE on Fri, 2005-09-30 12:57 Permalink RE: export from P3 into xls including grouping str Is web publish is an alternative?
Member for 21 years 4 months Member for 21 years 5 months Submitted by Razi Khan on Sun, 2005-05-29 08:24 Permalink RE: export from P3 into xls including grouping str Then why dont you give report in pdf format instead of Excel.
Member for 20 years 5 months Member for 20 years 5 months Submitted by Eckart Schenck on Sun, 2005-05-29 05:12 Permalink RE: export from P3 into xls including grouping str Im familiar with sorting by act codes in xls. The problem comes when you communicate with somebody who doesnt know well the act code structure and doesnt have P3 either. In such case it would be good to have an excel export with the grouping... Heinz
Member for 21 years 4 months Member for 21 years 5 months Submitted by Razi Khan on Sun, 2005-05-29 04:49 Permalink RE: export from P3 into xls including grouping str Hi, Export with "Activity Code" Columns also and then sort and group in Excel as per requirement. Cheers.
Member for 21 years 2 months Member for 21 years 2 months Submitted by Jaco Stadler on Sun, 2005-05-29 04:47 Permalink RE: export from P3 into xls including grouping str Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure
Member for
20 years 7 monthsRE: export from P3 into xls including grouping str
What you need to do is just sort your activities then add a group title.
if you have too many to add, try excels outline worksheet function.( Im using excel 2002,it has the ability to group rows/columns)
Member for
23 years 8 monthsRE: export from P3 into xls including grouping str
Is web publish is an alternative?
Member for
21 years 4 monthsRE: export from P3 into xls including grouping str
Then why dont you give report in pdf format instead of Excel.
Member for
20 years 5 monthsRE: export from P3 into xls including grouping str
Im familiar with sorting by act codes in xls.
The problem comes when you communicate with somebody who doesnt know well the act code structure and doesnt have P3 either. In such case it would be good to have an excel export with the grouping...
Heinz
Member for
21 years 4 monthsRE: export from P3 into xls including grouping str
Hi,
Export with "Activity Code" Columns also and then sort and group in Excel as per requirement.
Cheers.
Member for
21 years 2 monthsRE: export from P3 into xls including grouping str
Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure