Our requirement is to export SSRS report to excel and create pivot tables. But we found thats not possible as exported result is just snapshot and it doesnt store result set in proper excel format. Do we have any control over export functionality of SSRS to excel?