Latest Topics

iReport in windows 7 x64

Sat, 11 Feb 2012 08:03:31 +0000

Hi,

After installation of iReport 4.5.0 when i run the ireport i find the following error.

"A java.lang.NullPointerException has occured. Click show the details" and the detail is

java.lang.NullPointerException

at java.awt.Dimension.(Dimension.java:91)

at javax.swing.plaf.basic.BasicProgressBarUI.getPreferredSize(BasicProgressBarUI.java:757)

at javax.swing.JComponent.getPreferredSize(JComponent.java:1615)

at org.netbeans.modules.progress.ui.NbProgressBar.getPreferredSize(NbProgressBar.java:90)

at org.netbeans.modules.progress.ui.StatusLineComponent.(StatusLineComponent.java:137)

at org.netbeans.modules.progress.ui.ProviderImpl.getDefaultWorker(ProviderImpl.java:59)

at org.netbeans.progress.module.Controller.getProgressUIWorker(Controller.java:128)

at org.netbeans.progress.module.Controller.run(Controller.java:332)

at org.netbeans.progress.module.Controller.actionPerformed(Controller.java:357)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

at javax.swing.Timer.fireActionPerformed(Timer.java:271)

[catch] at javax.swing.Timer$DoPostEvent.run(Timer.java:201)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)

at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

Please help to solve my problem.

Measures MDX in Report return No such tuple on axis 0

Sat, 11 Feb 2012 01:01:45 +0000

I have an MDX query that works but when put into an iReport report I get "No such tuple ([Measures].[a]) on axis 0." Thing is I can bring up the dimenions no problems. Just measures it cannot. The query is below. It's funny because the measures are on axis 1 so I placed flipped the query and placed measures on axix 0 with the same "No such tuple ([Measures].[a]) on axis 0" error. [Order Fulfillment and Survey] is a virtual cube, I also tried with a cube and a much simplier query without cross joins and the same issue happens. I'm using iReport 4.1.3. JasperReports version 4.1.3. Java 6 Update 25. Not that it matters but Oracle 11g DB.

Does anyone know how to resolve this?

Code:

SELECT
NON EMPTY [Service Order].[Day].Members ON COLUMNS,
NON EMPTY CrossJoin({
[CSAT],
[Measures].[a],
[Measures].[b]
},
[Product Type].Children
)
) ON AXIS(1)
FROM [Order Fulfillment and Survey]

Trying to retrieve/display a PDF from the database

Fri, 10 Feb 2012 22:15:35 +0000

I have notes on how to pull an image (gif, jpg, etc., stored in Base64 format) from the database and display it in iReport (I've pasted those notes below, in case they're of help to anyone). I was hoping to use a similar technique to pull and display a PDF from our database! It seems unlikely to work, but our financial software stores receipts as PDFs, and I've written a report that lists transaction history. I was thinking how nice it would be to write a "drill-down" report, where each transaction on the history report has a hyperlink that would pass the transaction index to a second report that just pulls/displays the receipt for that transaction. I would also pass the parameters from the transaction report down to the receipt report so I can have another hyperlink at the top of the receipt report to "go back" to the history report (passing all the original parameters back to it). I also have notes on how to do the drill down and "drill up", so I think those are working corrrectly. My real problem is that the PDF isn't an "image", and I don't know if there's any support for treating it similar to an image and somehow viewing it inside a report. In fact, since it's a receipt, not a "document", I'd love to convert it to an image on the fly, but I'm just using iReport and JasperServer, so it's not as though I can program any kind of unsupported transformation within a Java application. Any ideas?

Carl

If you have a Base64 image field like PERSON_ID.IMAGE that you want to display on the report, here are the steps:

1. Obviously, include the field in the query itself.

2. Change the field data class of your field from java.sql.Blob to java.awt.Image. I don’t think that’s in the drop-down list in iReport, but you can go right into the XML and edit the line that looks like this:

3. Drag an image element from the palette onto the design pane. When the wizard asks you to choose a file, click “Cancel”. iReport will still leave an image placeholder icon on your band.

4. Set the properties for the image. Set the size and position as normal. Change the Expression Class from java.lang.String to java.awt.Image (this should be available in the dropdown). Change the Image Expression from blank to the field you’ve gotten in your query, e.g. $F{PERSON_IMAGE}

group and subgroup

Fri, 10 Feb 2012 18:09:02 +0000

Hello, guys.

This is my first post, so forgive me for any mistake while posting.

I have a report which is now like this:

http://img440.imageshack.us/img440/9525/relatorioy.png

and the structure:

http://img576.imageshack.us/img576/7426/estruturarelatorio.png

but I need to make a sum where it's "null" getting all the values in the R$ column (I already have them), for each of the groups (Despesas de Escritório, Despesas com Pessoal Administrativo etc.).

All I have done so far is to make a sum of all the data until the end of the page (reset type = page.. reset type = group brings me this "null").

Sorry for the portuguese report, but I think it's quite comprehensive.

Thanks!

Post Edited by andrezinn at 02/10/2012 18:10

LDAP authentication with sub organization

Fri, 10 Feb 2012 16:30:05 +0000

We have Jasper-pro. In Jasper, we have created the following org structure:

Our_Org (single organizatin)

SubA

SubA1

SubA2

SubB

SubB1

SubB2

In stead of getting Org structure info from LDAP and synchronize, we want the user to type-in the predefined org_name (i.e. SubA, or SubA1) and authenticate the user into that org directly.

Anyone has done this or something similar? My thinking is to pass the org_id from login page to defaultOrganizationIfNotDetected in applicationContext-multiTenancy-security.xml... Is it possible? How can it be done? Am I heading down the wrong path? Could someone point me to the right direction, please? Thanks.

RESTful api support in jasper reports 4.5.0 community version

Fri, 10 Feb 2012 14:43:10 +0000

I was going through the examples in JasperReports-Server-Web-Services-Guide.pdf and all was working until I got to the example on page 24.

GET /jasperserver-pro/rest/resource/images/JRLogo?file=attachment HTTP/1.1

I entered into my browser:

http://jasperadmin:jasperadmin@localhost:8080/jasperserver/rest/resource/images/JRLogo?file=attachment

as the example described, but instead of downloading the JRLogo file I was displayed the error message:

request contains unsupported parameters

The only parameter I'm passing is file and the documentation specifically says that it is a parameter that can be passed here. Is this functionality supported in the community version?

Any help would be appreciated, Thanks in advance.

Drop Down Boxes

Fri, 10 Feb 2012 13:01:13 +0000

Is it possible to add drop down boxes for users instead of having them type anything in?

Thanks

why jasper report is running immidiately instead of specified time

Fri, 10 Feb 2012 11:24:40 +0000

Hi,

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

Code:

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);

jasper server is running report immidiately instead of specified time

Fri, 10 Feb 2012 11:23:46 +0000

Hi,

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

Code:

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);

jasper report is running immidiately instead of specified time

Fri, 10 Feb 2012 11:20:08 +0000

Hi,

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

Code:

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);