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.
| Author |
Topic |
|
sachya45
Starting Member
25 Posts |
 Posted - 2009-06-22 : 16:29:04
|
| Hi,I have one multivalued parameter to filter report , when i select one or more that one value , i get the my report.but when i do select all(list has around 800 values) i get the following error...any ideas please help..Error is as follow:An error occurred during local report processing.An error has occurred during report processing.Query execution failed for Data Set "my data set"String or Binary data would be truncated.The statement has been terminated. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-23 : 11:59:11
|
| well your list is longer than what the parameter can hold..try increasing the size of the parameter..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
sachya45
Starting Member
25 Posts |
Posted - 2009-06-23 : 13:49:39
|
| I have declared parameter varchar(max) still getting the same error |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 14:02:00
|
Let's see the code.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
String or Binary data would be truncated error