It is still a question and an issue for me to use filestream with SSRS report. SSRS report can pull/show a BLOB stored in SQL when the BLOB is an image file but not msword or pdf or excel files. Is is still true now since filestream has been introduced in SQL2008? I need to to use SSRS to pull (download) files from BLOB filestream. The only way I know is to do it in ASP.net or classic ASP. If this is still not available, is there any reason why that MS did not support this feature? Any link that leads me to the filestream and SSRS (NOT IMAGE BLOB) would be very helpful. Thank you.

Check this thread: http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/D759801E-8517-4538-B9E9-51B748312BF1

Hi ytphou, Thanks for your posting. Currently, Reporting Services (including SSRS 2012) doesn't provide built-in Word, Excel or PDF viewer control to directly render the documents files that are stored as FILESTREAM data in the database. For more information, you can refer to the following threads that have the similar topic: http://social.msdn.microsoft.com/Forums/sa/sqlreportingservices/thread/e7a08cfe-3cc7-418d-896d-3d6fd5bfdaaehttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/222e100b-955e-4eaf-954c-238ef2baed32/ Meanwhile, I recommend that you submit a wish at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to release a Service Pack to add this feature or add the feature in the next SQL Server version. Thanks for your understanding. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support