subreports into subreports using jasperintelli

[sandermoelands]

Hello,

 

I need some help with a report template that I'm trying to deploy on a JasperIntellegence server. When using a main template with multiple subreports, the generation of the report works perfectly. (The subreports are added as resource of the reportunit).

 

When I try to use subreports in the subreports I already added, so:

 

-main report

--subreport

---subreport

--subreport

 

I get a NullPointerException when trying to generate the report. I've tried multiple links to different places in the repository, but nothing seems to be working. I also searched the forum for a similar problem, but couldn't find any.

 

Is this a known problem with the Jasper Intelligence server?

 

I'm using JasperIntelligence server version 1.0.1 deployed as a war file in a tomcat server version 5.5.17

 

I hope that someone can help me!!

Thank you in advance!

 

kind regards,

Sander Moelands

[javydreamercsw]

Does the report work properly out of jasperintelligence (i.e. iReport)? I have deployed reports like yours under the same settings with no problem. Maybe is a report problem.

 

Also if it requires inputs it might be a definition issue.

[sandermoelands]

Yes, the report does work properly from within iReport.

 

I have one paramater that I need to supply with the main template and that is passed to all of the subreports.

When I generate the report under JasperIntelligence, supplying the parameter with a control, it works for the main report with the first layer of subreports, but when I add the second layer of subreports, it brakes down.

 

Could you supply a simple example of a multi subreport layer setup (that works for you? (for example just showing an id?

[swood]

How are you referring to the 2nd level of subreports from the 1st level? The subreportExpression example below is pointing to a "local" sub report resource. How does your subreportExpression look?

 

Code:

<subreport  isUsingCache="true">
	<reportElement
		x="2"
		y="2"
		width="547"
		height="43"
		key="subreport-1"/>
	<parametersMapExpression><![CDATA[new HashMap($P{REPORT_PARAMETERS_MAP})]]></parametersMapExpression>
	<subreportParameter  name="userid">
		<subreportParameterExpression><![CDATA[$F{id}]]></subreportParameterExpression>
	</subreportParameter>
	<connectionExpression>$P{REPORT_CONNECTION}</connectionExpression>

	<returnValue subreportVariable="SUM_amount_1" toVariable="user_total_deals"/>
	<returnValue subreportVariable="avg_days_to_close" toVariable="user_avg_days_to_close"/>
	<subreportExpression>"repo:«»SubReportDetail"</subreportExpression>
</subreport>

 

 

Sherman

JasperSoft

[lucianc]

This behaviour is caused by a bug in the JasperIntellegence code. Some required context information is missing for second level subreports.

 

The bug is fixed now. You can test (and use) the fix by including the attached jar in your web application.

 

There are also a couple of workarounds to the issue. If you can't/don't want to use the fix, I'll post them.

 

Regards,

Lucian [file name=jasperserver_api_engine_impl_0_fix.jar size=2085]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jasperserver_api_engine_impl_0_fix.jar[/file]

[sandermoelands]

This is the subreport link I use from my main report to the first subreport:

 

Code:

<subreport  isUsingCache="true">

  <reportElement 
    x="0" 
    y="0" 
    width="535" 
    height="25" 
    key="subreport-1" 
    positionType="Float"/>

  <subreportParameter  name="IssueID">
    <subreportParameterExpression><![CDATA[$P{IssueID}]]></subreportParameterExpression>
  </subreportParameter>

  <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

  <subreportExpression class="java.lang.String"><![CDATA["repo:BeleggingsStrategie"]]></subreportExpression>

</subreport>

 

 

This is the second subreport link I use from my first subreport:

 

Code:

[code] <subreport isUsingCache="true"> <reportElement x="0" y="98" width="531" height="76" key="subreport-1"/> <subreportParameter name="IssueID"> <subreportParameterExpression><![CDATA[$P{IssueID}]]></subreportParameterExpression> </subreportParameter> <subreportExpression class="java.lang.String"><![CDATA["repo:Beleggingen"]]></subreportExpression> </subreport>

 

I placed them both in the "local" resources folder of the main report.

 

Did I maybe incorrectly setup the folder structure in the repository of the JasperIntelligence server?

[sandermoelands]

:) Great!!!

 

Thanks a lot!!!

 

That fix did it, it works perfect now!!

 

Once again thank you very much, will this fix also be included in the new version of JasperIntelligence?

[lucianc]

Thank you for detecting this :)

 

The fix will, of course, be included in the next release.

 

Regards,

Lucian

Post edited by: lucianc, at: 2006/08/29 14:39

[Kacper]

lucianc wrote:

The bug is fixed now. You can test (and use) the fix by including the attached jar in your web application. There are also a couple of workarounds to the issue. If you can't/don't want to use the fix, I'll post them. Regards, Lucian [file name=jasperserver_api_engine_impl_0_fix.jar size=2085]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jasperserver_api_engine_impl_0_fix.jar[/file]

 

Hello.

Can you describe how exactly should I use this fix with JasperIntelligence and/or how to solve this problem without this fix?

[lucianc]

To use the fix, you simply have to include the fix jar in your web application, i.e. copy it to $TOMCAT/webapps/jasperserver/WEB-INF/lib.

 

Possible workarounds:

Use Javaflow continuations for subreport instead of threads.

 

To do this, you need to include the Javaflow in your web app and set this property in jasperreports.properties:

Code:

net.sf.jasperreports.subreport.runner.factory=net.sf.jasperreports.engine.fill.JRContinuationSubreportRunnerFactory

(jasperreports.properties should be placed somewhere on the application classpath, e.g. under WEB-INF/classes).

 

You might also need to replace the JasperReports jar from the JasperIntelligence with one downloaded from the JR web site, I'm not sure whether the one included with JasperIntelligence is Javaflow-enabled.

Load the second subreport in the master and pass as a parameter to the first subreport:

Code:

[code] //in the master <subreport> .. <subreportParameter name="SubreportB"> <subreportParameterExpression> net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation("repo:«»SubreportB"«») </subreportParameterExpression> </subreportParameter> <subreportExpression>"repo:«»SubreportA"</subreportExpression> </subreport> //in the first subreport <parameter name="SubreportB" class="net.sf.jasperreports.engine.JasperReport"/> <subreport> <subreportExpression class="net.sf.jasperreports.engine.JasperReport">$P{SubreportB}</subreportExpression> </subreport>

[/ol]

 

Regards,

Lucian

[Grazy Mos]

I got a similar problem, is the fix already include in the newest version of jasperIntelligence?

 

 

This is in my master report:

Code:

<subreportExpression  class="java.lang.String"><![CDATA["repo:«»SUP_REPORT"]]></subreportExpression>

I loaded a report named SUP_REPORT in jasperIntelligence,

 

 

When I run the master report in jasperIntelligence it gives the follow error:

Code:

[code]java.lang.Exception: 1 - null at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:503) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:409) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:66) at java.lang.Thread.run(Unknown Source)

 

Any idea what causes this error?

And I noticed I needed to put the "url" in a string instead in a java URL, why?

 

Thanks in advance,

 

Niels,

[lucianc]

Are you sure it's a similar problem? The original issue involved nested subreports (i.e. subreports in subreports). The 1.1.0 release fixes this issue.

 

If you want to identify the cause of your error, check the Tomcat log since it seems that the exception details don't make it to the web service caller.

 

You have to specify the resource URL as String because the JI engine needs to control the java.net.URL instantiation so that this object can open a connection to read resource data from the repository. This is required because the standard Java URL handler registration mechanism is not suitable for a multi-application container such as Tomcat.

 

Regards,

Lucian

[Grazy Mos]

You're right its not the same problem, its only a report linked to a subreport

 

This was the error:

Code:

2006-12-06 15:49:32,531 DEBUG [org.springframework.web.servlet.DispatcherServlet] Handler execution resulted in exception - forwarding to resolved error view: ModelAndView: reference to view with name 'JSErrorPage'; model is {exception=org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@5128b9bc targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@7621c3b0, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is java.lang.NullPointerException: null}
org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@5128b9bc targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@7621c3b0, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is java.lang.NullPointerException: null
java.lang.NullPointerException
	at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:102)
	at java.net.URL.openStream(URL.java:1007)
	at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:139)
	at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:243)
	at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:324)
	at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:277)
	at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1289)

 

I still cant figure out what i did wrong, note if i run the report without the subreport its works ifne.

 

 

Thanks in advance,

 

Niels

[Grazy Mos]

I discoverd what I did wrong, I added the report and the sub_report with the ireport Plugin. When you add the reports with the normal browser it detects that there is a sub_report and asks you where its located.

 

This wont happen when adding it with the ireport plugin, so he gives a "missing attribute" error when running the report.

 

edit: I believe the sup_report should be located in the resources file at the report unit,

 

But i am not sure if can you get a nested sub report in the resources file,

Post edited by: Grazy Mos, at: 2006/12/07 10:36