Link in Report that automatically exports raw data to excel?

• CPiacente

  SSC Eights!

  Points: 863

  More actions

  April 8, 2014 at 11:41 am

  #306215

  Hey everyone,

  Does anyone know if there is a way to create a link that automatically exports the raw data of your report based on your parameters to excel upon the users request? It wouldn't be based on the export disc icon on the toolbar next to the "100%" zoom icon but rather an actual link. So if I had text that said "Raw Data" a user could click it and then an excel file would open with the raw data from SQL that was written....

  Thanks!

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  April 8, 2014 at 12:29 pm

  #1704262

  You could make create a link to the SSRS webserive wherein you supply the parameters and ask for the report in Excel format.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP