Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Comma issue

Hi,

When I export my CR report into XL then save it as .CSV, the below formula produces a comma (,) when view from notepad:

if {@Extended_Cost} <> 0
then {@Extended_Cost} * .1 else 0


@Extended_Cost is.......
if {Sheet1_.Net value} <> 0
then {@subtotal} else 0

I cannot find anything in the format field to get rid off the comma.

Any idea on how to overcome this?
0
mcse2007
Asked:
mcse2007
  • 6
  • 6
  • 3
  • +1
2 Solutions
 
peter57rCommented:
Are you saying that the csv shows, literally, a value of   ","   including the quotes?
0
 
gavsmithCommented:
In the format field dialog box (number tab), click the 'customize...' button, then untick the 'Thousands Separaator' box.
0
 
mcse2007Author Commented:
@peter57r:, yes, but no quotes.

@gavsmith, that's already configured.. no thousands separator..

Please see attached file
test.bmp
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mlmccCommented:
What is wrong with that comma?  It is just the separator from the next value.

mlmcc
0
 
mcse2007Author Commented:
hey mlmcc, there is no next value as seen from CR report... the comma shouldn't be there.
0
 
mlmccCommented:
Is the CSV file created in Crystal or Excel?

mlmcc
0
 
mcse2007Author Commented:
The CSV file is created in Excel.

It works like this...from CR, i export it as Excel (format & data only) and application.

When I view it from Excel, I go then save as .CSV
0
 
mlmccCommented:
Excel seems to be exporting 1 extra column.  
Do you have a field in the report to the right of the last number that is maybe always blank?

mlmcc

0
 
mcse2007Author Commented:
I checked in CR and nothing seems to indicate that there is a blank column in my report.
0
 
mlmccCommented:
Try this.

Export the report
Delete the column after the one with the last number.
Export to CSV

mlmcc
0
 
gavsmithCommented:
When you export the report from Crystal you should get some format options. Try changing the 'Column width based on objects in the:' option from 'Whole Report' to 'Details'. Does that change it?

Also if you export the report from Crystal straight to CSV do you get the extra comma?
0
 
mcse2007Author Commented:
I've tried the below and still get the same result, with comma

Export the report
Delete the column after the one with the last number.
Export to CSV

When I export, it is in details configuration. when I export from CR straight into CSV, it get worst, it produces more commas
0
 
mlmccCommented:
Can you upload the report?

mlmcc
0
 
mlmccCommented:
The fact that the CR export is worse, would seem to indicate there are fields or something to the right of the last field that is causing Crystal to add blanks tot he columns.  It only takes 1 value in the column to cause all rows to add the comma

mlmcc
0
 
mcse2007Author Commented:
the issue was when the report is exported, the HEADER has 1 extra column compare with the DETAIL when viewed in Excel. Once the report is saved as CSV, the comma appears....there is nothing i can do about it but leave with it.


thanks for the effort guys
0
 
gavsmithCommented:
I did mean to come back to this but I forgot, sorry, you mentioned the export to CSV provides more commas. Have you tried creating FakeGroups which helps sort out export to CSV problems in CR? there is also a reg key that you must set so that it exports correctly. Don't know if it will help you or not just a suggestion... it's explained here: http://forums.sdn.sap.com/thread.jspa?threadID=957336
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 6
  • 6
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now