i have a bunch of reports on the sql reporting services server which i would like to emailed on a click of a button in ASP.net.

as soon as the user hits the button, the report is generated (updated) and an email is sent out.

all i have bee able to achive is emailing reports on a time schedule, and have it send in excel format or PDF

can someone help me with this.

what are any other optiosn. thanks