Session date in the SSRS report

(0) Share

Report

Posted on by D365 beginner

578

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.

All responses (5)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Session date in the SSRS report

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
Suggested answer

D365 beginner 578 on at

Like (0)

Report

RE: Session date in the SSRS report

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
Verified answer

Sergei Minozhenko 23,091 on at

Like (1)

Report

RE: Session date in the SSRS report

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.
D365 beginner 578 on at

Like (0)

Report

RE: Session date in the SSRS report

Hi Sergei,

Yes, Exactly.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: Session date in the SSRS report

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?