Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 insert word Document to RS Report

Author  Topic 

krubug
Starting Member

7 Posts

Posted - 2011-06-21 : 23:35:24
Hello
i need to insert a word document into RS report.
To Do so i inserted the word document to SQL SERVER DB to
VarBinary Field as a blob.


INSERT INTO myTable(Document)
SELECT * FROM OPENROWSET(BULK N'\\tblbi02\d$\SSIS Projects\test\TEST_MTB_Import_Word_Into_DB\Word Doc\Polica.docx', SINGLE_BLOB) rs

then i tried to create a Report and put an image using the option from DB but the report didnt show the Blob Pic(the word Doc).

i did the same with a reat Picture and it works.

What i do worng or how can i insert a word Doc To Report

Thanks
   

- Advertisement -