How to bypass registry setting 2

[HelpPlease]

Hi,

I have developed a report using Crystal Reports 8.0. The problem is that the format for the report fields are affected by the regional settings on all machines other than the development machine. The report itself is basically a text file. In design, the report consists of a single formula which is a concatenation of all reporting fields in there desired format.

Example
20010620135500150000 7689435Title

Problem: Regional settings adds thousand seperators and decimal places in the report. When viewed from anther machine the above example looks like the following.

2,001.0006.0020.0013.0055.0000.0015.0000.0000.00 7,689.00435.00


Now the report in design time is a single formula, so I can't click on the field and adjust the number formating options in the format editor. However, I can choose options from the File menu and edit the number formatting options there. Changing the options there does not affect the format of the report. I know that the registry is causing the format problems because I can change my registry options and the report changes. Is there a way to ignore registry settings?


Thank you for your help,
HelpPlease

 

[HelpPlease]

Sorry for any confusion, the original thread deals with Regional Settings not Registry settings.

HelpPlease

 

[rpolunsky]

The best thing for you to do is convert all numbers to text format and be explicit about the formatting in that formula.

Hence, instead of putting a numeric field (say, ProductionYear) on the report, use a formula:

ProductionYearOut
ToText({ProductionYear},"####&quot

This way you define the output format and the regional settings don't come into play.

Richard A. Polunsky
Houston, Texas

 

[HelpPlease]

Thanks rpolunsky, that worked perfectly!!!!!

 

[hiteshvyas]

I m using the RichText box in my database application for the user message entry and i m saving the richtext in database. Everything works fine in forms. While i m trying to print same rich text content to report using Crystal Reports 8 in rich content normally printing goes fine but if the text contains some text underlined in middle of the message then it continues to print text underlined to end of the message

I m in hurry to solve the problem, does anybody have any idea about how to solve this problem?

Thanks in advance