locked
Download Blob object from SSRS RRS feed

  • Question

  • Hi,

    I have an excel file stored as a BLob in the SQL server database and I have a SSRS report accessing this BLob object. I need to do the following :

    1. The name of the excel file should be displayed on the SSRS report.

    2. On clicking the name, the BLob should get downloaded as an excel sheet to the local hard drive of the user.

    Can anybody please let me know how this can be achieved ?

    Thanks in advance..

    Rishabh

    Monday, April 1, 2013 12:11 PM

Answers

  • Hi Rishabh,

    Currently, it is not supported to display BLOB documents (Excel, Word, PDF) directly in a report in Reporting Services. Only the BLOB images can be displayed directly in a report using the Image control. So, you can work around the issue by storing the documents as BLOB images, and use Image control to display the images in the report. For your second requirement, it cannot be achieved within a report either. Maybe you can add drillthrough action to the report, and save the documents on the report server or a network shared folder, hence, it can jump to the corresponding document file when the user clicks on one particular textbox, and download the document manually. 

    I would suggest you submitting a feedback at https://connect.microsoft.com/sql.

    Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

    Regards,


    Mike Yin
    TechNet Community Support

    • Marked as answer by Mike Yin Sunday, April 14, 2013 3:09 PM
    Tuesday, April 2, 2013 4:50 PM