I created severeal reports based on a SQLite databse, all runs fine in iReport. Now, I would like to run these reports in Jasper Server 4.5. I put the SQLite JDBC driver into Jasper Server classpath, but I'm not able to create a SQLite datasource: The Data Source Administration UI requires an Username for database access. Because my SQLite database is free of any username / password (SQLite doesn't support this?) I can't pass any Username and I find no way to keep this option empty to create the Data Source.

Could anybody giv me a hint to solve this problem? Any hekp is appreciated, kind regards. Matthias.

Here is the xml code that is getting wiped:

Not sure what else to do with this....

The name of the report is in the JRXML 

So in my scriptlet I want to access the name attribute and get TestImage.

Please could anyone drop a line of scriptlet code ...

http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" 

name="TestImage" 

language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">

Am I missing something or do I need to make the entire report in Java then compile it or can I take an existing template (.jrxml) and modify that file from within my application.

Any help would be appreciated.

Thanks.

Mike

I figured out how to make everything work correctly. I did not know that I had to cast the objects retrieved from the JRXmlLoader to their "Design" equivalent. For example, when I was retrieving a textfield from the elements in a band I had to cast it to "JRDesignTextField" in order to modify the object.

I'm developing an application using the NetBeans Platform and I need to embed a report in a TopComponent.

Ideally, I would like to embed it in a TopComponent directly, but I have not problem in using a JPanel.

The problem is that I can display the report in a JFrame (no NetBeans-friendly), but I'm unable to show it neither of the components described before - TopComponent / JPanel.

I tried several ways, but I don't get any error and it's not displaying anything:

I'm attaching the (provisional) code.

Hope you can help me!

Carlos 

public final class EditorConsultasTopComponent extends TopComponent {

[...]

 @Override

    public void componentOpened() {

        // DB connection

        EntityManager em = EntityManagerFactoryHelper.getEntityManager();

        con = ((EntityManagerImpl) em.getDelegate()).getServerSession().getAccessor().getConnection();

        HashMap parameters = new HashMap();

        parameters.put(JRParameter.REPORT_FILE_RESOLVER, 

                new SimpleFileResolver(new File(EditorConsultasTopComponent.class.getResource("resources").getPath())));

        parameters.put (JRParameter.REPORT_RESOURCE_BUNDLE, 

                NbBundle.getBundle(EditorConsultasTopComponent.class));

        // set a few report parameters

        parameters.put("customer_id", 122);

        parameters.put("customer_name", "Joe");

        try {

            String reportName = "reports/test_report.jrxml";

            JasperReport report = JasperCompileManager.compileReport(this.getClass().getResourceAsStream(reportName));

            JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, con);

            JRViewer reportViewer = new JRViewer(jasperPrint);

            this.add( reportViewer  );

            this.repaint();

            this.requestVisible();

        } catch (Exception e) {

            e.printStackTrace();

        }

    }
[...]
}

I have a plsql pipeline function, that I use in my main report query.

The function defenition is: 

    Function getMeasuresValues(installation VARCHAR2, samplingInterval NUMBER, type VARCHAR2, subtype VARCHAR2, beginPeriod DATE, endPeriod DATE)  RETURN MeasureList PIPELINED; 

and the report query is:

SELECT * FROM TABLE (reporting.getMeasuresValues($P{installation},$P{samplingInterval},$P{equipmentType},$P{equipmentSubtype},$P{periodIni},$P{periodEnd}))

All is working great, but now, it need to convert the subtype parameter, which was a java.lang.String, to a java.util.Collection!

I have spent some hours trying to figure this out by doing some experiments and searching forums. But without success....

Notice that I don't wan't to pass the collection to the Function as a String with some king of separator like " 'aaa', 'bbb', 'ccc' " I will only do this if all the rest fails.

Does anyone know if this is possible? Wich type do I need on the function side? How's the query string?

Thaks in advance,

Rui Rocha

Post Edited by desousarocha at 05/16/2012 15:38

I have a requirement to replace an image holder in a report at runtime.

I can pull the logo out of the DB (from a BLOB) into a byte[].

How do I now get it to fill in the image place holder on the report?

I am using JasperReports Library 4.5.1.

I have looped through the bands and found the JRDesignImage I want to update.

 Any help please.

 Regards
Shaun

We have a display problem of product name in pdf format. JRXML file is same. However, in one server It shows the full name and the other just cut the text. The remaining code should go to next line. The field setup as follow.

Expression Class: java.lang.String
Blank When Null: Yes
Stretch With Overflow: Yes
Stretch Type: Relative to Band Height
Position Type: Fix Relative to Top

iReport Version:3.1.4

java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
 

Both server has same java running. I have attached the files. We are clueless now.

Please help urgently.

Best regards.

asif