dario.griffo

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 http://screencast.com/t/C142DDmmRb And for creating a report I need an Ad Hoc View

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?

Excellent! I didn't find the DataSet and Query Dialog, now I can load the image. Thanks a lot!

This is a duplicate, but I cannot edit or remove it. If trying to edit I get an error saying is spam, and no remove button is enabled. This is the complete question http://community.jaspersoft.com/questions/841981/loading-image-mssql-datatype-image-not-blob

I'm trying to load an image from a MSSQL server but getting an error, the data type is image on an old sql server database, is not a blob I tried setting the class to java.awt.Image, but it doesn't load This is the exception I get net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unknown image source class [b at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:466) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:441) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:333) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: net.sf.jasperreports.engine.JRException: Unknown image source class [b at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:562) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:472) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2067) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at java.lang.Thread.run(Unknown Source) Any ideas?

I tried setting the class to java.awt.Image, but it doesn't load This is the exception I get net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unknown image source class [b at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:466) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:441) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:333) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: net.sf.jasperreports.engine.JRException: Unknown image source class [b at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:562) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:472) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2067) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at java.lang.Thread.run(Unknown Source) Any ideas?