?
Solved

Crystal Reports and formatting FORMULA fields

Posted on 2003-03-14
5
Medium Priority
?
408 Views
Last Modified: 2012-06-21
hi.

I have 2 fields that need to be combined into 1 field. I'm using the formula method and the fields do get concatenated correctly. The problem is the 2 fields data are numbers such as Field1: 2,123.00 and Field2: 12.00

What i would like is the new field to concatenate the fields but formatted correctly and be seen as 212312 and not 2,123.0012.00

How do I format the new FORMULA field on the report?

Thanks
0
Comment
Question by:Jetter88
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 8138365
Are you sure they are numeric fields and not strings?

What formula are you using.

mlmcc
0
 

Author Comment

by:Jetter88
ID: 8138395
Hi.

I have figured out the solution:

CStr({ServiceAreaDetailReport;1.area},0,"")&CStr({ServiceAreaDetailReport;1.seq},0,"")

Thanks for your help.
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 8138399
Use CStr (totext) function. You should use something like this:
 formula = CStr(aaa,0) + totext(bbb,0)
 - in Basic syntax
 or totext(aaa,0)+ totext(bbb,0)
 - in Crystal syntax.
 where aaa and bbb are your fields, and 0 is number of decimal places.

HTH,
ladylinet
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11849879
PAQed, with points refunded (75)

modulo
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question