[Hide a column in jasper Report But should adjust with next column]

 

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

 

 

[Hide a column in jasper Report But should adjust with next column]

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

[Hide a column in jasper Report But should adjust with next column]

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

 

 

[Hide a column in jasper Report But should adjust with next column]

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

 

[Help on one jasper report please]

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

 

 

 

 

 

[What should I do if I want to use different language text in Jasper]

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

 

[What should I do if I want to use different language text in Jasper]

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

[IReport 4.0.2 Jasper Problem]

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.

[IReport 4.0.2 Jasper Problem]

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 ?

[IReport 4.0.2 Jasper Problem]

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

[Can I get a help please on specifying the date format field in jasper ?]

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

[Jasper 4.0.2 shows no doc pages]

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.ContactNo

FROM

Supplier, Purchase, PurchaseLine, Product

WHERE

Supplier.SupplierNo = Purchase.SupplierNo

AND Purchase.PurchaseNo = PurchaseLine.PurchaseNo

AND Product.ProductCode = PurchaseLine.ProductCode

ORDER BY  product.NAME, supplier.supplierNo

[my iReport not getting started even if I re-install. Any help please ?]

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.

[my iReport not getting started even if I re-install. Any help please ?]

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 ?

[my iReport not getting started even if I re-install. Any help please ?]

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

 

 

 

[my iReport not getting started even if I re-install. Any help please ?]

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.

[my iReport not getting started even if I re-install. Any help please ?]

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.

[my iReport not getting started even if I re-install. Any help please ?]

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

 

[How to specify the default decimals in Jasper?]

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

[Can I get a help please on specifying the date format field in jasper ?]

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

[Can I get a help please on specifying the date format field in jasper ?]

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

 

 

 

[Jasper and PlSQL]

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

 

 

 

 

 

[Not able to post my question]

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

 

 

 

 

 

[Jasper Report Issue when Running Report From Java]

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

 

 

 

[Jasper Report Issue when Running Report From Java]

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.