web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Showing brackets "["in number digits in place of seperator

(0) ShareShare
ReportReport
Posted on by 3,110

ShowingBrackets.png

Hi Experts,

It is very strange for me to found an issue that is in a printing report, i found in 2 columns there is showing brackets "[" instead of "," Seperator. Check above in the image

Best Regards,

Shabir Ahmad

I have the same question (0)
  • nmaenpaa Profile Picture
    101,160 Moderator on at

    Hi Shabir,

    can you share us any additional details except this screenshot? That would help a lot when trying to understand the problem.

    Let's start with some basics:

    1) Which report is this?

    2) Did you develop it or is it a standard report?

    3) What is the number format in these fields?

    4) What is the data type of these fields?

    5) Do you have any other fields on this report, using the same data type?

    6) Do you have any other reports where this same data type is used? If yes, do the numbers display correctly there?

    7) Did it work correctly in the past or has it always worked wrong?

    8) Does it work wrong in all systems or only one system?

    9) Does it only work wrong when exporting to PDF?

    10) Does it work wrong for all users or just one user?

    11) What D365 F&O version are you using?

    12) What type of system is this? Onebox, UAT, Prod? Self-service or not self-service?

  • Blue Wang Profile Picture
    on at

    Hi Shabir,

    Are there other settings for your columns ? For example, expressions or placeholders.

    Or you can try to use Replace(Format()) function to replace "[" with ",".

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans