I have a scheduler report that creates a named range ("batch") to run a number of other reports. It's all working beautifully except for one problem. I'm based in England and our dates are of the format dd/mm/yyyy. We have dates as parameters for some of the reports and autopilot is switching around the days and months to the American format (mm/dd/yyyy). We haven't noticed it before but our reports are usually run at month end and therefore can't be switched - however I've recently added some weekly ones and noticed this behaviour. To be clear:
The generated scheduled report has the /p parameter dates with the correct format.
The autopilot commands are being called correctly (I turned on logging so it listed all the commands run).
But the resulting executed report has the date the wrong way around on the options tab.
I've checked the regional settings on the machine I'm running on and they all seem ok. I can't find much that is relevant in either excel or navision. But I've never seen a date in an American format either in Navision or in any of our reports.
Anyone got any ideas?
Thanks,
Teresa
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Teresa,
This sounds like something you should probably create a ticket for with Jet Reports Support. Then someone can look at the problem with you and hopefully figure out what is going on.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I have already raised a ticket, but thought that it might be worth asking in case someone had had a similar problem before.
Regards,
Teresa -
Jet Reports Historic Posts We managed to resolve the issue by passing in the date in a less ambiguous form - 10 Jul 2013 for example. Autopilot still interprets it as a date, but correctly, and passes it on to the executing form is the same format as before. Problem solved!
Please sign in to leave a comment.