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
 General SQL Server Forums
 New to SQL Server Programming
 ssrs

Author  Topic 

shilpash
Posting Yak Master

103 Posts

Posted - 2012-05-17 : 12:03:20
in ssrs i have a paraeter where it takes comma separated multiple values,if i select lets say i have 100 dates in that drop down box,,if i select 40 and run it,,,report runs fine but if i select all,it gives me error--conversion failed when converting date and or time from character string

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-19 : 14:00:30
can you show how you've added a filter in query based on parameter?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2012-06-15 : 05:34:32
Hi,

You should go incremental records to see which record has problem and then resolve that on. Else you can see into profile query thats easy way to get solution.
Go to Top of Page
   

- Advertisement -