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.
When I go to create the Ad Hoc View I don't see an option to chose directly the data source.
Only Topic, Domains and Olap Connections
And for creating a report I need an Ad Hoc View
Hozawa is thinking in either iReport Designer or Jaspersoft Studio. Once you've created a report, you can create a Topic from it and use that in other Ad Hoc Views or Reports. But coding the report straight from the datasource is a Jaspersoft Studio feature.