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, ...
Answered

Session date in the SSRS report

(0) ShareShare
ReportReport
Posted on by 634

Hi Experts,

I have a report (SSRS)  where I need to display AX session date. I was simply trying the function Table.MyField = SystemDateGet(); in the DP class but it always takes the local machine's date same like function today(). If I try to print systemDateGet()  in an AOT job, it shows AX session date perfectly. what could be the reason ?

Thanks in advance. 

I have the same question (0)
  • Sergei Minozhenko Profile Picture
    23,093 on at

    Hi AX Beginner,

    Did I understand correctly that you change session date and time before executing the report and but systemDateGet still shows your local machine date time?

  • D365  beginner Profile Picture
    634 on at

    Hi Sergei,

    Yes, Exactly.

  • Verified answer
    Sergei Minozhenko Profile Picture
    23,093 on at

    Hi AX Beginner,

    I think that report itself (data provider class call) is executed in new session (see reporting architecture article) and for this report session session date is not changed.

    docs.microsoft.com/.../reporting-architecture

    As workaround, you can create new field on contract class and fill it from controller class with session date and time and use it in provider class.

  • Suggested answer
    D365  beginner Profile Picture
    634 on at

    Hi Sergei,

    I think you are right, I solved it as you suggested. (Added as a parameter and passed it to DP class using controller class)

    Thanks

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good morning AX Beginner,

    If your question has been answered and your problem been resolved then please be so kind and verify the answer.

    Many thanks for the help and best regards,

    Ludwig

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 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans