I'm using ReportParameter to pass a list of Departments to a Report, but it seems like ReportParameter is breaking my comma separated string into a list of individual strings. I need to pass the actual, unmodified string as a single item. What can I do to get ReportParameter to just leave my data alone and pass it to the report?
I'm passing data to a report, and my ReportParameter call looks like this:
ReportParameter DepartmentName = new ReportParameter("Dept", "Bakery,Deli,Cheese", false);
But when I trace the call to the database, it's breaking that up into three string objects ("Bakery", "Deli", "Cheese") instead of keeping them together ("Bakery, Deli, Cheese") and the report fails. The report works if a single item is sent instead, so it is this behavior that is causing the report to fail.