Print Page | Close Window

Number to string

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3537
Printed Date: 18 May 2024 at 4:47am


Topic: Number to string
Posted By: leezo
Subject: Number to string
Date Posted: 26 Jun 2008 at 8:48am
hi,

I have a field containing telephone numbers in the international dialing format e.g. "0017188644434". My crystal report is pulling its data from a csv file. The problem is that no matter what I do, CR insists on seeing this field as number, striping the zeroz and adding thousand comas. I tried creating a new formula field in the formula editor using ToText and CSTR functions but no luck. Any advices?

Thanks


Print Page | Close Window