• I'm not sure what's going on then. I'd expect SSRS to pass the parameter to the proc as one string, as you are seeing in profiler.

    What's going wrong inside the proc I can't tell you!

    Does it work if you run the report as T-SQL rather than call the proc?