felded53
Members-
Posts
16 -
Joined
-
Last visited
felded53's Achievements
-
The article https://community.jaspersoft.com/project/web-service-data-source/releases describes support of version 1.5 for Web Service Data Source. And it's for Jaspersoft v. 6.4 My question: will it support Jaspersoft v 7.2 and latest v. 7.5 ? If not - any expectations on new releases ? Thanks, Edward.
-
I am getting below error while creating domain by using JSON data source.
felded53 replied to shruti.kale's topic in Products
I have absolutely identical error as described above. -
I have an Oracle stored procedure within the package and I'm successfully run this stor proc from Oracle SQLDEVELOPER and TOAD. When I do call in iReport 5.6 and JasperStudio 6.1 - no errors at all but report is blank, no records. Is any idea? Here is what I'm doing: 1. Query Language Executer is plsql; {call DA.PLZ0018_UNION_PR_PKG.UNION_PR_REPORT($P{ORACLE_REF_CURSOR}, $P{P_COMP_CODE}, $P{P_PAY_DATE})} 2. Stor proc in Oracle: PROCEDURE Union_PR_Report (CUR_OUT OUT SYS_REFCURSOR, P_COMP_CODE IN VARCHAR2, P_PAY_DATE IN DATE) IS BEGIN OPEN CUR_OUT FOR SELECT JOB.JOB_COMP_CODE AS COMPANY_CODE, CASE WHEN JOB.JOB_STATUS_CODE = 'I' THEN 'In Prog' WHEN JOB.JOB_STATUS_CODE = 'C' THEN 'Comp' END AS JOB_STATUS, JOB.JOB_CODE AS JOB_CODE, JOB.JOB_NAME AS JOB_NAME, PY_EMP.EMP_NO AS PY_EMP_NO, PY_EMP.EMP_FIRST_NAME AS PY_EMP_FIRST_NAME, PY_EMP.EMP_MIDDLE_NAME AS PY_EMP_MIDDLE_NAME, PY_EMP.EMP_LAST_NAME AS PY_EMP_LAST_NAME, SUM (CASE WHEN PHY_TRAN_TYPE = 'BW' THEN PHY_AMOUNT END) AS PHY_AMOUNT_BW, SUM (CASE WHEN PHY_TRAN_TYPE = 'BN' THEN PHY_AMOUNT END) AS PHY_AMOUNT_BN, SUM (CASE WHEN PHY_TRAN_TYPE = 'BN' THEN PHY_AMOUNT END) / SUM ( NULLIF ( CASE WHEN PHY_TRAN_TYPE = 'BW' THEN PHY_AMOUNT ELSE 0 END, 0)) AS BURDEN_PERCENT FROM PYEMPPAYHIST PY_PAYHIST INNER JOIN JCJOB JOB ON JOB.job_comp_code = PY_PAYHIST.PHY_COMP_CODE AND JOB.JOB_CODE = PY_PAYHIST.PHY_JOB INNER JOIN DA.PYEMPLOYEE PY_EMP ON PY_PAYHIST.PHY_COMP_CODE = PY_EMP.EMP_COMP_CODE AND PY_PAYHIST.PHY_EMP_NO = PY_EMP.EMP_NO WHERE PY_PAYHIST.PHY_COMP_CODE = P_COMP_CODE --SYS_CONTEXT ('CMIC', 'P_COMP_CODE') AND PY_PAYHIST.PHY_JOB IS NOT NULL AND PY_PAYHIST.phy_union_code IS NOT NULL AND JOB.JOB_STATUS_CODE IN ('I', 'C') AND trunc(PY_PAYHIST.PHY_PAY_DATE) = trunc(P_PAY_DATE) --TO_DATE (SYS_CONTEXT ('CMIC', 'P_PAY_DATE'), 'YYYYMMDD') --'23-JUL-15' GROUP BY JOB.JOB_COMP_CODE, JOB.JOB_STATUS_CODE, JOB.JOB_CODE, JOB.JOB_NAME, PY_EMP.EMP_NO, PY_EMP.EMP_FIRST_NAME, PY_EMP.EMP_MIDDLE_NAME, PY_EMP.EMP_LAST_NAME; 3. Screen shot is attached
- 1 reply
-
- ireport 5.6
- jss
-
(and 3 more)
Tagged with:
-
In iReport I checked property "Reprint header" in order to print group header field name if next page comes with same group field name. But the same time I don't want to print totals for same group name. When checked "Reprint header" propery report print me group field name (by which it was groupped) and same time totals. How can I suppres totals amount for the same group field name, another words totals amount shouldn't be displayed in report. Thank you.
-
In the Oracle query I have a field "NVL(SOUP1.ORG_NAME, SEC.AGENT_BANK) as agent". I'd like to evaluate this expression into calculated field in Jasper Domain. Can I use an existing key isNull from "applicationContext-semanticLayer.xml" file in Jasper Domain or I have to create new entry for that? If I need to create new one - what's the language to create it? Is any example available?
-
- calculated field
- domains
-
(and 2 more)
Tagged with:
-
I'm trying to use scriptlet PrevBusDay as default date in date parameter: <parameter name="param_VAL_DT" class="java.util.Date"> <defaultValueExpression><![CDATA[$P{REPORT_SCRIPTLET}.GetDate()]]></defaultValueExpression></parameter>And I'm getting following error when run report chosing Default:Error filling print... Error creating scriptlet class instance : PrevBusDay Setting up the file resolver... net.sf.jasperreports.engine.JRException: Error creating scriptlet class instance : PrevBusDay at net.sf.jasperreports.engine.scriptlets.DefaultScriptletFactory.getScriptlet(DefaultScriptletFactory.java:118) at net.sf.jasperreports.engine.scriptlets.DefaultScriptletFactory.getScriplets(DefaultScriptletFactory.java:69) at net.sf.jasperreports.engine.fill.JRFillDataset.createScriptlets(JRFillDataset.java:507) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:626) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1313) 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.lang.ClassCastException: PrevBusDay cannot be cast to net.sf.jasperreports.engine.JRAbstractScriptlet at net.sf.jasperreports.engine.scriptlets.DefaultScriptletFactory.getScriptlet(DefaultScriptletFactory.java:110) ... 12 more I registered jar file PrevBusDay in the CLASSPATH of iReport Designer 5.6 The GetDate() is public static method from public class PrevBusDay: import java.text.DateFormat; import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date; public class PrevBusDay{ public static Date GetDate() { Date today = new Date(); Calendar calendar = Calendar.getInstance(); calendar.setTime(today); int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK); if (dayOfWeek == Calendar.MONDAY) { calendar.add(Calendar.DATE, -3); } else if (dayOfWeek == Calendar.SUNDAY) { calendar.add(Calendar.DATE, -2); } else { calendar.add(Calendar.DATE, -1); } return calendar.getTime(); } } The parameter REPORT_SCRIPTLET has Parameter Class PrevBusDayAny suggestion what I'm doing wrong?
-
Thank you. This is helpful.
-
How to use multiple JasperReports server instances with only one centralized Postgresql DB? Another words - let say I have Win server1, Win server2, Win server3 and Win server4. On windows servers1,2 and 3 I need to install only JasperReport server (Tomcat) with no Postgresql DB, but on windows server 4 I want to install only Postgresql DB. All Jasper server instances from servers 1,2 and 3 will connect to only one centralized Postgresql DB on win server4. Is it doable?
-
I tried to create a Domain in Jasper Server 5.2 connecting through datasource (JDBC) for Sybase. And I have following Error message: "Cannot get metadata for /ERP/Data_Sources/ERP_DEV: java.sql.SQLException: JZ0SB: Parameter index out of range: 1". I tested datasourse - the connection is good. I'm able to connect to DB. Is any one have/had same issue?
- 2 replies
-
- datasource
- jasperreports server
-
(and 2 more)
Tagged with:
-
I have created role for group of users with read-only options. They see only those reports they need. But when user clicks with mouse right button, pop-up menu displays option "schedule". I want to restrict user to create a schedule. How to disable "schedule" menu for users?
-
Hi, I need a help with class fie (?) - I changed a bean ID in the file applicationContext.xml from "com.jaspersoft.jasperserver.api.engine.common.service.impl.FileVirtualizerFactory" to "com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory" the bean id now is: <bean id="fileVirtualizerFactory"class="com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory"> <property name="maxSize" value="400"/> <property name="tempDirectory" value="${java.io.tmpdir}"/> </bean> But when I restarted jasper it did'nt start and the log file jasperserver.log under under directory /barcap/bwa/bil/jasperserver-pro-3.1/apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs shows following error: "11:14:15,550 ERROR [/jasperserver-pro],main:3767 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory] for bean with name 'fileVirtualizerFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]; nested exception is java.lang.ClassNotFoundException: com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory". I'm using Jasperserver 3.1.0.1 installed on LINUX box. I suspect that the cause is missing class com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory. What's jar file and directory for this class? Thank you for help, Best Regards, Ed.