pcouas_1

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

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

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

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

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

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

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

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]

That's Ok with DECODE function

That' ok with decode function Resolved

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

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]

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

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

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

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

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

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

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]

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

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

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

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

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

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