mortoza

Hi Midrag Can you tel me how do I do this using iReport? I am not habituated in using the codes! Thanks in advance for the help. Mortoza

Hi Tlavalle I am using mySQL database. Can you help me? Regards, Mortoza

Hi booyeeka Can you send me the tips? The link doesn't work. Thanks in advance. Mortoza

Hi booyeeka Can you send me the tips? The link doesn't work. Thanks in advance. Mortoza

Hello I want my company logo to be retrieved from databse (BLOB) and displayed in the report. When I want to display, I do not see any datatype like Blob or Object. As a result getting error message telling Blob datatype can not be mapped with .... Can anyone help guiding me to the right direction in order to get the image from database and show in the jasperreport using iReport? Regards, Mortoza Post edited by: mortoza, at: 2006/10/28 11:00

Hello Lucianc The original file was big, I have cut page 1 and made a new file for you. Awaiting your support. Rgds, Mortoza [file name=salesReport2.pdf size=54092]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/salesReport2.pdf[/file]

Hi Teodor Thanks. I have already resolved this issue. Now I have some other issues in crosstab report. I have posted this in iReprot section. Thanks for the help. Mortoza

Hello You can use parameter in SQL as $P{paramName} For more details, please have a look at sample .jrxml files in the website. Rgds,

I am attaching the .pdf report file. Rgds, mortoza

Hello 1) I want additional columns which would be not part of row groups. For example, to work around, I have included the customer name joining with customer ID. In this case the disadvantage is the customer ID is not always having fixed width. 2) Can I put '0' value to those rows where there is no value for some columns? This will allow me to get the 'Total Column' aligned. Regards, Mortoza [file name=OeSalesReportCustSpScCrossTab-a92f007a6ef20d64b2ea06a2278ee3ea.jrxml size=19384]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeSalesReportCustSpScCrossTab-a92f007a6ef20d64b2ea06a2278ee3ea.jrxml[/file]

Hello 1) I have fixed the null value by now.. but My point is how can I get additional columns without putting them in row-group. for example I have added customer name with customer ID under sales person group. While the customer ID is of fixed width for all customers, the report will look OK but when any one ID will have different number of character width then the customer name column will be displayed at a different position. My question is how can I get dynamic columns, rows (crosstab) in combination with simple row/columns? 2) How do I put '0' in missing columns for those rows where there is no value and put the total Column aligned right. I attach herewith my .jrxml and .pdf files. Best regards, Mortoza

Hello 1) I have fixed the null value by now.. but My point is how can I get additional columns without putting them in row-group. for example I have added customer name with customer ID under sales person group. While the customer ID is of fixed width for all customers, the report will look OK but when any one ID will have different number of character width then the customer name column will be displayed at a different position. My question is how can I get dynamic columns, rows (crosstab) in combination with simple row/columns? 2) How do I put '0' in missing columns for those rows where there is no value and put the total Column aligned right. I attach herewith my .jrxml and .pdf files. Best regards, Mortoza [file name=OeSalesReportCustSpScCrossTab.jrxml size=19384]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeSalesReportCustSpScCrossTab.jrxml[/file]

Dear Lucian Thank you for your attention. I have prepared another report by now not resetting at group level but at report level. I have placed the crosstab component in detail band. It is working fine. Now I have another requirement. I want to add additional column with row groups e.g. customer name, address etc. I am getting null value in the report. Hope you will help. Regards, Mortoza Post edited by: mortoza, at: 2006/10/17 20:21

Hello I have reset the dataset at group level (here it is prodId) and could run the report BUT, I do not get the colums dynamically created and total per record (rows) is unexpectedly appeared. Can anyone help? I attache herewith the updated .jrxml report and output in .pdf for your reference. Thanks in advance for the help. Rgds, Mortoza [file name=crosstabReport.pdf size=82359]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/crosstabReport.pdf[/file]

Hello, I have prepared a crosstab report. I can successfully compile the report in iReport but while I try to run the report, it is giving following exceptions. Can someone help me? I am also attaching my .jrxml report- Compiling to file... D:inteaccreportsOeProductSalesPerSalesCentre.jasper -> C:iReport-1.2.6OeProductSalesPerSalesCentre.java it.businesslogic.ireport.ReportClassLoader@10d6ca2 Compilation running time : 344 Filling report... Locale: English (United States) Time zone: default Error filling print... net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:646) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) ... 12 more Print not filled. Try to use an EmptyDataSource...! Look forward for help. Best regards, Mortoza [file name=OeProductSalesPerSalesCentre-a57f73abd4c3e6d85638dee7a50e942b.jrxml size=14927]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeProductSalesPerSalesCentre-a57f73abd4c3e6d85638dee7a50e942b.jrxml[/file]

Hello, I have prepared a crosstab report. I can successfully compile the report in iReport but while I try to run the report, it is giving following exceptions. Can someone help me? I am attaching my .jrxml report and error report- Compiling to file... D:inteaccreportsOeProductSalesPerSalesCentre.jasper -> C:iReport-1.2.6OeProductSalesPerSalesCentre.java it.businesslogic.ireport.ReportClassLoader@10d6ca2 Compilation running time : 344 ÂFilling report... ÂLocale: English (United States) ÂTime zone: default ErrorÂfillingÂprint... net.sf.jasperreports.engine.JRException:ÂCrosstabÂdataÂhasÂalreadyÂbeenÂprocessed. ÂÂÂÂatÂnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) ÂÂÂÂ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:752) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) NESTEDÂBYÂ: net.sf.jasperreports.engine.JRException:ÂCrosstabÂdataÂhasÂalreadyÂbeenÂprocessed. ÂÂÂÂatÂnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) ÂÂÂÂ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:752) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) NESTEDÂBYÂ: net.sf.jasperreports.engine.JRRuntimeException:ÂErrorÂincrementingÂcrosstabÂdataset ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:646) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) ÂÂÂÂ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:752) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) CausedÂby:Ânet.sf.jasperreports.engine.JRException:ÂCrosstabÂdataÂhasÂalreadyÂbeenÂprocessed. ÂÂÂÂatÂnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂ...Â12Âmore PrintÂnotÂfilled.ÂTryÂtoÂuseÂanÂEmptyDataSource...! Look forward for helo. Best regards, Mortoza [file name=OeProductSalesPerSalesCentre.jrxml size=14927]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeProductSalesPerSalesCentre.jrxml[/file]