#1 2019-07-16 10:32:13

Patryx
Member
Registered: 2019-03-25
Posts: 172

Date Parameter with date and time mode - time is never set

Hi,
I noticed a quite serious problem with Date parameter with date and time mode for Dynamic Reports when I compared results of report execution with my query called on pgadmin. It's a bit connected with:
https://forum.reportserver.net/viewtopic.php?id=1453

I add such a parameter to my report, in Report Execution View I set a value of date and time. Unfortunately this parameter still has only date (no time - always 00:00:00 no matter what I set in parameters tab). It's easy to check it puting this parameter in:

SELECT $P{P_DATETIME_FROM}::timestamp as my_datetime 

I don't attach screens etc because there is nothing complicated and it's a general problem with such a parameter.

Could you tell me is a bug or I have to do it in different way to get date and time as a parameter in my query?

Offline

#2 2019-08-01 08:47:52

Patryx
Member
Registered: 2019-03-25
Posts: 172

Re: Date Parameter with date and time mode - time is never set

Unfortunately in version 3.0.8 it still doesn't work. I cannot use date and time mode because time it is always 00:00:00 as value of parameter, no matter what I set in parameter's tab.

Offline

#3 2019-08-01 09:16:43

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

we will look into this in RS-3569.

Regards,
Eduardo

Offline

#4 2019-08-09 13:30:35

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

we see the problem and will update here when we have more information.

Regards,
Eduardo

Offline

#5 2019-08-12 08:31:23

Patryx
Member
Registered: 2019-03-25
Posts: 172

Re: Date Parameter with date and time mode - time is never set

Hi Eduardo,
The same problem is with parameter in time mode!
It only works for initialized value. If I change time in parameter's tab, no time is visible as parameter.
This is a huge and crucial problem because we have no possibility to filter time at all. Meanwhile I thought I would resolve the problem with date and time mode adding another parameter with time but now I can't because you have a bug also there.
In this way I cannot achieve so basic requirements of our client...
Any other idea how I can filter data by time chosen by user?

P.S. Is it possible to get very soon a preview version of next version with corrected behaviour of datetime parameter?

Last edited by Patryx (2019-08-12 08:32:24)

Offline

#6 2019-08-12 15:25:20

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

as I mentioned, we are currently looking into this and making progress. We are now testing a bugfix approach.

Of course, we can also create a preview version of the next reportserver version.

Regards,
Eduardo

Offline

#7 2019-08-13 09:52:29

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

we corrected this issue and will create a preview version including this fix for you to test. Thanks for sending this bug report.

Regards,
Eduardo

Offline

#8 2019-08-13 11:57:23

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

I sent you the preview release link per Email, please confirm you received it.

Regards,
Eduardo

Offline

#9 2019-08-14 09:00:44

Patryx
Member
Registered: 2019-03-25
Posts: 172

Re: Date Parameter with date and time mode - time is never set

Yes, thank you!
I got it but I have not installed it yet.

Offline

#10 2019-08-21 07:41:51

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,327
Website

Re: Date Parameter with date and time mode - time is never set

Hi Patryx,

for completeness: can you please confirm here if the time / date parameters are now working fine ?

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB