logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
adageamar  
#1 Posted : Tuesday, September 08, 2015 11:21:25 AM(UTC)
adageamar

Rank: Newbie

Groups: Registered
Joined: 9/8/2015(UTC)
Posts: 1
India
Location: Mumbai

I have a table column with varbinary datatype in which I stored image, how could I show that image in the report. I am new to this reporting tool, so I dont know how that is possible.

Thank you,
epf  
#2 Posted : Tuesday, September 08, 2015 12:12:11 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 387
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
I am afraid that displaying images stored in varbinary data is not possible in this version...
Sorry, but you can add this as a feature request.
gaurav11  
#3 Posted : Friday, April 21, 2017 5:31:39 AM(UTC)
gaurav11

Rank: Newbie

Groups: Registered
Joined: 3/17/2017(UTC)
Posts: 6
India
Location: India

Thanks: 2 times
Was thanked: 1 time(s) in 1 post(s)
I achieved it using combination of Custom SQL and Custom Script

Custom SQL
cast('' as xml).value('xs:base64Binary(sql:column("tablename.columnname"))', 'varchar(max)')

Cutom Script
cell.FinalValue = "<img style='display:block; width:250px;height:250px;' id='base64image' src='data:image/png;base64,"+cell.Value+"' />";
thanks 1 user thanked gaurav11 for this useful post.
epf on 4/21/2017(UTC)
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.118 seconds.