FMumm

Dear Vzern, I am facing the same problem with my report as I am trying to put a line at the end of each streched with overflow detail... I am using a group header, detail and group footer. My problem is now to get the line at every page. I used the column footer which is almost the result i would like to have. The only issue is that it prints the line on the last page after my group footer band which is not the desired behavoir. I want it instead before it. With column footer: Code:<columnFooter> <band height="1"> <line> <reportElement positionType="Float" isPrintRepeatedValues="false" x="12" y="0" width="528" height="1" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true"/> <graphicElement/> </line> </band> </columnFooter> When I put it in a seperate group footer I get the result that the line is only printed on the last page... :unsure: With group footer: Code:[code]<groupFooter> <band height="1"> <line> <reportElement positionType="Float" isPrintRepeatedValues="false" x="12" y="0" width="528" height="1" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true"/> <graphicElement/> </line> </band> </groupFooter> ...so, what I need is like a mix of the solutions I have above. Print on each page but on last page it should not be printed after the group footer band. I am looking forward to any reply, thanks in advance! Bye, Fab

Dear satyam, please read the following: http://www.brianburridge.com/2006/06/19/highlighting-odd-even-rows-jasperreports/ I wanted to use the same thing in XLS but my rows did not get colored, so I was wondering if I might do something wrong like PROPERTY_WHITE_PAGE_BACKGROUND or something like that for Excel exporting. In the end I defined a new style with the condition expression Boolean.valueOf( $V{PAGE_COUNT}.intValue() % 2 == 0 ) on it without using a rectangle and a print when expression on it! Hope this helps! Bye, WeAzLe

Dear subrahmanyam, please read the following: http://www.brianburridge.com/2006/06/19/highlighting-odd-even-rows-jasperreports/ I wanted to use the same thing in XLS but my rows did not get colored, so I was wondering if I might do something wrong like PROPERTY_WHITE_PAGE_BACKGROUND or something like that for Excel exporting. In the end I defined a new style with the condition expression Boolean.valueOf( $V{PAGE_COUNT}.intValue() % 2 == 0 ) on it without using a rectangle and a print when expression on it! Hope this helps! Bye, WeAzLe

Dear Chrish, thanks for your reply... sry, I guess, I have posted the wrong paramters from my parameter list... this is of course the one I am talking about: ;-) Code: <parameter name="Invoice_Date_From" class="java.util.Date"/> <parameter name="Invoice_Date_To" class="java.util.Date"/> Thanks for the hint (+1).... Anyway, I could also solve my problem using the query inside the jasperreport itself using this format: Code:[code]...BETWEEN to_date($P{S_Invoice_Date_From}, 'dd/MM/yyyy') AND to_date($P{S_Invoice_Date_To}, 'dd/MM/yyyy')... I always tried using the query from inside JasperServer to overwrite the query which was defined in my jasperreport which I was editing with JasperAssistant. As I used different queries for development (to get real data back without entering parameters) I never tried putting my final query in the jasperreport, instead only uploaded to the JasperServer and used it as resource. My issue got solved using query inside jasperreport instead from repository of JasperServer... Thanks, Fab

Dear all, I experience exactly the same issue as Ali does: Code: java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected I am using JasperServer (WAR distribution for JBoss), develope the reports in JasperAssistant with data source pointing to Oracle. I tried following the suggestions mentioned in the post before but without success. I either run into the issue mentioned above or I receive an empty report as Ali does :( My parameters look like the following: Code:[code] <parameter name="Invoice_Number_From" class="java.lang.String"/> <parameter name="Invoice_Number_To" class="java.lang.String"/> and Code:[code] <parameter name="S_Invoice_Date_From" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{Invoice_Date_From}==null?(new SimpleDateFormat("dd/MM/yyyy"«»)).format(new Date()):«»(new SimpleDateFormat("dd/MM/yyyy"«»)).format($P{Invoice_Date_From}))]]></defaultValueExpression> </parameter> <parameter name="S_Invoice_Date_To" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{Invoice_Date_To}==null?(new SimpleDateFormat("dd/MM/yyyy"«»)).format(new Date()):«»(new SimpleDateFormat("dd/MM/yyyy"«»)).format($P{Invoice_Date_To}))]]></defaultValueExpression> </parameter> I tried to use following SQLs: Code:[code] BETWEEN to_date('$P!{S_Invoice_Date_From}', 'DD/MM/YYYY') AND to_date('$P!{S_Invoice_Date_To}', 'DD/MM/YYYY') ... resulting in empty report and Code:[code] BETWEEN to_date($P{S_Invoice_Date_From}, 'DD/MM/YYYY') AND to_date($P{S_Invoice_Date_To}, 'DD/MM/YYYY') ...gives me the non-numeric character error... How can I use the two parameters $P{Invoice_Number_From} and $P{Invoice_Number_To} with date format dd/MM/yyyy ? This is what is set in my calendar.properties: Code:[code] date.format=dd/MM/yyyy datetime.format=dd/MM/yyyy HH:mm calendar.date.format=%m-%d-%Y calendar.datetime.format=%d/%m/%Y %H:%M Any help is appriciated! Thanks in advance,.... Fab

Dear all, I experience exactly the same issue as Ali does: Code: java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected I am using JasperServer (WAR distribution for JBoss), develope the reports in JasperAssistant with data source pointing to Oracle. I tried following the suggestions mentioned in the post before but without success. I either run into the issue mentioned above or I receive an empty report as Ali does :( My parameters look like the following: Code:[code] <parameter name="Invoice_Number_From" class="java.lang.String"/> <parameter name="Invoice_Number_To" class="java.lang.String"/> and Code:[code] <parameter name="S_Invoice_Date_From" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{Invoice_Date_From}==null?(new SimpleDateFormat("dd/MM/yyyy"«»)).format(new Date()):«»(new SimpleDateFormat("dd/MM/yyyy"«»)).format($P{Invoice_Date_From}))]]></defaultValueExpression> </parameter> <parameter name="S_Invoice_Date_To" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{Invoice_Date_To}==null?(new SimpleDateFormat("dd/MM/yyyy"«»)).format(new Date()):«»(new SimpleDateFormat("dd/MM/yyyy"«»)).format($P{Invoice_Date_To}))]]></defaultValueExpression> </parameter> I tried to use following SQLs: Code:[code] BETWEEN to_date('$P!{S_Invoice_Date_From}', 'DD/MM/YYYY') AND to_date('$P!{S_Invoice_Date_To}', 'DD/MM/YYYY') ... resulting in empty report and Code:[code] BETWEEN to_date($P{S_Invoice_Date_From}, 'DD/MM/YYYY') AND to_date($P{S_Invoice_Date_To}, 'DD/MM/YYYY') ...gives me the non-numeric character error... How can I use the two parameters $P{Invoice_Number_From} and $P{Invoice_Number_To} with date format dd/MM/yyyy ? This is what is set in my calendar.properties: Code:[code] date.format=dd/MM/yyyy datetime.format=dd/MM/yyyy HH:mm calendar.date.format=%m-%d-%Y calendar.datetime.format=%d/%m/%Y %H:%M Any help is appriciated! Thanks in advance,.... Fab