3

I have set up Jasper Report to be generated into XLS format.

When I click print button, it will show like this :

Printed as PDF

Then, when I choose "Excel", download pop up will appear and my .xls format will be downloaded.

Unfortunately, when I open the file, it doesn't generated precisely, there are columns that doesn't fit correctly, like this :

XLS Format in Microsoft Excel, Columns in Red box doesn't show properly

How can I generate JasperReports's report into XLS with correct format and got all my data shown correctly?

Sajeev
  • 783
  • 3
  • 14
  • 46
Jedi Codestar
  • 189
  • 2
  • 14
  • `How can I generate JasperReports's report into XLS with correct format and got all my data shown correctly?` - Your question is too broad. You should fix the report's design – Alex K Jun 21 '16 at 09:40
  • The problem is nominal under Pendapatan column can't be generated into XLS format.. – Jedi Codestar Jun 21 '16 at 09:46

2 Answers2

2

I have experienced the same issue while creating Jasper Reports and exporting to Excel. The main reason for this is the column overlapping while creating report. If you take a closer look you will notice that any column of Jasper Report which gets overlapped turns into green from blue. If you completely remove overlapping in columns, then Excel format will come out without any issues.

P.S ..Coming from Personal Experience!!!

JavaDragon
  • 431
  • 1
  • 6
  • 17
0

This just happened to me.

How I solved it was selecting every field in the Jasper Report and setting the following properties:

isStretchWithOverflow="true"

isRemoveLineWhenBlank="true"

Hope it works

Ricardo J. Chamorro
  • 126
  • 3