Can I use the MS Office Web Component - Pivot Table to deliver SQL Server data.

  • Article

Yes, in reporting services, “HTML with Office Web Components” on of the options for exporting reports will utilize and create pivot tables automatically.

To find more information:
https://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp?frame=true