Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Decimal on report

(0) ShareShare
ReportReport
Posted on by

Dear all,

How can I simply remove the decimal part on All report in NAV 2013 R2. Example for this amount: 1 200 00,00 I just want to display 1 200 000 and I want to apply this on all report in system. In general ledger setup, the local currency that I use it's Other

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Decimal on report

    I'm afraid there's no way you can do that. Number of decimal places is defined per each decimal field in a table. If there's no special number formatting applied through code or in the RDLC data when the report is run, it will simply show the decimals as defined for that particular field.

  • mmv Profile Picture
    11,467 on at
    RE: Decimal on report

    Hi,

    I don't think there is a way to do this by parameterizing in the setup.

    Best Regards,

    MMV

  • Suggested answer
    Rajasekhar@MS Profile Picture
    5,569 on at
    RE: Decimal on report

    Don't think, there will be a property or setup to control / display the decimals on all reports, because on some reports we will use Decimal property of the labels, and we will also control by using the Number format of the Text box.

    Regards

    Rajasekhar.Y

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans