Post reply

How to Retrieve the image data from database table and show in SSRS

  • July 28, 2012 at 12:57 am

    #278733

    Hi

    1)

    My Table is

    Create Table Image_table (id int,images image ,crdate datetime default getdate())

    Insert into Image_table (id )

    Select 1

    UPDATE dbo.Image_table SET images =(SELECT * FROM OPENROWSET(BULK C:\TestImage.JPG', SINGLE_BLOB) AS x)

    I have inserted a image in this table

    able to query and see that i have image in the table

    Select * from Image_table

    DECLARE @Command NVARCHAR(4000)

    SET @Command = 'bcp "SELECT images FROM Defects.dbo.Image_table" queryout "C:\FromDB.jpg" -T -n'

    EXEC xp_cmdshell @Command

    Able to write from database to my path but i am unable to preview the FromDB.jpg image

    2)Now i need to show the image from database in SSRS

    I dragged the image from tools

    in General tab i am having Name:,ToolTip:,Select Image source:

    in Select Image source---> 3 options are there External , Embedded,Database.

    I am choosing database ,i am getting two extra fields as use this fields: and use this MIME type:

    what i need to give here in order to retrieve the data from database and show in SSRS

    Thanks

  • July 30, 2012 at 3:46 am

    #1519053

    Hello Experts,

    Any one has the idea how to do?

    Thanks

  • July 30, 2012 at 8:29 am

    #1519168

    If you add a dataset to the report that contains a select statement from the dbo.Image_Table, you can reference the field here in the 'Use this field' option.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply