I'm using P6 V16.2 I cannot get a report to come ut of it formatted as I want it. It is a simple report showing planned units for laboour and materials, when I export it to excel as an xls file as opposed to a csv file format, the data on each line is just one long line of text why? In all previous P6 applications it ihas come in as a tabular report in the correct columns etc.
The way I have got round it at themonment is to take the file extension off it, then dumo it into wordpad, the import the text file back into excel, seems a ponitless long winded way of doiong things, is there a setting somewhere I am missing
Any help would be appreciated
Thank you
Rob
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Wed, 2016-01-13 13:38
why dont you get your all of your columns set up in your data window and then right click and select export to excel. You can then use the trim function in excel to remove the -014.
Can this also be done any alternative way? I know how to get the basics of what I need but would like to know more of the functionality, like could it be done in the Report Editor or is it only through using the steps you outlined above in relation to my original query?
Member for
21 years 11 monthsGood Morning allI'm using P6
Good Morning all
I'm using P6 V16.2 I cannot get a report to come ut of it formatted as I want it. It is a simple report showing planned units for laboour and materials, when I export it to excel as an xls file as opposed to a csv file format, the data on each line is just one long line of text why? In all previous P6 applications it ihas come in as a tabular report in the correct columns etc.
The way I have got round it at themonment is to take the file extension off it, then dumo it into wordpad, the import the text file back into excel, seems a ponitless long winded way of doiong things, is there a setting somewhere I am missing
Any help would be appreciated
Thank you
Rob
Member for
16 years 3 monthswhy dont you get your all of
why dont you get your all of your columns set up in your data window and then right click and select export to excel. You can then use the trim function in excel to remove the -014.
Member for
9 years 10 monthsThanks v.much
Thanks v.much
Member for
21 years 9 monthsHi Eamonn,As far as I'm
Hi Eamonn,
As far as I'm aware, it cannot be done in Report editor.
=jerome
Member for
9 years 10 monthsThanks very much Jerome, I
Thanks very much Jerome, I appreciate that!
Can this also be done any alternative way? I know how to get the basics of what I need but would like to know more of the functionality, like could it be done in the Report Editor or is it only through using the steps you outlined above in relation to my original query?
Thanks
Member for
21 years 9 monthsEamonn,Create a User Defined
Eamonn,
Create a User Defined Field called "Primavera ID" of Data Type "Text" and then apply Global Change. Under the Then section, add the formula
Primaver ID = LeftString(Activity ID, 9)
where 9 is the length of characters you want to keep from the example you gave and this assumes your activity IDs are all of same fixed length.
Apply Global Change before running your report (remember to modify your report template to include this new field).
=jerome
http://plannerstips.blogspot.co.uk/