SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
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
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63632 Visits: 13298
Display Database Image using MS SQL Server 2008 Reporting Services


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
Hi,

Thanks for that link.

i am getting error as

[rsMissingDataSetName] The tablix 'Tablix1' is invalid. The value for the DataSetName property is missing.

what is the problem

if run this images alone i am able to get the result I'm able to see the image,but where as if have more tables then i am getting this error i.e i am fetching few records from another tables and showing it and after 5 tables below that i am inserting this Image_table but getting error what might be wrong.

Thanks!
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63632 Visits: 13298
You apparently added a Tablix but didn't specify a dataset.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
Koen Verbeeck (7/31/2012)
You apparently added a Tablix but didn't specify a dataset.


Yes!You are correct i have corrected them.now i have another problem.
I am able to publish the result in my system.
how can i view the report from another system

Say System A is my system where i will publish the report and able to see the report ,but in system B if i specify the ipaddress of system A and SystemAipaddress[XXX.XX.XXX.XX]/Reports/Pages/Folder.aspx i am not able to view why. In system A i have not set it as localhost instead i have kept as
http://SystemAipaddress[XXX.XX.XXX.XX]/Reportserver
so eventually i must be able to see this report from System B, but I'm unable to see the report.How to resolve this.


Thanks
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63632 Visits: 13298
Any errors when you try to browse to Report Manager?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
No i am not getting any error while browsing report manager.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63632 Visits: 13298
Perhaps a security issue?
How is the security configured on the datasource?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
Koen Verbeeck (7/31/2012)
Perhaps a security issue?
How is the security configured on the datasource?


I dont see any configuration issue since i web page is not promoting for any userid or password .The web page not displaying it is going for google and saying that there is no such path.

Thanks
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2434 Visits: 1387
Hi,
Any one has the solutions for it i am not able to open in another system.can any one help on this.


Thanks!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search