DateTime Dialog Filtre SSRS Report filter

(0) Share

Report

Posted on by AlaaBa

Hi,

I have a problem with the DateTime Type parameter in the contract class, when I select a value in the DateTime filter, in the DP class it retrieves the selected date minus one day

Thanks much.

3678.A.png 0317.B.png 6403.C.png

I have the same question (0)

All responses (14)

Answers (1)

nmaenpaa 101,166 Moderator on at

Like (0)

Report

It's a time zone difference. Your input field handles timezone differently than your infolog printing.

18.09.2020 00:00 in france is 17.09.2020 22:00 UTC.

So the input handling seems to work as expected.

Same applies to your data, if some datetime in your data shows up as 18.09.2020 00:00 in your time zone, it means that the actual timestamp is 17.09.2020 22:00 UTC.

Does your report not work as expected?

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

The date is being displayed in UTC-8 format. I think that's the setting on the Dev system. For the report filtering it should work fine though.

Please check this link

Was this reply helpful? Yes No
AlaaBa 65 on at

Like (0)

Report

Thank you for your answer,

it works fine for date filters, but dateTime No.

I checked the system, it is well configured,

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

Currently we only see how the filter field is implemented (looks correct) and an infolog output (most likely correct but impossible to say without seeing the code that produces it). We don't know how you filter records based on the filter fields.

Please share more details about your situation. Such as all code that is using these date fields to filter records.

Also please share the code of your infolog (in your screenshot).

Was this reply helpful? Yes No
AlaaBa 65 on at

Like (0)

Report

I displayed the value retrieved by contract class.

Here is the code that executes the message.

Was this reply helpful? Yes No
AlaaBa 65 on at

Like (0)

Report

[

SysEntryPointAttribute

]

public void processReport()

{

RetailStatementJour retailStatementJour;

contract = this.parmDataContract() as PMsalesVoucherContract;

throw error(strFmt("%1", contract.parmDateTimeFrom() ));

}

[

DataMemberAttribute('datetimeFrom'),

SysOperationLabelAttribute(literalstr("@SYS35905")),

SysOperationDisplayOrderAttribute("3")

]

public fromDateTime parmDateTimeFrom(fromDateTime _datetimeFrom = datetimeFrom)

{

datetimeFrom = _datetimeFrom;

return datetimeFrom;

}

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

Where are you using the date time value? Retail statement Jour has two fields date and time.

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

When you share code, could you please click "Use rich text formatting" -> "Insert" -> "Code". This way it's easier to read. Thanks!

Anyway, your current code is throwing an error so the report processing is halted. Perhaps that explains why it doesn't work for you.

I don't see any code that would filter any records - did you forget to share that part?

Was this reply helpful? Yes No
AlaaBa 65 on at

Like (0)

Report

Hi,

it is a filter at the level of the RetailStatementJour table on the TransFormDate and TransFormTime fields

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

Good to know. Could you now share your code? Assuming you still need help with your functionality.

Thanks!

Was this reply helpful? Yes No

Join the conversation

Community site session details

DateTime Dialog Filtre SSRS Report filter

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

DateTime Dialog Filtre SSRS Report filter

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates