ReportServer Forum

theplayer2k3

Member

Registered: Yesterday

DateTime as Parameter for inlinereport

Hi @all,

i'm using ReportServer 4.7 LTS to generate Jasper Reports with PDF output.
All works great but i don't get it to add the time to the url as a parameter

the param looks like this

http://.......&p_updateAt:2026-04-06

Only date is working correct an will be shown in the parameters view.
But i can't add a time. I tried different Version like

http://.......&p_updateAt:2026-04-06T22:00:00
http://.......&p_updateAt:2026-04-06T22:00
http://.......&p_updateAt:2026-04-06T22:00:00Z
http://.......&p_updateAt:2026-04-06T22:00:00+02:00

Single quotes, double quotes, url encoding of the colon, .....

I think this is a really simple problem but i don't get it.
Help Me Obi-Wan Kenobi, You’re My Only Hope.

eehm

Help Me Forum. You’re My Only Hope. :-)

greetings theplayer2k3

IF_Jasmin

Moderator

Registered: 2024-11-14

Re: DateTime as Parameter for inlinereport

Hello theplayer2k3,

Unfortunately there are known limitations in the usage of timestamps. Without looking into the code it is likely that the time part is truncated.

A possible workaround: You can change the type of the parameter to a String/Text and parse it in your SQL or jasper to the correct datatype.

If you're owner of an enterprise ReportServer license there are also some ways to customize your report and the access to your report by using groovy-scripts: you could transform your text parameter to a date parameter at the compilation of your report.

Reworking the handling of dates and timestamp is on our roadmap.

Best regards
Jasmin