sureshtatikonda1982

Hi, I attached the report which i generated with this mail. Problem is "Excel cells or not getting displayed and the report block sizes and cell sizes r not matching. Please some one help me how to solve this...... Do we need to create the Jrxml in a different way for Excel type of reports if that is the case please give me the example of JRXML which can produce proper formated Excel report. [file name=DatasetDemoReport.xls size=15360]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/DatasetDemoReport.xls[/file]

Hi, When i am executing the same JRXML file with pdf its working fine when i am trying to execute with Excel exporter its giving the following exception... Can any one help me where the mistake i did ... How to solve this.... Error exporting print... java.lang.IllegalArgumentException: Sheet name cannot be blank, greater than 31 chars, or contain any of /*?[] at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRecord.java:211) at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:473) at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:467) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:413) at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExporter.java:144) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:354) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:199) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1081) at java.lang.Thread.run(Unknown Source)

Hi, I need to create Subdatasets in JRXML but i want to pass the quries from java code. So if a report have 3 SubDataSets it requires three quries to be passed. Is there any way to send all these quries & in which dataset it needs to use through java. Please help me ...... Thanks & Regards, Suresh Tatikonda.

Hi, I am getting Null "Key" Exception in charts due to the qurery which i am executing to populate the chart is giving the result as empty. So thats why i am getting the Key Expression value as null. Is there any way to handle this situations. The following error message it shows: java.lang.IllegalArgumentException: Null 'key' argument. at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:225) at org.jfree.data.general.DefaultPieDataset.setValue(DefaultPieDataset.java:187) at net.sf.jasperreports.charts.fill.JRFillPieDataset.customIncrement(JRFillPieDataset.java:158) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRFillChartDataset.getDataset(JRFillChartDataset.java:57) at net.sf.jasperreports.engine.fill.JRFillChart.evaluatePieImage(JRFillChart.java:1525) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:712) at net.sf.jasperreports.engine.fill.JRFillChart.resolveElement(JRFillChart.java:2253) at net.sf.jasperreports.engine.fill.JRFillElement.resolveElement(JRFillElement.java:874) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1072) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1097) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveReportBoundElements(JRBaseFiller.java:1107) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:821) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:164) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:732) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:641) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:755) at java.lang.Thread.run(Unknown Source) Print not filled. Try to use an EmptyDataSource...! Please help me .......... Thanks & Regards, Suresh Tatikonda.

Hi, I tried to create the chart with the subdatasets query is having "groupby" clause in the query. It's giving following exception in the run time: Error filling print... java.lang.IllegalArgumentException: Null 'key' argument. at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:225) at org.jfree.data.general.DefaultPieDataset.setValue(DefaultPieDataset.java:187) at net.sf.jasperreports.charts.fill.JRFillPieDataset.customIncrement(JRFillPieDataset.java:158) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRFillChartDataset.getDataset(JRFillChartDataset.java:57) at net.sf.jasperreports.engine.fill.JRFillChart.evaluatePieImage(JRFillChart.java:1525) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:712) at net.sf.jasperreports.engine.fill.JRFillChart.resolveElement(JRFillChart.java:2253) at net.sf.jasperreports.engine.fill.JRFillElement.resolveElement(JRFillElement.java:874) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1072) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1097) at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveReportBoundElements(JRBaseFiller.java:1107) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:821) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:259) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:135) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:732) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:641) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:755) at java.lang.Thread.run(Unknown Source) Print not filled. Try to use an EmptyDataSource...! If i specify some report group as increment group then its saying that unknown group error in the compilation time. Please help me.... Thanks & Regards, Suresh Tatikonda.

Hi, I am trying to prepare a chart from a table where it contains so many rows. If i print the legend while making the report, i am unable to see the chart even. So i decided to prepare the chart if some attribute value is more than x threshold. Can any one help me how to specify these thresholds while defining the charts, i can do this by specifying the mysql query itself but i need to print all the data in the report but above threshold values in the charts. And Can any one tell me, How to specify Chart can be in single page but legend comes in next page or even more than one page. I attached the report where i can't able to see even what this report says, if i print the legend i am unable to see the chart. Post edited by: sureshtatikonda1982, at: 2007/02/12 06:19 [file name=crody_report.gif size=61121]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/crody_report.gif[/file] Post edited by: sureshtatikonda1982, at: 2007/02/12 06:20