It would be very nice to be able to create Report Service reports as part of a workflow.
Ex We would like to send a customer an e-mail with a attached RS report (in PDF-format) every time a case is resolved.
This could be implemented as a "Report Service Report" step. The report parameters must be mapped to entity fields. And a e-mail, fileshare, FTP-share, Sharepoint document folder destination must be selected with relevant field-mapping.
This would seriously make things happen out-here :-)