hello, There is an option for this in export options in that go to the excel export there u can find isOnePagePerSheet set this to true u can get the next page i.e in next sheet
Hello According to my knoweledge dynamic formatting is not directly provided you can do this using "Print when Expression". you should create 2 boxes A & B box A color red and box B yellow color now in box A print when expression use expression like new Boolean ($F{severity} == 1?true:false) and in box B print when expression use expression like new Boolean ($F{severity} == 2?true:false) this will help U.
Hello, U can try this out also First u set $V{REJECT_1} as new Integer(0) in initial expression Then put this expression in variable expression $V{REJECT_1} .intValue() + ( $F{REJECT}.intValue() == 3? 1:0) Try this out it will work.