• If you use parameterized dynamic sql in the stored procedure, it shouldn't differ from the query within the report.

    What I'd try is dump the SSRS parameters, do it with my own code, and pass an xml full of parameters (sql 2005).