ajith.devendra

Thanks Hozawa, Managed to resolve it using ComareTo method as you mentioned . Appreciated your support rgds Ajith

Hi Dear I am using below expression just to check whether the variable is greater than 5000 then to initialize to Zero IF($V{DUTYPageTotal}>=5000 , 0 )[/code]but its giving me an error “The operator >= is undefined for the argument types BigDecimal,int . Class of the $V{DUTYPageTotal} is java.math.BigDecimal Pls help me the fix this error Ajith

Hi Reportdev, I managed to get it work using the same method which you said , but the issue is , it will jump to the next page but it will print only the details band in the next page, other bands in the first page are not getting printed in the next page . rgds Ajith

Dear Reportdev, Almost a week i struggled with this , finally found a field in the database table called sequence number (seqno), it strts with 1 ....n . I used this field and created a variable in jasper called "10Lines" in that i added an expression $F{seqno}<2 ? "1" : "2" Created a group using variable "10Lines" and checked on Start New Page in group band properties .. I can see the values of "10Lines" correctly prints ,but still it is not jumping to the next page . Appreciate your advice on this Rgds A

Dear Andy, Thanks for your advice .. I managed to get it worked with below expression $F{TRANSPORTMODE}.equals("8")?" FreeZone":$F{TRANSPORTMODE}.equals("7")?"CARGO TERMINAL":"" and copied the expression in to the "initial value expression" as well . rgds Ajith

Hi Dear, I need to jump to the next page after 10 lines in detail band , I have added below expression on the break element which was dragged from the basic element Pallete . But still it dosn't break the page to next page . $V{REPORT_COUNT} =='10' rgds A

Dear Team, i have a below simple if statement in expression , but it returns null .. Would you pls help me to resolve this . IF($F{TRANSPORTMODE} == "8","FreeZone",IF(($F{TRANSPORTMODE} == "7"),"CARGO TERMINAL","")) rgds A

Hi Dear, I'm in the process of moving Crystal reports to Jasper soft Studio .I have below formular in one of my crystal reports . What it does . Read a string having "|" marks and split the string to sperate strings after the "|" mark . And a carriage return after the "|" - (CHAR(13)) Input string is like XXX|YYYY|AAA|BBBB output XXX YYYY AAA BBBB would anyone can help me to convert below formula to Jasper expression . local stringvar array arr:=Split({Command.LineHsCodes},'|'); local stringvar result:=""; local numbervar start; if Int(count(arr)) > 0 then ( for start:=1 to Int(count(arr)) Do ( result:=result + arr[start] + CHR(13); ); ); result; rgds Ajith

Thanks Hozawa, Reduced Band heights and split the fields across the other bands as you advised . It worked .. Really appreciated you help on this Rgds Ajith

Hi Dear There is a gap between Title and page header band .. I’m not able to reduce it . In the design they are close to each other(Stretch to content) , but in preview it get a huge space between two bands . Same issue between page header and page footer .. fyi .. I’m not using column header ,Detail and column footer bands in this report ..all of them are deleted from the report . I would appreciate if anyone can help me on this rgds Ajith

Thanks Joseng , i will try the second option and let you know the outcome Rgds Ajith

I have two variables TotalPcs ROW_COUNT I want to initialize ROW_COUNT to zero if the variable $V{TotalPcs}>100 Variable ROW_COUNT is defined as below and It’s having an expression , but expression doesn’t initialize the ROW_COUNT .. It continues increasing by one . Would you pls helpw me on this Name = ROW_COUNT Calculation = No Calculation function Expression = (($V{TotalPcs})>100) ? 0 :(new Integer($V{ROW_COUNT}.intValue() + 1)) Increment Type = None Reset type = Report Rgds Ajith

Dear Hozawa, I just need to hide the TotalPieces Variable while printing .. Would appreciate your advice .. In Crystal Reports we have supress checkBox .. Do we have similar way to hide the variable rgds Ajith

Thanks Hozawa, Thanks for your quick response .It worked perfectly . Best Regards Ajith

Dear I have a sum variable with below properties Name = TotalPieces Calculation = Sum Expression =$F{LinePieces} Increment Type = None Reset type = Report I need to initialize the TotalPieces value to zero if the value of the TotalPieces are more than 100 .. Would appreciate if you can help me on this Ajith