How can I utilize SQL Server Reporting Services to render a report (with parameters) and embed it in an email message for editing without using the subscription?
I would like to be able to go to a report, enter my parameters, run the report, and then either click a hyperlink inside the report, or otherwise output the report to an email message where I can add attachments, additional comments, etc before sending.
I am able to get halfway there with the “Action” feature inside of Reporting Services, however, I cannot get the report to embed itself in the body of the email. The closest I can get is some text and a hyperlink.
Any help is appreciated.