Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Date Selection Error

Author  Topic 

jess1984
Starting Member

14 Posts

Posted - 2010-09-29 : 08:03:40
hai,
when an change the date(datatype is datetime) in SSRS report ,show an error

The value provided for the report parameter is not valid for its type. (rsReportParameterTypeMismatch)

PLZ help me ........very urgent

Thanks & Regards
Jess

jess1984

Sachin.Nand

2937 Posts

Posted - 2010-09-29 : 08:08:09
What is the datatype of the report parameter?

PBUH

Go to Top of Page

jess1984
Starting Member

14 Posts

Posted - 2010-09-29 : 08:12:29
Parameter type of Date is datetime

jess1984
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-09-29 : 09:10:04
What is the datatype of the column to which you are applying the parameter?

PBUH

Go to Top of Page

jess1984
Starting Member

14 Posts

Posted - 2010-09-29 : 09:12:24
That is also datetime

jess1984
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-09-29 : 09:13:53
when an change the date(datatype is datetime) in SSRS report ,show an error

and before changing it to datetime what was the datatype of the parameter?

PBUH

Go to Top of Page

jess1984
Starting Member

14 Posts

Posted - 2010-09-29 : 09:14:55
That is also same (datetime)

jess1984
Go to Top of Page
   

- Advertisement -