sateesh139

Hi EveryOne, I have a requirement in the PDF report like It is a purchase order report it contains many Purchase for each purchase a unique number will be there in this we need to display the Digital signature (Image) file for each Purchases. Is there any option in the iReport/Jasper to display the images dynamically depending on the PO number. I have attached the XML file go through it. Thanks, Sateesh

Hi EveryBody, Is there any option in the iReport/Jasper to place some fields in a fixed position in a PDF report. Thanks, Sateesh

Dear Teodor Danciu I am using the ireport tool to design excel report, Here i have used Group option in the excel when i give the this group an isStartOnNewpage Option to true but still this group is not starting on a new page. However i used insert page break option too in the Group Footer header still page break is not working in the excel report. Can u suggest me Page break is possible in Excel report ? if Yes how it can be done. Thanks, Sateesh Swamy

Dear Giulio Toffoli I am using the ireport tool to design excel report, Here i have used Group option in the excel when i give the this group an isStartOnNewpage Option to true but still this group is not starting on a new page. However i used insert page break option too in the Group Footer header still page break is not working in the excel report. Can u suggest me Page break is possible in Excel report ? if Yes how it can be done. Thanks, Sateesh Swamy

Hi All, How can we insert a page break in the Excel report i have tried giving the page break in the Group Footer but its not inserting. Can anybody help me out this problem. Thanks, Sateesh

Hi All, How can we insert a page break in the Excel report i have tried giving the page break in the Group Footer but its not inserting. Can anybody help me out this problem. Thanks, Sateesh

Hi EveryOne, I need an xpath for the XML file attached, accutaly i need to design the report like attached excel sample. can anyone guide me how can i write the xpath for the attached xml file. Thanks, Sateesh Swamy

Hi EveryOne, I am using the XML file(attached) as a datasource, i creatred the master report by giving the below xpath" /______GLEDIT/______JOURNAL_ENTRY_EDIT/BATCH/JOURNAL_ENTRY " to loop the Jornal entry but again i have FUND_TOTALS as a loop so i created the subreport using by giving the xpath as below/______GLEDIT/______JOURNAL_ENTRY_EDIT/BATCH/FUND_TOTALS so when generating the subreport in the master report i have the exsiting .jasper file (subreport) and datasouce experssion as below ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/BATCH/FUND_TOTALS") but when i run the master report i am not able to get the subreport data. So where i am doing the mistake, can anybody tell me whether the subreport xpath is correct or not ? I have attached the XML file and the JRXML file for master report and subreport. Thanks, Sateesh

Hi EveryOne, I am using the XML file(attached) as a datasource, i creatred the master report by giving the below xpath" /______GLEDIT/______JOURNAL_ENTRY_EDIT/BATCH/JOURNAL_ENTRY " to loop the Jornal entry but again i have FUND_TOTALS as a loop so i created the subreport using by giving the xpath as below/______GLEDIT/______JOURNAL_ENTRY_EDIT/BATCH/FUND_TOTALS so when generating the subreport in the master report i have the exsiting .jasper file (subreport) and datasouce experssion as below ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/BATCH/FUND_TOTALS") but when i run the master report i am not able to get the subreport data. So where i am doing the mistake, can anybody tell me whether the subreport xpath is correct or not ? I have attached the XML file and the JRXML file for master report and subreport. Thanks, Sateesh

Hi EveryOne, I am converting a String of number "1,000,.00-" to Double but i am getting the below eception Locale: English (United States) Time zone: Default Error filling print... Error evaluating expression : Source text : new Double(Double.parseDouble($F{F5-DEBAMT})) net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new Double(Double.parseDouble($F{F5-DEBAMT})) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:197) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:537) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:505) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:826) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:368) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:353) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1380) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1053) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NumberFormatException: For input string: "-1,000.00" at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.parseDouble(Unknown Source) at GLEDIT_4XLS_1231231741468_315176.evaluate(GLEDIT_4XLS_1231231741468_315176:324) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:186) ... 17 more Print was not filled. Try using an EmptyDataSource.. Can any body help whats the mistake.................... Thanks, Sateesh Swamy

C-Box i have done it through trail and error it works thanks I want know whats the use of scriplet and one example....... can u provide that.... Thanks, Sateesh

C-Box its not working.......... Thanks, Sateesh

Hi EveryOne, Can we display the group header and footer dynamically depending on the conditoin (Page hieght). Thanks, Sateesh

Hi EveryOne i have a requirement like below description and i have attached the PDF generated but client needs like below For an account, the “header” or “footer” section of that account should not be split between 2 pages. For example, account 001.00000.0001 has its footer section cut between page 2 and 3. I don’t know if these rules can be added but ideally the rules would be as follows: 1)if there are no detail lines, account should be all on 1 page, not split between 2 pages (account 010.00000.3010 for example is incorrectly split). 2)if there are detail lines, at least the first detail line should be on the same page as the header for account, meaning go to the next page if there is not enough space to write both the header and the 1st detail line (account 001.00000.3001 for example is incorrectly split). 3)whether or not there are detail lines, account footer should not be split so if footer cannot be all written on current page, write it on the next page. Is it possible or not plz help me on this. Thanks, Sateesh

Thx C-Box i have a requirement like below description and i have attached the PDF generated but client needs like below For an account, the “header†or “footer†section of that account should not be split between 2 pages. For example, account 001.00000.0001 has its footer section cut between page 2 and 3. I don’t know if these rules can be added but ideally the rules would be as follows: 1)if there are no detail lines, account should be all on 1 page, not split between 2 pages (account 010.00000.3010 for example is incorrectly split). 2)if there are detail lines, at least the first detail line should be on the same page as the header for account, meaning go to the next page if there is not enough space to write both the header and the 1st detail line (account 001.00000.3001 for example is incorrectly split). 3)whether or not there are detail lines, account footer should not be split so if footer cannot be all written on current page, write it on the next page. Is it possible or not plz help me on this. Thanks, Sateesh

HI EveryOne , Is there any way we can find out the total number of pages in the report using the jasper report. Thanks, Sateesh

Hi EveryOne, Any body have an idea how to find out the last page of the report. Thanks, Sateesh.

C-Box, any idea how to find out the lastpage in the report.......... Thanks, Sateesh

Thanx i have did it but i am getting column header in that how to hide that one..... Thanks, Sateesh

Thanks by the way i know how to create the group but i don't know how to create a dummygroup can u help me on this........... Thanks, Sateesh

Hi EveryOne, I have disigned a template where i have selected the Summary on a new page in the Report properties, so in the PDF summary is coming on the new page but header & footer are not displayed. can anybody suggest why is it so. Thanks, Sateesh

Hi EveryOne, I have disigned a template where i have selected the Summary on a new page in the Report properties, so in the PDF summary is coming on the new page but header & footer are not displayed. can anybody suggest why is it so. Thanks, Sateesh

Hi EveryOne, I have to display a text field in the Title band depending on the data displayed in the detail band i have used the subreport in the detail band. Thanks, Sateesh

Hi EveryOne, I am newbe to the iReport can anybody let me know how to use the scriplet. Thanks, Sateesh

Hi teodord, I want place an image in the report that should be dynamic means when the report runs user is going to be give the path of an image, its possible in ireport tool. PS guide on this we have a client requirement. Thanks, Sateesh