Please note that you have yet to say exactly what error you are receiving and at what point in time. Any ideas I've had so far have been based solely on general troubleshooting principles, and without detailed information, there's really no further I can go. You're going to need to disclose the exact error, along with the text of the stored procedures (both for the report AND for the subscription), and a screen shot(s?) of the subscription setup process you're going through.