I have a requirement to generate a SSRS 2005 report directly in Excel 2007. It's the same report generated 20+ times, but one parameter is different for each instance of the report.
In other word, I want to use Excel's VB Macro capability to pass a parameter to SSRS, and then have the report show up in a worksheet, which I can then re-format for printing.
Can you call an SSRS report from Excel? Anyone else done this?