Just to eliminate the obvious, under the "Format" tab of the cost loading report, be sure that the "summary report" checkbox is off. If this does not sor out your problem, please describe the colums & layout of the csv file that is being generated.
Good Luck,
Michael.
Member for
21 years 11 months
Member for22 years
Submitted by Michael Byrne on Mon, 2003-12-22 03:45
Thanks for ur reply. i followed the steps and got the report in excel but still i’m missing a column which shows cost of each activity. let me explain my question to further level.
Preparing Cost Loading Report in CSV Format.......
Under the Format i have chosen the following:
1)export report in csv file
2)Organize by Area
3)group By None
4) summary check marked and rest of the format options r as it is
UNDER the Time scle i have chosen the following:
1) the time range validate the project period.
2) display unit is set to weekly
UNDER Resource selection and the seclection box i have chosen nothing and i think i ’m making some mistake in these areas, thats why i’m not getting a column which shows the cost value of each activity. please reply me if u c my question. thanks!
If I am reading your question correctly, simply go: Tools - Tabuluar Reports - Cost - Loading. Then "add" your own report. Under the "format" tab, click " Export report in CSV format, and beneath this organise your activities as you want. Be sure that the timescales are set to suit the project. When the CSV file is generated, simply save it down as an excel file. I hope Ive interpreted your question correctly. Let me know if this works for you.
Member for
21 years 11 monthsRE: how to get a column showing cost in cost loadi
Sajid,
Just to eliminate the obvious, under the "Format" tab of the cost loading report, be sure that the "summary report" checkbox is off. If this does not sor out your problem, please describe the colums & layout of the csv file that is being generated.
Good Luck,
Michael.
Member for
21 years 11 monthsRE: how to get a column showing cost in cost loadi
Sajid,
Sorry for the late reply, christmas parties have kept me out of the office for the last few days.
What you are doing seems fine to me. I think the problem must lie in how your costs are set up.
Is each activity cost loaded individually?
Are you assigning costs to activities based upon resource costs are by using cost accounts?
I use cost accounts and the method you described, works for me.
Member for
16 years 9 monthsRE: how to get a column showing cost in cost loadi
michale,
Thanks for ur reply. i followed the steps and got the report in excel but still i’m missing a column which shows cost of each activity. let me explain my question to further level.
Preparing Cost Loading Report in CSV Format.......
Under the Format i have chosen the following:
1)export report in csv file
2)Organize by Area
3)group By None
4) summary check marked and rest of the format options r as it is
UNDER the Time scle i have chosen the following:
1) the time range validate the project period.
2) display unit is set to weekly
UNDER Resource selection and the seclection box i have chosen nothing and i think i ’m making some mistake in these areas, thats why i’m not getting a column which shows the cost value of each activity. please reply me if u c my question. thanks!
Member for
21 years 11 monthsRE: how to get a column showing cost in cost loadi
thnaks
Member for
21 years 11 monthsRE: how to get a column showing cost in cost loadi
Sajid,
If I am reading your question correctly, simply go: Tools - Tabuluar Reports - Cost - Loading. Then "add" your own report. Under the "format" tab, click " Export report in CSV format, and beneath this organise your activities as you want. Be sure that the timescales are set to suit the project. When the CSV file is generated, simply save it down as an excel file. I hope Ive interpreted your question correctly. Let me know if this works for you.
Michael