Print Page | Close Window

Number Format within Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9104
Printed Date: 25 Apr 2024 at 3:13am


Topic: Number Format within Formula
Posted By: roxaneamanda
Subject: Number Format within Formula
Date Posted: 12 Feb 2010 at 6:16am
I have the following formula;
 
{tablename.numericfield} & " " & {table name.stringfield}
 
The numeric field is displayed as 1234.00 for example, I want to format the numeric field to 1234 (no decimals) within this formula, can anyone tell me how to do that?
 
Thanks


Replies:
Posted By: DBlank
Date Posted: 12 Feb 2010 at 8:04am
totext({tablename.numericfield},0,"") + " " + {table name.stringfield}


Print Page | Close Window