mohammed.sardar

Thanks. But in this case I have 4 sub-reports on the master report. I have the other three reports on the other details bands. Actually I have Detail 1 , Detail 2 , Detail 3 & Detail 4. If I use this report alone on the summay band will be printed first on the summay band and then the other detail bands will be printed. I'm changing now and let you know how it goes ... Thanks

Hi Andrew Thanks for your reply. Are ou asking me to use the Table Component from the Pallate on the details band.Do I have use the Print When Expression on the table component in order to acheive this ? Thanks

Hi Andrew Thanks for your reply. Are ou asking me to use the Table Component from the Pallate on the details band.Do I have use the Print When Expression on the table component in order to acheive this ? Thanks

Hi All, If I have 4 columns say COL1 COL2 COL3 COL4 I want to hide the column COL3 based on a parameter passed from Java. But It should not create a space between the columns COL2 & COL4. I'm not sure what concept shall I use for this but would be very helpful if someone could help on this please. Ofcourse I do use the PrintWhenExpression from Properties Window in order to hide the column.But the thing is we need to avoid the extra space. COL1 | COL2 | | COL4 => In this if I hide the COL3 there is a space created between 2 & 4. I should omit the space. Hope I have requested the information as much as I can. If any one have idea then please share with me. Thanks. Kind Regards Mohammed

Hi All, I have designed a jasper report where I have column header followed by details and one more sunreport in a Group Footer. So how the report works in it will print the first report data and then followed by sub report data. What I want to do is I want to hide the column headers of Report 1 when there is no data for the header report. To cut the story short the column header should be hidden if there is no data. I searched through the net but could not find a clue to make it worl. Could you please some one guide me on this Many Thanks Mohammed

The reason why I ask for thie clarification is because if I use the below in a static text field I'm getting the below error. ERROR : java.lang.Exception: org.xml.sax.SAXParseException; lineNumber: 98; columnNumber: 25; Invalid byte 2 of 2-byte UTF-8 sequence.STACK TRACE :jasperTools.jasperReportBuilder$1Runner.run(jasperReportBuilder.java:265) [Version=1.13,Date=20140224103340]util.csSQLProgressMonitor$2.run(csSQLProgressMonitor.java:285) [Version=1.4,Date=20120217154226] USER MESSAGE : Generating STORE INVENTORY LIST Jasper Report Failed

Hi All, Have a nice day. I would like to know what should I have to study if I want to use different languages in Jasper iReport 4.0.2 ? For example, DESCRIÇÃO/DESCRIPTION in a statis text field ? Do I need to install this language and where ? Could any one pls help me ? Thanks

Ok Thanks, But I resolved this issue by creating my own Style. But initially I tried changing the font but still I had wrapping issue, Now it has been resolved. Thanks for your comments.

I don't find any space here to attach a image/pdf to show the what is the exact problem ? Can I attach a PDF/Image here ?

I have customized designed of IReport which has a Title. If I generate the report from Java the title looks very fine but when I view the jasper generated report using PDF (After converting to PDF) it has some wrapping problem only at the title side of report that too happens at the last line of the tile. The text I have placed in a static text field has this issue. If any one has come across this type of issue please give me some idea. I have attached a sample PDF Report. Many Thanks Mohammed

could you please let me know a best jasper e-book or book if you wish? Currently I'm referring Packtpub.iReport.3.7.Apr.2010. Ofcourse I will also refer the Net. As you have come across many jasper concepts I'm asking you. If you like pls suggest. Thanks

Hi All, I have written below query to get the result and it's fine when I run from SQL developer but when it's inserted in to Jasper report just gettin Document has no pages. How can I trobleshoot this task. Please help. SELECT DISTINCT product.Name,supplier.SupplierNo,supplier.SupplierName,supplier.Address,supplier.ContactNoFROMSupplier, Purchase, PurchaseLine, ProductWHERESupplier.SupplierNo = Purchase.SupplierNoAND Purchase.PurchaseNo = PurchaseLine.PurchaseNoAND Product.ProductCode = PurchaseLine.ProductCodeORDER BY product.NAME, supplier.supplierNo

I just re-installed jdk1.7 and it all the magic. Now I'm happy with the Jasper. Thanks All. wish you all the very best.

I have installed both jdk 1.6.0 and jdk 1.8.0_20 and jre1.6.0 and jre7. But I assume as I have jdk1.8.0 and jre 7 it's fine ? Which of the version of jre and jdk that I need to have on my system ?

I think I'm in right log and now reading the Error log message to dignose the issue. If you have any idea then pls share. C:UsersKLR.ireport4.0.2varlog Error Logs ********** ------------------------------------------------------------------------------- >Log Session: Friday, December 26, 2014 11:05:27 AM IST >System Info: Product Version = Jaspersoft iReport Designer 4.0.2 Operating System = Windows 7 version 6.1 running on x86 Java; VM; Vendor = 1.8.0_20-ea; Java HotSpot Client VM 25.20-b05; Oracle Corporation Runtime = Java SE Runtime Environment 1.8.0_20-ea-b05 Java Home = C:Program FilesJavajdk1.8.0_20jre System Locale; Encoding = en_US (ireport); Cp1252 Home Directory = C:UsersKLR Current Directory = C:Program FilesJaspersoftiReport-4.0.2 User Directory = C:UsersKLR.ireport4.0.2 Installation = C:Program FilesJaspersoftiReport-4.0.2ireport C:Program FilesJaspersoftiReport-4.0.2ide10 C:Program FilesJaspersoftiReport-4.0.2nb6.5 C:Program FilesJaspersoftiReport-4.0.2platform9 Boot & Ext. Classpath = C:Program FilesJavajdk1.8.0_20jrelibresources.jar;C:Program FilesJavajdk1.8.0_20jrelibrt.jar;C:Program FilesJavajdk1.8.0_20jrelibsunrsasign.jar;C:Program FilesJavajdk1.8.0_20jrelibjsse.jar;C:Program FilesJavajdk1.8.0_20jrelibjce.jar;C:Program FilesJavajdk1.8.0_20jrelibcharsets.jar;C:Program FilesJavajdk1.8.0_20jrelibjfr.jar;C:Program FilesJavajdk1.8.0_20jreclasses;C:Program FilesJavajdk1.8.0_20jrelibextaccess-bridge.jar;C:Program FilesJavajdk1.8.0_20jrelibextcldrdata.jar;C:Program FilesJavajdk1.8.0_20jrelibextdnsns.jar;C:Program FilesJavajdk1.8.0_20jrelibextjaccess.jar;C:Program FilesJavajdk1.8.0_20jrelibextjfxrt.jar;C:Program FilesJavajdk1.8.0_20jrelibextlocaledata.jar;C:Program FilesJavajdk1.8.0_20jrelibextnashorn.jar;C:Program FilesJavajdk1.8.0_20jrelibextsunec.jar;C:Program FilesJavajdk1.8.0_20jrelibextsunjce_provider.jar;C:Program FilesJavajdk1.8.0_20jrelibextsunmscapi.jar;C:Program FilesJavajdk1.8.0_20jrelibextsunpkcs11.jar;C:Program FilesJavajdk1.8.0_20jrelibextzipfs.jar Application Classpath = C:Program FilesJaspersoftiReport-4.0.2platform9libboot.jar;C:Program FilesJaspersoftiReport-4.0.2platform9liborg-openide-modules.jar;C:Program FilesJaspersoftiReport-4.0.2platform9liborg-openide-util.jar;C:Program FilesJavajdk1.8.0_20libdt.jar;C:Program FilesJavajdk1.8.0_20libtools.jar Startup Classpath = C:Program FilesJaspersoftiReport-4.0.2platform9corecore.jar;C:Program FilesJaspersoftiReport-4.0.2platform9coreorg-openide-filesystems.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_de.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_es.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_fr.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_it.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_ja.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_pl.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_pt_BR.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_sq.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_zh_CN.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocalecore_zh_TW.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_de.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_es.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_fr.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_it.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_ja.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_pl.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_pt_BR.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_sq.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_zh_CN.jar;C:Program FilesJaspersoftiReport-4.0.2platform9corelocaleorg-openide-filesystems_zh_TW.jar;C:Program FilesJaspersoftiReport-4.0.2ireportcorelocalecore_ireport.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_de.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_es.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_it.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_ja.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_pt_BR.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_zh_CN.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocalecore_nb_zh_TW.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_de.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_es.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_it.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_ja.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_pt_BR.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_zh_CN.jar;C:Program FilesJaspersoftiReport-4.0.2nb6.5corelocaleorg-netbeans-upgrader_zh_TW.jar ------------------------------------------------------------------------------- java.lang.IllegalStateException: java.lang.IllegalAccessException: Class org.openide.util.WeakListenerImpl$ProxyListener can not access a member of class org.openide.filesystems.$Proxy0 with modifiers "public" at org.openide.util.WeakListenerImpl$ProxyListener.(WeakListenerImpl.java:413) at org.openide.util.WeakListenerImpl.create(WeakListenerImpl.java:154) at org.openide.util.WeakListeners.create(WeakListeners.java:268) at org.openide.filesystems.MultiFileObject.(MultiFileObject.java:116) at org.openide.filesystems.MultiFileObject.(MultiFileObject.java:133) at org.openide.filesystems.MultiFileSystem.getMultiRoot(MultiFileSystem.java:251) at org.openide.filesystems.MultiFileSystem.getRoot(MultiFileSystem.java:236) at org.netbeans.core.startup.ModuleSystem.(ModuleSystem.java:112) at org.netbeans.core.startup.Main.getModuleSystem(Main.java:155) at org.netbeans.core.startup.Main.start(Main.java:312) at org.netbeans.core.startup.TopThreadGroup.run(TopThreadGroup.java:110) at java.lang.Thread.run(Thread.java:744) Caused by: java.lang.IllegalAccessException: Class org.openide.util.WeakListenerImpl$ProxyListener can not access a member of class org.openide.filesystems.$Proxy0 with modifiers "public" at sun.reflect.Reflection.ensureMemberAccess(Reflection.java:101) at java.lang.reflect.AccessibleObject.slowCheckMemberAccess(AccessibleObject.java:295) at java.lang.reflect.AccessibleObject.checkAccess(AccessibleObject.java:287) at java.lang.reflect.Constructor.newInstance(Constructor.java:398) at org.openide.util.WeakListenerImpl$ProxyListener.(WeakListenerImpl.java:403) ... 11 more

I have tried to view the error log or somthing similar in the below paths but did not find somthing related. 1. C:Program FilesJaspersoftiReport-4.0.2ireportconfig 2. C:Program FilesJaspersoftiReport-4.0.2ireportcore 3. C:Program FilesJaspersoftiReport-4.0.2ireportdatabase 4. C:Program FilesJaspersoftiReport-4.0.2ireportlibs 5. C:Program FilesJaspersoftiReport-4.0.2ireportmodules 6. C:Program FilesJaspersoftiReport-4.0.2ireportsamples 7. C:Program FilesJaspersoftiReport-4.0.2ireporttemplates 8. C:Program FilesJaspersoftiReport-4.0.2ireportupdate_tracking Note: I have re-installed the iReport as well.

For iReport 4.0.2 where I need to look for the err logs ? I know some where Program Files. Even I tried to look at config and something. But did not get any clues why this new behaviour.

Hi All, I have installed iReport 4.0.2 successfully with any error. When try to open the application the intial screen appears and then disappers. I tried completly uninstall and then reinstalling the application but still the same . I have jdk1.6.0 on my system. Could any one please help me how to troubleshoot the issue ? Thanks, Mohammed

Hi All, I have a field in Jasper and I have defefined this as Number. I want this to hold atleast two decimal places at all the time. not less that that. For example if I pass 4760.4 from the PL/SQL It should display in the export as 4760.00 always. It it's 4760.6 from pl/sql then too it should be 4760.60 not 4760.6 I have tried pattern as custom pattern but it skipping the one decimal. Any help Please? Thanks Mohammed

Hi Rajesh, Thanks very much for your reply. I used pattern property before getting your answer though it helps me too and others as I hope. Your website w3.rajeshsirsika.com does not seem to work for me. I'm interested to approach the site for some of my jasper doubts. Thanks Mohammed

I get the date format as '2-SEP-14' when I execute my funciton in Oracle. But when it returned to Jasper it automatically appends TIME STAMP to it.! I try the below in Edie Expression fields but getting an error but not the report. How should I change the format in Jasper 4.0.2 new SimpleDateFormat("DD/MMM/YY").format($F{RECEIPT_DATE}) - Is it right ? Many thanks Mohammed

Hi All, I have done with designing a Jasper Report. Have called a PL/SQL as below .select * from TABLE(package_name.function_name(arg1,arg2). which in turn returns a TABLE of data through a TYPE funciton. AS pipeline(row), when I consult for some justification on the below pl/sql function go the response to avoid using PIPELINE function as will cause some performance issue. --trim(pmrow.part_number) is null then raise partmaster_block; end if; pipe row(pmrow); end loop; exception --when others then when partmaster_block then pmrow.part_number := null; pmrow.part_description := null; pmrow.part_type := null; pmrow.stock_group := null; pmrow.uom := null; pmrow.block_status := null; return; end; I'm advised to avoid this and us the ref_cursor to return data to Jasper. My doubt is is there any other way to fetch data for export from oracle other than the abvoe. Please help me thanks

when I try to raise my doubt as below getting the below error and now allowed to post . Any help please? Your submission has triggered the spam filter and will not be accepted.If you feel this is in error, please try rephrasing the post title and/or body. Your submission has triggered the spam filter and will not be accepted.If you feel this is in error, please try rephrasing the post title and/or body. ******************************** Hi All, I have done with designing a Jasper Report. Have called a PL/SQL as below .select * from TABLE(package_name.function_name(arg1,arg2). which in turn returns a TABLE of data through a TYPE funciton. AS pipeline(row), when I consult for some justification on the below pl/sql function go the response to avoid using PIPELINE function as will cause some performance issue. --trim(pmrow.part_number) is null then raise partmaster_block; end if; pipe row(pmrow); end loop; exception --when others then when partmaster_block then pmrow.part_number := null; pmrow.part_description := null; pmrow.part_type := null; pmrow.stock_group := null; pmrow.uom := null; pmrow.block_status := null; return; end;I'm advised to avoid this and us the ref_cursor to return data to Jasper. My doubt is is there any other way to fetch data for export from oracle other than the abvoe. Please help me thanks

Still only some users are getting this error only in the morning at first when they log in. Afterwards this error will vanish. If any experts have heard about this isse please share your ideas. many thanks

Hi I'm not sure whether I can ask my doubts as above. But I'm new to Jasper. So if anyone has any idea then please help me. Else no issues. If the idea you are giving is new then I will learn from it.