anilkumarpoddar

Dear Bana.. As per my understanding, you have a field where there is some data on database and another consist of null value. and you want to print '0' in place of null .....if i m on right path then solution is here...............! you already had a field associated with database field....now you drawn on static label exactly above the field where you want to print '0' in case value is null then make it hide by uncheck on opaque so that it should not display normally.....!....now use print when expression properties of jasper on that field and put condition like new Boolean(field name(having value from database =="" or having value from database==null) and on acutal field use print on expression with condition new Boolean(field name having value from database!=null) Hope this will work!......

Dear Concern Explain with example in which matrix format you want and you can use Cross tab for matrix fulfillment..... Thanks

Dear Adi First :- G:\Clients\Dev\ireports\DetailReport_SizeBreak_4_16.jasper Path of which system(deployment machine) Second:- Where you have the jasper/jrxml extention file at the time of creating the subreport identify that machine. Third: - Uou are running on different machine. If above these are the three condition then :- you must have a jasper xml tag called <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["put the path of your main report where it is along with subreport(eg c:\\d & s\\reports\\)"]]></defaultValueExpression> </parameter> Compiled every report including subreport. Hope this will resolve your issue if not then clearify your issue.

Hurray Issue Resolved To do this:- 1. Attache the required database field 2.Draw a label of same size and put on bove required database field and click on opaque so that this field should not be display normally. 3.Use print on expression on required database field-new Boolean(required field name!=null) 4.Use print on expression on label-new Boolean(required field name==null) **************************************************************************************** please find the attach report for all your kind reference.

Issue Resolved! How to implement Serial Number( User Defned):- 1.Defind on variable 2. Variable expression type: java.lang.Interger 3.Calculation: Count 4. Reset Type: Report 5. Increment Type: None 6.Variable Expression: Boolean.TRUE. Serial number will be implemented on your jasper report. ******************************************************************************************* Please find the attached for all your kind reference

No David ....Please check the attached report ...not the previous one or other.....check on current on....

Want to do it on Report label not on SQL Label

Thanks David for your kindly reply............. But i dont want to do it with Query or on SQL Part ....i want to do it on report end.......... i have some hint with me but the same is not working..........! i have declare one label ....with opaque propertied disable and on Text Field Shipping Region ...i had applied print when expression with condition as below new Boolean(field name(shipping region).trim().equals("NULL") But Sorry to say same is not working.... Please do help if anyone is having the appropiate answer...............

Dear All Concern I Want to display the value of a variable only if another variable is having null value in database. I m having a field call Shiping Region and some of its value is null as report is showing. Now i want - if the value of shipping Region is null that field should display user text in my case Anil Kumar Poddar. Please find the attached report for your reference.

Dear All, I have declared on Variable call Serial Number to count the number of total record in one report , put calculation type - count but when i run the report i m not getting the desired result. Please find the detail below Variable name:- Serial Number Variable class:- Java.lang.Integer/java.math.BigDecimal/java.lang.String(Try using all these option) Calculation:- Count Reset Type:- Report Increment type:- Null Note :- i dont want to use Built in Varible for same. Please find the attached report for your kind reference. Post Edited by anilkumarpoddar at 06/16/2011 10:44