ReportServer Forum

khtw

Member

Registered: 2016-10-04

Report URL

Hi.

Can't seem to find an solution to passing a date parameter via a URL for report inline view.

URL I use: https://reportserverIP:8080/rs/ReportServer.html#inlinereport/key:SAL_RECEIVED&p_pFrom:2016-09-01&p_pTo=2016-09-20&p_pDealercode:2033500&v:preview

Keeps giving the error of:

Failed to parse date 2016-09-01

I have tried all the other format as well (09-Sept-2016, Sept 9, 2016, etc) but with no success.

I have even set the short and long date formats in the "File Systems" local file to yyyy-MM-dd, but nothing.

Per previous post I have notices running a Java command to show the system excepted date format (which was 09 Sept 2016), but this did not work either.

Any help or direction to fix this will be appreciated.

KH

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Report URL

Hi,

you can specify the pattern to use in the config file datasources/parameter.cf.

<configuration>
   <parameter>
      <!-- ... -->
      <date>
      	<urlpattern>yyyy-MM-dd</urlpattern>
      </date>
   </parameter>
</configuration>

(Remember to run config reload after changing the config file.)

If no pattern is specified, then ReportServer uses the ISO-8601 pattern, i.e.,  yyyy-MM-ddThh:mm:ss[.sss][Z|[+-]hh:mm]

Come to think of it, if the parameter does not support time it would be more sensible, to fall back to parsing yyyy-MM-dd. Anyhow, I hope this helps.

Thomas

khtw

Member

Registered: 2016-10-04

Re: Report URL

Thank you very much, Thomas!  You are the man!  That config change did the trick!

Appreciated!

KH

stellanl

Member

Registered: 2017-12-04

Re: Report URL

Note that in the fallback pattern the timezone indicator is not optional, so the simplest acceptable date is "2017-01-01T00:00:00Z" unless you modify datasources/parameter.cf.

/Stellan