Jaspersoft Reports error - column number out of range - exceeding 63 ( Microsoft Word)

book

Article ID: 140695

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When running Jaspersoft reports in Word format, we get an error if the number of columns in the report exceeds 63.  How do we allow more than 63 columns in a report?

 

Environment

Release : All supported Jaspersoft environments with export to Word (docx format)

Resolution

According
to the Jaspersoft documentation there is a Microsoft Word limitation on the
DOCX format.



https://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v71/moving-resizing-and-hiding-columns

"Do not export
reports having more than 63 columns. In Microsoft Word, you cannot create
tables having more than 63 columns."



Here is some information from the Microsoft that could help understand more:

https://social.msdn.microsoft.com/Forums/en-US/ceaf5043-5694-4641-a7e0-cbcca7ac63ce/table-column-limit-and-how-this-is-calculated?forum=worddev

The column count includes merged.split cells etc so that could account for the differences too.



You have two options:



Use Excel for this report



Or



Reduce the columns - with readjusting of the
width size of the columns of the reports and layouts


Note: For large tables we suggest using different export formats, such as Excel.