Crystal Formula

Posted on 2012-09-06
Last Modified: 2012-09-06

i have field which is coming as below:

Field name: Tag1                                    
 values: 1.000 - 2.000
              3.000 - 5.000    
             10.000 - 32.000

Now i need to show this field called tag1 as 1 - 2, 3 - 5, 10 - 32. ie, need to remove the decimals. But since this field is string type i can't do it. Any ideas.

Question by:shirighimire
    LVL 34

    Accepted Solution

    If it's _always_ going to be ".000", you could use

    Replace ({Tag1}, ".000", "")

     That will replace every ".000" in the field with nothing (ie. remove those characters).

     If you could have other values (eg. "1.500 - 2.148"), that would be a bit more complicated.


    Author Closing Comment

    Thanks a ton!!!
    LVL 34

    Expert Comment

    You're welcome.  Glad I could help.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now