[Error: Error occured while displaying report net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.]

Meanwhile I found this usefull article, which solved my question:

http://community.jaspersoft.com/wiki/calling-oracle-stored-procedures-jasperreports-server

[How to set up a report's dataSource]

Hello, I have a report, with no link to dataSource.

I would like to call it through REST API service (REST URL).

How can I set up:

1. dataSource which should be used? In JasperServer I have more dataSources Defined, but don't know hot to set it up from our app, which call reports.

2. authentication set up

So far I'm calling reports via URL

http://[server_ip]:[port]/jasperserver/rest_v2/reports/reports/rep_pj_fakt_archiv.pdf?j_username=jasperadmin&j_password=jasperadmin&P_RIDIC_ID=1234&P_ROKMES=2015/01

Thanks,

Tomas

[Error: Error occured while displaying report net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.]

Hello what .jar is missing in path when I'm getting an error:

Error occured while displaying report net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.
net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getExecuterFactory(JRQueryExecuterUtils.java:114)
net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1069)
net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)
net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1235)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:859)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:804)
net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:407)
net.sf.jasperreports.engine.JasperRunManager.runToPdfStream(JasperRunManager.java:201)
net.sf.jasperreports.engine.JasperRunManager.runReportToPdfStream(JasperRunManager.java:720)
co.gerger.bdf.view.JasperReportsServlet.doGet(JasperReportsServlet.java:106)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
co.gerger.filters.GZIPFilter.doFilter(GZIPFilter.java:48)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
java.lang.Thread.run(Unknown Source)

Thanks,

Tomas

[Conditional formating used in Crosstab does not work]

Hi folks,

I have a defined custom style at report level with an condition which is based on field from query:

    <style name="Crosstab Data Text" mode="Transparent" hAlign="Center">        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean( $F{TYP_HH} == 'D' )]]></conditionExpression>            <style mode="Opaque" forecolor="#FFFFFF" backcolor="#FF9999"/>        </conditionalStyle>    </style>[/code]

 

 

When I use this style for any field in report (outside crosstab), then it works fine. But I would like to use it within Crosstab. A problem is, that when a report is compilled an error occurs:

 

net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 
     1. Field not found : TYP_HH

 

Style evaluation at report level is set to TRUE:

<property name="net.sf.jasperreports.style.evaluation.time.enabled" value="true"/> [/code]

Any idea or trick how to apply conditional formatting within Crosstab?

 

Thanks,

Tomas

[Problem with eastern europe encoding]

Hi folks,

 

I'm working with iReports just for a few days, so please consider me as a newbe.

 

I've created a simple report, which includes some eastern europe characters (e.g.: Ä Å™ ž Å¥ etc ). When I preview report from iReports output is displayed correctly. Unfortunately, when running report from application, all those characters are skipped.

As report's local parameter I tried to pass values: cs_CZ and set an encoding to "Windows-1252", but no luck.

 

Could you please suggest what might be wrong?

 

Kind regards,

Tomas

Post Edited by tkepic at 06/07/2010 08:30