We found our issue. I was using the parameters directly in the body of the SP definition. Apparently there is a known issue with how paramaters are accessed and processed. I modified the stored procedure by declaring new variables in the body of the SP and setting them to them value of the passed parameter. Reduced execution time from within SQL Manager and provided the same response time from within the report.
🙂