Solved

not to display zeros in decimal place

Posted on 2007-04-09
3
498 Views
Last Modified: 2011-09-20
dear crystal report experts,

I have this custom formula in my cr (v 10X embedded with vs2005). I need to find a way to drop the zeros after the decimal point. 7,500.00 --> 7,500.

The data is from sql server, and is numeric (13,4). I have it cast to numberic(13,0) in the stored procedure, but the cr still showing all the 00s.

stringVar LnDesc := '';
LnDesc := LnDesc + totext({OptSvs.Qty}) + ' @ $' + totext({OptSvs.UPrice}) + '/ each = $' + totext({OptSvs.Net});
LnDesc;

0
Comment
Question by:ommer
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 18879759
Try this

LnDesc := LnDesc + totext({OptSvs.Qty}) + ' @ $' + totext({OptSvs.UPrice}, 0) + '/ each = $' + totext({OptSvs.Net}, 0);

mlmcc
0
 

Author Comment

by:ommer
ID: 18882032
Works great, thank you!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18882442
Glad i could help

mlmcc
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now