Hi , am using jasper 3.60 version I want to create an xl with two sheets ,each sheet different query . So I have created two different subreport in jasper for each one I have chosen the property IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS ,IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMS and also given ignore pagination for both the xl and finaly created main report and I separted both the supreport by giving page break and selected the property ONE_PAGE_PER_SHEET and also added the above mentioned two properties but what now am facing is when the xl reaches maximum ( i.e more than 100) rows in one sheet it will split into multiple sheets and also the sheets got collapsed , if it has minimum no if rows means working correctly ,can anybody der to guide me.??? Thanks in advance..
