I have created a jasper template file for generating excel report. I want to query some data from DB and dispay it in my generated excel file. I can able to generate the file but the problem is there is somuch of blank spaced in the page. I am generating the report for department wise. so, if only one member is present in the department, I need the full page for that department and the remaining details will load to the next page. These all are working.
Attached a screenshot of the file.
From the image, you can see that the report starting from the position A and ends up in cell position CS.
It is not loaded in continuous cells. I can see that so many blank cells in the generated file. How can I create the excle by loading the values in continuous cell.
Hi Joby ,
This is happening because, the excel export takes the white space in the report as a column, as you say that there is an requirement of Header also, that will contain columns which correspond to whitespaces.
It is adviced, that the reports exported in Excel should rather shred the header, and the text feilds placed in the detail section or anywhere for that matter should be continuous in nature
Hope that this helps