Posts From The Archive

Get Rendered LocalReport Values with OpenXml

How oh how is one to get XML from a local (not server) SSRS report? As it turns out, via Excel. The LocalReport.Render() method only supports Excel, PDF, and Image formats, but since the Excel 2007+ file format is just compressed XML, it didn’t take too much finagling to get what I was really after. The only thing I needed was the Microsoft OpenXml SDK, easily acquired through nuget. This code snippet shows how to get the rendered values from a LocalReport in memory: [Read More]