Photos in VarBinary Format

[2005 IR Help]

By: V.A.V.K. Kishore - javakishore

Photos in VarBinary Format

2004-07-26 10:47

Hi,

 

I need suggestions from users of JasperReports, whether we can achieve this or not:

 

Requirement: In the DB (SQL Server) we store user details and every user photo in a varbinary format.

 

We need to generate a batch report of all user details with photo against each user. I need to execute an SP to get all user details and one column in each row will have user photo in varbinary format.

 

Question:

How should I define my <filed> element in my jasper template, meaning what class name I should give here:

<field name="userphoto" class="?">

 

Thanks in advance,

Kishore Veleti