The report is also deployed to a dev server where it works fine - it is firing the stored procedure on the dev server as well.
Is there some setting on the test server that would keep it from running a stored procedure?