RL05 report - issues
In the Open Standard
David BladesMember for 22 years 6 months
- Created
- 4
- 4
0
RL05 Resource Cost Loading Weekly. Organised by WBS report.
When I run the report and priny preview I have the figures I expect to see.
When I run the report to ASCII text file and output to .csv file I open in excel and the data is different.... costs are not correct and data is not showing insome places as £100 format instead it shows as ’100.
I am using windows 7 and office 2007.
Thanks in advance for any assistance
When I run the report and priny preview I have the figures I expect to see.
When I run the report to ASCII text file and output to .csv file I open in excel and the data is different.... costs are not correct and data is not showing insome places as £100 format instead it shows as ’100.
I am using windows 7 and office 2007.
Thanks in advance for any assistance
4 replies
Oldest first- 0Rodel Marasigan ·David,
Check your currency settings under Edit-> Users Preferences then click currency tab. Make sure that Show currency symbol is tick and Show decimal digits is tick.
When running the report using ASCII Text File make sure that Field Delimiter is comma (,) and Text Qualifier is double quote (“) and tick view file when done. Also make sure that the extension of file is CSV
- 0Rodel Marasigan ·F is for Fiscal Period. You can change that to normal calendar if you wish.
To change Goto Report. Select the report you wanted to modify. Click the wand or Wizard button and click Next until you reached Date Option. Click Timescale and under Date Format tick calendar instead of Fiscal then click Ok. Click Next until you reached to Finish. Click Save Report then click Finish then run the report again.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?