Navigation Passing date parameter from report to linked report

[goofaholix]

I have a report that passes start date and end date parameters to another report through the navigation settings.

It works fine in BI Studio.

However when I deploy on Report Manager I get the following error;
The value provided for the report parameter 'StartDate' is not valid for its type. (rsReportParameterTypeMismatch)

I've done some testing and I've found I only get the error when I enter a date that is not valid in both dd/mm/yyyy and mm/dd/yyyy format, so 12/11/2007 is fine but 21/11/2007 produces an error.

I'm guessing there is a bug with the dd/mm/yyyy format that we are using, or perhaps somwhere in the report manager configuration files I need to set that we are using dd/mm/yyyy.

Does anyone know how I can resolve this?

Thanks

Bruce

 

[xlbo]

Problem is probably in the default date settings for either ReportServer or IIS - one of them is set to dd/mm, the other to mm/dd in all liklihood

Best bet is to send all dates through as yyyy-mm-dd format which should be ok regardless of settings

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question