Thank you for your reply! Yes, the Reports runs but hungs for a very long time but eventually gets the data but my question is why would the Stored Procedure run quicker than the when running the Rport on the Server.