| Author |
Topic |
|
volyn
Starting Member
30 Posts |
 Posted - 2010-04-18 : 16:28:34
|
Damn, I lost two days checking where is problem in my reports ,passing datetime parameters to another reports. I am almost crazy about that, but problem is definitely in format of datetime values.I put into parameter from calendar date 1st april and report generates values for 1st april, when I click to field, that navigates me to second report with such parameter, second report shows result for 4th januaryIf in first report is upt 2nd may then in second is 5th february. If I put in first report 14th january, then second report is giving me error * The value provided for the report parameter 'StartDate' is not valid for its type. (rsReportParameterTypeMismatch)Do you know what is going on ? Thanks a lot  |
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-04-18 : 17:12:46
|
| and one more thing, datetime parameter calendar behaves differently in report manager webpage and in my computer in visual studio preview tab.Its strange, in report manager when I press in calendar date 1st April, then date shows like 1.4.2010. If i do same thing in preview tab in VS then 1st April is swithed to format 4.1.2010. Looks like regional environment problems :{ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-19 : 04:55:23
|
| whats the report language property set for both the reports? also whats the language and regional options set for your machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-05-11 : 16:15:24
|
| Hello, thanks for help. I have changed Language property in both reports to en-GB. I have changed my computer regional settings to English United kingdom. Reports work perfectly when I run them separately. But still when I am passing date time parameter from one to another, its converting to US format.so passing parameter 14/5/2010 leads to report failure. Do you have idea? Do i have to use function to passing parameter? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-12 : 10:53:06
|
| are you using some explicit format functions in jump to report property?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-05-15 : 05:46:56
|
| nothing like that, I pass parameter as it is without any corrections with built-in functions |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-16 : 07:51:18
|
| is this happening in preview mode or when accessing from report web viewer?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-05-18 : 08:14:33
|
| When accessing report from web viewer.Again If run report1 with manually added parameters including datetime ,then fo 13.4.2010 I get data valid for 13th April 2010If I run manually report2, which contains details of data showed by Report1, then I again get correct data for 13th Apriu 2010.If I pass datetime parameter value between reports, then it get mistake.I changed both reports language property to en-GB, I have changed regional settings of server and computer to British english. I dont know.I dont want to solve it by brutal way of changing datetime parameter type to string type.Is there any wayx for example how to give second report switched value? If I enter 13.04.2010 in report1, then some function will convert date to format 04.13.2010 and pass it to report2, which takes it like US format and then its correct? I know, that it is ugly solution, but I need to run reports for other employees ASAP.Thanks a lot |
|
|
|
|
Passing Datetime parameter problems