January 31, 2007 at 8:51 am
This time I'm passing a date parameter to a subreport. This generates an error unless the date is before the 13th of the month. Which means of course that the day and month are getting inverted between the main report and the subreport. Anyone know a getaround?
BTW, the other US dates problems are:
- day and month inverted each time you run the report; now fixed in SQL Server 2005 SP1
- dates entered as explicit (i.e. Non-Queried Available Values) lists for parameters treated as US style dates; reported this but haven't had confirmation from Microsoft yet that this is fixed.
February 5, 2007 at 8:00 am
This was removed by the editor as SPAM
February 7, 2007 at 4:32 am
Try using CDATE function for formatting the Date Parameter using the expression while passing to the subreport.
Prasad Bhogadi
www.inforaise.com
February 8, 2007 at 1:52 am
Thanks, I'll try that. Meanwhile I've formatted it with convert to a yyyymmdd string.
February 8, 2007 at 8:29 pm
Pardon me for piggy-backing on this one, but I am experiencing the same issue. I get the user to enter a date according to the format dd/mm/yy and then convert it in the dataset query - works fine; but when I try to reference the parameter in the report heading and make it a better looking format such as dd MMM yyyy I get errors. CDate doesn't work, neither does FormatDateTime (around CDate). I have tried all manner of things but I am still stumped. I will be very interested in any resolution for this problem.
Thanks
February 9, 2007 at 1:51 am
If you're getting the original US dates problem, it is fixed by installing SS2005 SP1 which includes an update to the report designer.
February 11, 2007 at 3:36 pm
You are right Jon. I thought I had SP1 installed - but no. I had downloaded it some time back and then forgot the very important step of actually installing it !! After installing it I was able to achieve what I wanted.
All is now well. Thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply