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 12»»

How to Retrieve the image data from database table and show in SSRS Expand / Collapse
Author
Message
Posted Sunday, July 29, 2012 12:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
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
Post #1336966
Posted Monday, July 30, 2012 12:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337074
Posted Tuesday, July 31, 2012 12:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
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!


Post #1337685
Posted Tuesday, July 31, 2012 12:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337687
Posted Tuesday, July 31, 2012 2:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
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

Post #1337734
Posted Tuesday, July 31, 2012 2:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337735
Posted Tuesday, July 31, 2012 3:01 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
No i am not getting any error while browsing report manager.
Post #1337739
Posted Tuesday, July 31, 2012 3:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337745
Posted Tuesday, July 31, 2012 3:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
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
Post #1337750
Posted Tuesday, July 31, 2012 9:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 336, Visits: 1,155
Hi,
Any one has the solutions for it i am not able to open in another system.can any one help on this.


Thanks!

Post #1338289
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse