Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Report date format.
Microsoft Dynamics AX (Archived)

Report date format.

(0) ShareShare
ReportReport
Posted on by sri17 340

Hi All ,

AX 2012 R3 

The client has business operations across in many countries like Sweden ,UK ,Finland ,Norway and Denmark . The database is the same for all legal entities as mentioned below and business users will connect through RDS servers to access the application. The windows regional settings setup as as YYYY-MM-DD. The issue is that if users connected from Sweden they can view the date format on AX form level as YYYY-MM-DD, but when they run any standard SSRS reports, the date format is DD-MM-YYYY, which leads confusion to them. The date format is also okay in local documents such as excel sheet ,word document.

Any light why report level users has date format issues for sweden ?

Thanks in advance.

*This post is locked for comments

  • sri17 Profile Picture
    sri17 340 on at
    RE: Report date format.

    Thanks for the reply Crispin ,

    You mean there is no out-of box functionality for SSRS reports to display the dateformat as per regional settings.

  • sri17 Profile Picture
    sri17 340 on at
    RE: Report date format.

    Hi All ,

    Any inputs on how international companies managing their region report date format which has more legal entities in many countries ,but having one database and one reporting server in AX 2012 R3 ?

  • sri17 Profile Picture
    sri17 340 on at
    RE: Report date format.

    Hi All ,

    Any inputs on how international companies managing their region report date format which has more legal entities in many countries ,but having one database and one reporting server in AX 2012 R3 ?

  • sri17 Profile Picture
    sri17 340 on at
    RE: Report date format.

    Thanks Crispin for the reply ,

    i mentioned above , database is same for all countries and SQL reporting server also same . 

    As [quote user="Crispin John Augustine"]you have to explicitly specify a date Format for each date field in the Report, based on a condition (in your case)[/quote]

    Do you mean that each report required modification in the date field as per regional date format settings? 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans