[sub report with blank Page]

YES I tried it with variable REPORT_COUNT comming from SUBREPORT

In my SubReport my LineChart and my Cross tab are in Summary section

 

Regards

[sub report with blank Page]

Hi,

I have an main report with an sub report when Query in subReport give me no result, i want No page and currently i have Blank page .

In my sub Report i have selected "When no Datas No pages" without succes ??

In my master Report i have checked "Remove Line When blank"

Where is my mistake ?

Regards

Phil

[: Parameter "DATABASE_TIMEZONE" does not exist.]

Hi,

 

I have resolved problem with replace

    <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "report38.jasper"]]></subreportExpression>

BY

  <subreportExpression><![CDATA["repo:report38Ress"]]></subreportExpression>

Then i have added an Ressource named report38Ress to my parent master Report in JasperServer. This new ressource is subReport jrxml file

 

Regards

Phil

 

 

[: Parameter "DATABASE_TIMEZONE" does not exist.]

Hi,

I use Report 5.6.0 BUT JasperServer 6.2

In my main Report i have following line

    <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "report38.jasper"]]></subreportExpression>

 

Regards

 

 

[: Parameter "DATABASE_TIMEZONE" does not exist.]

Hi,

I have make an report with an SubReport with IRepor 5.6.0 and subReport name is name38.jasper, but when i call it from jasperServer

i have following eror message

2016-03-14 19:09:16,561 ERROR JRFillSubreport,pool-4-thread-24:878- Fill 1: exceptionnet.sf.jasperreports.engine.JRRuntimeException: Parameter"DATABASE_TIMEZONE" does not exist.    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)    atnet.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)    atnet.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)    atnet.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)    atnet.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)    at java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)    atjava.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)2016-03-14 19:09:16,562 ERROR AsyncJasperPrintAccessor,pool-4-thread-24:315 -Error during report executionnet.sf.jasperreports.engine.JRRuntimeException: Parameter"DATABASE_TIMEZONE" does not exist.    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)    at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)    atnet.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)    atnet.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)    atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)    atnet.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)    atnet.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)    at java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)    atjava.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)[/code]

When i call subjreport directly that's Ok

Where is my mistake

Regards

Phil

[cascading input test parameter]

Hi,

I have define an first parameter name isGrpMoreTweleve like this with default value expression

Boolean

(((int) ((new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeFin}).getTime() -
new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeDebut}).getTime())/(1000*60*60*24)))>365 ? true:false)

 

AND i want use it

($P{isGrpMoreTweleve} ?
    "nvl(decode ((TRUNC((to_number(to_char(iv.inventory_date, 'MM'))-1) / 3)+1), 1,'First Quarter',2,'Second Quarter',3,'Third Quarter',4,'Fourth Quarter', ''),'') || '-' || to_char(iv.inventory_date, 'YYYY')"
    : "to_char(iv.inventory_date,'MON-YYYY')")

This second value expression is NOT Ok

Why ?

Regard

Phil

 

[How Diff date could return true]

Hi,

 

I want define an parameter for date difference, but that's not working ?

(((int) ((new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeFin}).getTime() -new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeDebut}).getTime())/(1000*60*60*24)))>365 ? true:false)[/code]

 

Where is my mistake

Regards

[show logs of parameter expression in function]

Hi,

I want show error message of following parameter function.

How could i make it ?

Regards

 

(((int) ((new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeFin}).getTime() -new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeDebut}).getTime())/(1000*60*60*24)))>365 ? true,false)[/code]

[java.lang.IllegalArgumentException: Null 'key' argument.]

That's Ok with DECODE function

[return value from an value in select]

That' ok with decode function

Resolved

[return value from an value in select]

Hi,

I have an Date in my query and i want replace date by special label for quarter month.

I have tried with CASE without succes  !

An idea regards ?

 

( "(CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'Third Qtr'   WHEN '4' THEN 'Fourth Qtr'  end)"

I need to use this new label in crossTab column and in lineChart Column too

 

Regards

Phil

[java.lang.IllegalArgumentException: Null 'key' argument.]

Hi,

 

JasperServer.log give me following error message "java.lang.IllegalArgumentException: Null 'key' argument."

But my complet query is running into SQLDevelopper !

The error is in subpart

($P{isGrpMoreTweleve} ? "(CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'Third Qtr'   WHEN '4' THEN 'Fourth Qtr'  end)" : "to_char(iv.inventory_date,'MON-YYYY')")

($P{isGrpMoreTweleve} is an boolean with defaultValue

 

Regards

jasperserver.log

query string: SELECT     (to_char(iv.inventory_date,'YYYY') || (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ) AS tri,   (CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)  WHEN '1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN'Third Qtr'   WHEN '4' THEN 'Fourth Qtr'  end) AS label,     NVL(SUM(va.QUANTITY_USED),0) AS value1,     va.VESSEL_UID,  ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN'1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end) as trititleFROM     LO_VALUATION va,LO_VESSEL ve,lo_inventory ivWHERE va.VESSEL_UID=ve.VESSEL_UIDand va.month=iv.inventory_monthand ve.TEU_UID in (2,6,8,12)and iv.inventory_date BETWEEN to_date('20/09/2010','DD/MM//YYYY') AND to_date('01/10/2013','DD/MM//YYYY')GROUPBY (to_char(iv.inventory_date,'YYYY') ||(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1'THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end),    va.VESSEL_UID,ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN'1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end)ORDER BY(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1'THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end),     va.VESSEL_UID ASC2016-03-10 19:20:31,351 ERROR AsyncJasperPrintAccessor,pool-4-thread-56:315 - Error during report executionjava.lang.IllegalArgumentException: Null 'key' argument.[/code]

[Dupplicate reports Controles]

Hi

I have some reports with same input parameters, so with same input controls, How could i avoid to recreate it for each new report ????

Regards

[sql select rtrim give null]

Hi

 

I have an table with right blank, how could i make an RTRIM or limit with of my table component ?

Regards

Phil

 

[crosstab ireport COLUMN ORDER BY]

Hi,

Could i Group By with one numer Column and viewing label of colum is an other value ?

Example Group by Month value and show Month Name

Regards

 

 

 

 

[crosstab ireport COLUMN ORDER BY]

Hi

 

Currently i a=have an Line Chart and in my Main report Query there is an order by. How could i realiste this Order by i crosstab ?

I have same datas, but crossTab is not sorted !!

Regards

Phil

[parameter from url visible like an table component]

Hi,

Currently my report show an Line Chart, but could i show an result comming from another Query without an sub report ?

i pass an paramter lst from url like this lst=2,5,6, and i want showing an table element top of my line chart with label comming from select lbl from tblelabel where key=$P(lst) ?

Regards

 

[parameter from url not passing into report]

Hi,

I calling Report from JasperServer with following URL http://localhost:8081/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports%2FCMA&reportUnit=%2Freports%2FCMA%2Freport26&periodeDebut=01/09/2012&periodeFin=01/10/2013

My Parameters are null on screen ?

I have created two parameter periodeDebut and periodeFin and when i call my report from IREPORT i could input my parameters ?

Where are my mistake ?

 

Regards

Phill

 

[between and parameter]

betweenHi

If i create an parameter (" and iv.inventory_date BETWEEN $P{periodeDebut2} AND to_date('20121230','YYYYMMDD')") where periodeDebut2 is a String parameter$, i have following error message

 Time zone: Default Error filling print... Error executing SQL statement for : report18
For input string: "" 
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report18 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:287) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:760) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: java.sql.SQLException: ORA-00907: parenthèse de droite absente
 
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) 
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) 
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) 
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799) 
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) 
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) 
    ... 11 more 
Print not filled. Try to use an EmptyDataSource..

But with " and iv.inventory_date BETWEEN '30/12/2012' AND '30/12/2012'" i have no error ?
Where is my mistake ?

How could i see SQL query ?


Regards
Phil

 

between</pre>[/code]

[Consult report without login]

Hi,d

 

I have adder password and in url, but it's visible by customer, that's not best solution.

My JasperServer is Community edittion 6.2, i think in application-security.xml i need to add ANONYMOUS but where ?

 

<bean id="flowVoter" class="com.jaspersoft.jasperserver.api.security.FlowRoleAccessVoter">
        <property name="flowAccessAttribute" value="FLOW_ACCESS"/>
        <property name="flowDefinitionSource">
            <value>
                repoAdminFlow=ROLE_ADMINISTRATOR
                userListFlow=ROLE_ADMINISTRATOR
                roleListFlow=ROLE_ADMINISTRATOR
                editFolderFlow=ROLE_ADMINISTRATOR
                fileResourceFlow=ROLE_USER,ROLE_ADMINISTRATOR
                listOfValuesFlow=ROLE_USER,ROLE_ADMINISTRATOR
                reportDataSourceFlow=ROLE_USER,ROLE_ADMINISTRATOR
                inputControlsFlow=ROLE_USER,ROLE_ADMINISTRATOR
                tenantFlow=ROLE_ADMINISTRATOR
                createSLDatasourceFlow=ROLE_USER,ROLE_ADMINISTRATOR
                userEditFlow=ROLE_ADMINISTRATOR
                roleEditFlow=ROLE_ADMINISTRATOR
                queryReferenceFlow=ROLE_ADMINISTRATOR
                searchFlow=ROLE_USER,ROLE_ADMINISTRATOR
                *=ROLE_USER,ROLE_ADMINISTRATOR
            </value>
        </property>
 

Regards

Phil

 

[Same conditionnal SQL chart on many Pages]

Hi,

Currently i have an Chart obtain with SQL Query on same page with many Lines

Now i need to split dynamically this Chart on many Pages. One page by Graphical Line, BUT name and number of Lines depends of SQL Query ?

How could i make it ?

 

Regards

Phil

[Consult report without login]

Hi,

 

How could i avoid login page for executing my report ?

My URL is http://xx.xxx.xxxx.xxxx:8081/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2FReports%2FCMA&reportUnit=%2FReports%2Freport23&decorate=no&output=pdf

 

In JasperServer i have autorised ANONYOUS user to  Execute Only in Reports directory ?

I have made an test with adding &LoginRequested=false at the end of url without succes

Regards

Phil

[PDF SAVE AS]

HI

I could viewing PDF on screen but i want make an Save AS. Could i ask jasperserver to make an Save As

 

Regards

Phil

 

[generating PDF output without adding Java Code]

Ok, but How ?

http://localhost:8081/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports%2FCMA&reportUnit=%2Freports%2FCMA%2Freport23&decorate=no&output=pdf

 

[generating PDF output without adding Java Code]

Hi,

 

Could JasperServer generate PDF file without adding Java Code ?

Jasper server has no standard page to generate PDF from JRXML file or from Jasper file ?

My jasper fiel has In parameters

Regards

Phil