Loading images on jaspersoft server
Posted on July 24, 2014 at 7:12am
Hi all, after being able to load an image from the db in the jaspersoft studio now I want to make the same report on the jaspersoft server instance of the company.
The steps I'm doing:
Created the Data Source poiting to my SQL DB
Created a domain and a derived table (selecting the tables I want previously) with the following SQL
SELECT student.txtname AS Name,
student.dtedob AS DateOfBirth,
student.image AS Image
school.txtname AS College,
FROM tblstudent student
JOIN tblschool ON tblschool.schoolid = student.schoolid
When I run the query I see as available fields the name, date of birth and college name, but no the image (is a blob)
Is it possible to load images on jaspersoft server so I can show the student pic next to the data on the report?
Posted on July 24, 2014 at 9:20am
Just use a datasource instead of a domain. Domains have limitation on supported datasources.