ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Excel Format Issue for Jaspersoft Reports

book

Article ID: 111930

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When running a Jaspersoft report from from 'Reports and Jobs' page and selecting the format of XSLX, the report header repeats about every 16 - 18 rows. 

Environment

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

This is currently working as designed. The reports have been hard coded to use the 'XLSX with Pagination' format when run from 'Reports and Jobs, ' which then adds a copy of the column headers on every page. 

In order to export the report without the repeated headers, run the report from Advanced Reporting with the XSLX format instead.