Creating an ssrs report where upon exporting to excel the matrix is converted to a pivot table?

Question

I was wondering when creating an ssrs report, is there a property or something for the matrix so that when the user exports the report a matrix in the report will be turned into a pivot table where the data is connected to the database or some data table on another page in the report? So once the report is in excel format the user can play around with the pivot table some more. Thanks!

Answer 1

Unfortunately, no, SSRS doesn’t have a property or feature that converts a Matrix (tablix) into a true Excel PivotTable connected to live data or another table once exported.