![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
mortoza
-
Posts
41 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by 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]
Showing image from database
in Products
Posted
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