You have a couple of options

1. import the data to a staging table without the text qualifier and remove the double quotes with a replace when inserting into the final...

This is VB.net but should be pretty easy for you to translate

rptTest is the report viewer

Dim parameters As ReportParameter() = New ReportParameter(2)...

check this out:

http://sqlblog.com/blogs/jorg_klein/archive/2007/12/06/ssrs-custom-expressions-for-subtotals-in-a-matrix.aspx

it sounds like you need a date dimension table.

http://www.zachhunter.com/2009/09/how-to-build-a-date-dimension-table-for-olap/

your current 'sproc' is:

select column1,column2,column3,column4

from TABLE

where columnID in (SELECT Val from dbo.fn_String_To_Table(@MultiVal,',',1))

you could make another stored procedure identical to 'sproc' but add insert into TABLE (column1,column2,column3,column4) to the query.

insert...

you could also pass the multivalue parameter to a stored procedure as a varchar(max) then use a table valued function to split the multivalue.

try using the character codes

http://www.asciitable.com

I have used a script object to clean up input files before the import.

read the source file, evaluate the line, then output to a new file.

or

ignore the "" qualifier on...