Crystal Reports Database Field Conversion
Posted on 2011-02-11
I'm not sure if this is possible, but I have a numeric field in a database (int) and Crystal Reports is defaulting those fields to display the comma and .00 at the end of it. I can format the field to not show that, however I'm trying to use the "formatted" version in a hyperlink and the server that runs the reports doesn't keep the conversion. Is there a way that a formula field or something can be created to store the value without the comma and .00 at the end so I can pass that to the hyperlink?