Crystal Reports

Posted on 2011-10-12
Last Modified: 2012-05-12

 How to change decimal places dynamically in Crystal reports depends up on currency code
Question by:CMANI10
    LVL 77

    Accepted Solution

    Do you mean you want to display different numbers of decimal places depending on the value of another field holding the currency code?

    If so then you can use the conditional format button on the Number custom tab in Format Field.  (Right click the field , choose format field, then choose the Number tab and then click Customize)

    You use an expression like..

    If {Table.Currencycode} = "xxx" then 4
    else if {Table.Currencycode} = "yyy" then 0
    else 2
    LVL 100

    Expert Comment

    You may also want to round to that number of decimal places.  You can change the rounding with a similar formula


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Read about how to approach blogging and about ways to do it right. Stand out from the crowd and let your knowledge be consumed by a large audience. This article aims to explain how your blog should look like,  the most important things to do while b…
    In order to have all security and back ups taken care of, WordPress users can sign up for services with WP Engine.
    The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: :…
    The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now