Session date in the SSRS report

(0) Share

Report

Posted on by D365 beginner

636

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)

All responses (5)

Answers (1)

Sort by

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
D365 beginner 636 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

Yes, Exactly.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,095 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

D365 beginner 636 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No