A co-worker has created some reports (he uses Crystal X but I have the same issue in X or XI) to extract data to csv files for people to use for Hyperion imports.
1st issue:
The report in preview mode has commas where it shouldn't have them.
GH1 Actual06
GH2 03
GH3 03
D 9,6204140100,12,09000,175.00
Detail line should be:
96204140100,1209000,175.00
The attachment (...ForumPreview) shows what the data looks like and how it SHOULD look in Wordpad above.
2. When I export to csv, it puts the headers from GH1, GH2 and GH3 as a prefix on every detail line. They should be individual lines at the top of the csv file.
I've applied every hot fix/patch I can find but cannot fix this. Any thoughts would be greatly appreciated!
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.
Reply With Quote
