So today, I started to use an amazing and buried bit of technology.

I needed a way from a LOB applications to be able to programmatically print reports from SQL Reporting Services.   Now I know this is a little off topic for me.

But strike me down,   predictably, SQL reporting services can be fully driven via web-services.

Its worth looking at the Reporting Services docs on MSDN.

Bottom line, I was able to print Reporting services report to excel format; then  programmatically open up Excel.    I could then tell Excel to scale to fit the document to a page then print.   All this was triggered by an event in a LOB application.

(wicked)