Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to show word document in ssrs report Expand / Collapse
Author
Message
Posted Tuesday, April 02, 2013 12:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 18, 2013 4:56 AM
Points: 17, Visits: 69
Hi,

I am importing word document into sql server by using following Tsql.

-- Declare a variable to store the image data
DECLARE @Doc AS VARBINARY(MAX)

-- Load the image data
SELECT @doc = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET( BULK 'C:\Documents\DocName.doc', SINGLE_BLOB ) AS x


INSERT INTO Documents (ID, Document)
VALUES (1, @doc )

I want to show stored word document from sql to ssrs report,Kindly guide me how can i acheive this.
I am using ssrs 2008 r2 version.


Thanks
Seshu.
Post #1437719
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse