You can use the CData ADO.NET Provider for Microsoft Excel to integrate real-time connectivity to Microsoft Excel into your SSRS reports. The provider supports SSRS versions 2012 and above.

Create and Publish Reports in the Report Designer

Complete the following steps to publish reports to servers running in native mode or in SharePoint mode, using the Report Designer tool in Visual Studio:

Deploy the Provider

Before a data source can be created, the provider must be deployed to SSRS. See Deploy the Provider for a guide.

Create a Data Source

Define shared or embedded data sources as outlined in Create a Data Source.

Create a Dataset

The Query Designer is used to define a query which will provide the dataset for the report. See Create a Dataset for details.

Design and Publish a Report

Publish a Report describes how to design a report using Tablix and publish it from Visual Studio.