Mystery Commas Appearing in BOXI Report.

[rico7937]

I have a unidue situation occuring on my BOXI R1 SP3 system.
I published a crystal report (CR 11 SP2) in which a url had some commas in the field. I went into the file option, select fields and selected number, I removed the thousand seperator and saved the report. Report ran fine and the url in the report contained no commas. I exported the report to excel and all was fine.

I then scheduled the report in BOXI R1 SP3 and e-mailed in excel format for the output. Received the e-mail and the report contained commas back in the URL. Tried re-plublishing numerous times with no success. Any Ideas ?

 

[synapsevampire]

Try cheating by using:

totext({table.field},0,"")

This removes the commas and thousands seporator.

-k