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:
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp?frame=true