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 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

Hi,

I made a report which consists of 2 x 2 stickers printed on A4 (4 stickers per page).  It consists on a subreport that print the label/sticker on 2 columns following the order:
 

How can I choose the position of the first sticker?

i.e.: the first time I print the report it prints 7 stickers, so I still have 1 sticker unused on the last sheet of stickers. The next time I use the report I would like to choose the position of the sticker, so I could use that one left sticker on the last sheet.
 

Thanks in advance.
 

I'm making some test with a software that uses Jasper Reports and I'm totally lost with this error:

Caused by: java.lang.ClassNotFoundException: org.codehaus.mojo.jasperreports.MavenJavacCompiler
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    at net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:460)

I searched for class "org.codehaus.mojo.jasperreports.MavenJavacCompiler" without success so I don't know what jar I need to add to resolve this...in the case that the problem is that.

Can someone provide me a configuration file check , debug option, something....to solve this error?

I'm using this version: jasperreports-3.7.6.jar

Thanks!

I have a Text Field with width of 140. The value that populates it can vary in length from 50 to 130.

What happens now is, there is a huge gap between this Text Field and the next report element. My report looks like this(The name is a dynamic value) :

I, Mark Rogers     , the undersigned employee

when I want it to be

I, Mark Rogers, the undersigned employee

I have tried trim() on the Text Field. But I realized that this works only if there are trailing spaces in the dynamic value and it does not trim the Text Field white spaces. Is there a way to remove these extra white spaces in the Text Field after the it is populated? Or is the best work around to reduce the width of the Text Field and give a Stretch with Overflow?

Thanks for the support.

ByteArrayOutputStream pptStream = new ByteArrayOutputStream();
JRPptxExporter pptxExporter = new JRPptxExporter();
pptxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
pptxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, pptStream);
try {
   pptxExporter.exportReport();
} catch (JRException ex) {
   System.out.println("ERROR : " + ex.getMessage());

}
pptStreamByteArray = pptStream.toByteArray();

a seemingly simple problem - but not quite.

i need to fill the remainder of the last page with blank lines. so basically the table in the report ends and then i want to hve blank lines from the last row to the bottom of that page.

i have created a scriptlet where i store and evaluate where the last row with data ended. i then know the page that happened on so i keep printing a row until the current page is greater than the page where the last data row ended. i then return false for the expression so no more rows are printed.

this is a start - but, the report still goes one page further so i need to cut it off sooner... if i could get access the JRFiller doing the work i could compare the y offset to the page height and then cut off sooner for the blanks before it crosses to the next page and asks again whether to print the blank one. The JRFiller seems to be unreachable though... i can get the JasperReport object, but i can't see the filler from here.

any suggestions to achieve this would be most appreciated. thanks :)

current scriptlet looks something like below.

    public Boolean shouldPrintBlankLine() throws JRScriptletException {

        Boolean fieldValue = (Boolean) getFieldValue("blank");
        if (BooleanUtils.isTrue(fieldValue)) {
            
            Integer currentPage = (Integer) getVariableValue("PAGE_NUMBER");
            if (pageNumberWithFirstBlankRow == -1) {
            
                pageNumberWithFirstBlankRow = currentPage;
            
            } else if (pageNumberWithFirstBlankRow < currentPage) {
                
                return false;
            }

            return true;
        }
        
        return false;
    }