sushilsb

Hi All, I am generating the Jasper Excel report using APIs. My report gets created correctly. However, for a column which has space seperated values (e.g. address field - 125 Blue Road), it adds extra column and merge with it. During the design of field, I have done - fields[index].setStretchWithOverflow(true); fields[index].setStretchType(JRDesignTextField.STRETCH_TYPE_RELATIVE_TO_TALLEST_OBJECT); fields[index].setPositionType(JRDesignTextField.POSITION_TYPE_FLOAT); and while exporting set exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, new Boolean(true)); But still adds a new EXCEL column (say J - gets exetnded to K) and shows value below these two columns. I want it should be in the column J only and should not merge with column K Regards,

Hi All, I am dynamically generating a report (using API). My report is reading data from Oracle SQL there are thousands of records getting returned.I am able to generate the report but I am facing few issues - 1. Everytime I need to set the page height. Since I do not know how many records are going to get returned, I really can not calculate the size of the page. Is there any way I can set any paramter so that I do not require to calculate the size. 2. Between my column header and Column data, one row gets inserted which is of very large size and hence my records does not get start jsut below the column header. 3. Between each record, one row gets inserted, whcih further increases the space between two rows. Please let me know your valuable suggestions / answers.