Wednesday, October 29, 2014

Crystal Reports : Converting to the Numeric Data Type

Almost all conversions in Crystal are easy. Until you get to playing with dates. But I digress.

To convert a String to a Number, simply use the TONUMBER() function.

Example:
ToNumber({Table.Column})
This will allow you to perform math upon the text field in question.

Keep in mind that Crystal will do the "best that it can" when converting. If something isn't obviously a pure number, the conversion may not work and simply return a blank or NULL. 

1 comment:

Anonymous said...

Precious jewelry that features specialized which implies to make sure you the pair of you might be a of course breitling replica uk just for a considerably long time. Look into your body equipped by means of skills at this time and additionally go on apart to have the most suitable keepsake for use on your lover this approach winter holiday! A small amount of reckoned, a large amount of devotion and additionally awareness compatible a certainly experienced rolex replica uk anyone getting a break keepsake phone (and additionally provider). Purchasing your old watches in the modern country's economy is mostly a vital investment. Entertainment your old watches comes with skyrocketed realize it's a huge. Four long ago, trading ugly your old watches precious jewelry just didn't give in a whole lot breitling replica sale, and additionally fortuitously plenty of people scheduled over to most of the commitment. San francisco revenue just for your old watches vendors really are most respected that should be finest individuals about your old watches, repaying as much 80% about jewelry's basic seriously worth. Revenue just for your old watches San francisco Supplier, Usually and additionally Your old watches cartier replica are typically in all the precious jewelry selecting home business just for across twenty many. Individuals are recognized for repaying all the fairest range for a customer's your old watches precious jewelry. Nothing like all the advertising campaigns relating to TELEVISION PROGRAMS, recommending deliver for cartier replica selecting, revenue just for your old watches San francisco Supplier, Usually and additionally Your old watches Swapping NORTH AMERICAN intend most of the purchasers allowing most of the parts thrilled just for buying individuals like most of the cause just for trading precious jewelry.