shummel

Hi, we also had the need to hide some exporters for specific reports and did it in the following way (CE - Jasperserver 3.5.0). 1) Inside the path "........./jasperserver/WEB-INF/jsp" we copied the file "DefaultJasperViewer.jsp" to for example "PdfXlsJasperViewer.jsp". 2) Edited the new file "PdfXlsJasperViewer.jsp" and changed line 87 - 104 to: <c:if test="${!emptyReport}"> <input type="hidden" name="output"/> <td width="1" valign="top"><a href="javascript:exportReport('pdf'<c:if test="${not empty exportFilename}">, '<c:url value="flow.html/flowFile/${exportFilename}"/>'</c:if>)" title="<spring:message code='jasper.report.view.hint.export.pdf'/>"><img src="${pageContext.request.contextPath}/images/pdf.gif" border="0" alt="<spring:message code='jasper.report.view.hint.export.pdf'/>"/></a></td> <td width="1"> </td> <td width="1" valign="top"><a href="javascript:exportReport('xls'<c:if test="${not empty exportFilename}">, '<c:url value="flow.html/flowFile/${exportFilename}"/>'</c:if>)" title="<spring:message code='jasper.report.view.hint.export.xls'/>"><img src="${pageContext.request.contextPath}/images/xls.gif" border="0" alt="<spring:message code='jasper.report.view.hint.export.xls'/>"/></a></td> <td width="1"> </td> </c:if> 3) After we changed the report resource "CUSTOMIZATION" to the new file "PdfXlsJasperViewer.jsp". "JSP location: PdfXlsJasperViewer.jsp" In this case the defaults are kept for all reports except the ones where you change to customization. Of course we have created some different combinations of exporterfiles to meet our needs. Sven Post Edited by shummel at 08/04/2009 13:01

Hi, the latest Version of JasperServer CE 3.5.0. So far i figured out that if i delete the "destroy-method" of the bean "quartzScheduler" from "applicationContext-report-scheduling.xml" it is working. But i think this is maybe the wrong way and i do not have any idear what will happen in the long run. rgds, Sven

Hallo, we have some trouble with the scheduler. A sheduled job who shall send the report by eMail after certain time is executed well as long the user is logged in. After logout the report is only stored in the repository but not emailed. Any suggestion what is the problem ?

Hi, i don´t find the possibilities to set page settings which are respected during creation of excel reports. I need to set the margins of the excel worksheet / spreadsheet for Printing. A highlight would also be if it is possible to set the scale for the printing and to zoom the view. So far i searched and found out it can not set it up using the gui. Is there another way like: <property name="..........????......." /> to do this ?? Please try to help in those matters. regards Sven Post Edited by Sven Hummel at 03/11/09 14:13

Hi Sanda, i found the solution myself new Integer($V{REPORT_COUNT}.intValue()+1) For example: <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA[$F{ART3_A3VK}.compareTo(new BigDecimal(0.00))==0 ? null :"SUM(I" + new Integer($V{REPORT_COUNT}.intValue()+1) + "-K" + new Integer($V{REPORT_COUNT}.intValue()+1) + ")"]]> Will give me the formula =SUMME(I2-K2) for the second row. =SUMME(I3-K3) for the third row, aso. thanks again for your help Sven

Hi Sanda, many thanks for your quick reply. I have tried your examples and they will work if i change the char ";" into "+" like: <property name="net.sf.jasperreports.export.xls.formula" value="SUM(I3+1.00)" /> I have also tried a more complex one with success like: <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["SUM((I" + $V{REPORT_COUNT} + "+1.00/100)/100)"]]></propertyExpression> I think i now understand the syntax and hope any body else will find those examples helpfull as well. May i can ask you one more detail about the build in variable REPORT_COUNT ? For most of my formula i need to know the row number of the actual row. In my above example the row number is always one number less. The header band isn`t counted and i don´t know why or how to overcome that. To avoit missunderstanding: ROW 1 = Header ROW 2 = Header (REPORT_COUNT VALUE = 1) ROW 3 = Header (REPORT_COUNT VALUE = 2) Any idear on that or alternative ? Thanks a lot, Sven

Hi, i'am getting into trouble using dynamic excel formula in iReport 3.1.4. Working fine for static formula: <property name="net.sf.jasperreports.export.xls.formula" value="SUM(I3+1,00)" /> within the <reportElement> Not getting to work in any way for dynamic formula: <property name="net.sf.jasperreports.export.xls.formula" value="SUM(I+$V{REPORT_COUNT})" /> or <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA[("I" +$V{REPORT_COUNT}]])"> </propertyExpression> and so on. Could anyone help me out if i made a code misstake or is this function not yet implemented into v.3.1.4 ?? Many thanks in advance Sven