Improve company productivity with a Business Account.Sign Up

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

Crystal Reports Database Field Conversion

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?
0
rondre
Asked:
rondre
1 Solution
 
JayConverseCommented:
ToText({myfield},0)
0
 
rondreAuthor Commented:
Perfect, thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now