Ok, I'm confused ...
I have a parameter in my report which passes a multi value VARCHAR value to a procedure. The parameter argument is a VARCHAR(4000). It works just fine, and has been working fine. I found a case (based on date range) to as where I'm getting the error "Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query." After tracing the activity, I found that SSRS is sending all my values to the proc with in unicode ('N). As soon as I remove it, works like a champ.
The thing is though, the source data, is VARCHAR, so why is it barking at me saying I'm trying to convert ntext to varchar? If anything, shouldn't it be trying to convert it to nvarchar from varchar?
So my question is, can I remove this from SSRS? If not, any suggestions? I've never seen such a thing ... I simply changed the parameter on the procedure from varchar to nvarchar ... but again, I'd like to know more about this and if I have any better options.
Making SQL do what we want it to do.