OfficeWriter for SQL Server Reporting Services

Next, you are reminded that you must have the necessary J# components already installed.

Next, you need to specify the directory to install OfficeWriter, and by default \Program Files directory is chosen. If you need to change the directory, then click on the Browse button to specify the required location.

Next, choose the features you want to install, including the designer for Excel and/or Word.

The OfficeWriter installation includes Reporting Services Integration that allows the generation of reports in the native Microsoft Office formats. Server-side integration with SQL Server Reporting Services requires ExcelWriter.NET and WordWriter.NET. As a prerequisite, you must install the complete SQL Server Reporting Services package, otherwise you will get the message ‘Reporting Services Integration will NOT be installed’ as per the screenshot below: