SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ssrs		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shilpash
Yak Posting Veteran

77 Posts
Posted - 05/17/2012 :  12:03:20  Show Profile  Reply with Quote
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

India
48076 Posts
Posted - 05/19/2012 :  14:00:30  Show Profile  Reply with Quote
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

India
347 Posts
Posted - 06/15/2012 :  05:34:32  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000