Question & Answer
Question
After running a BIRT report within Maximo and then exporting to another file format, the report output results are displayed in a single page for PDF and XLS formats. However, when selecting XLSX as the export format, it is converting the pages into separate Excel Spreadsheet tabs.
Answer
This is a limitation with the BIRT Emitter. The BIRT Emitters are 3rd party software and IBM is not able to make changes to this code. However, if you change the page break setting in the report you can extend the excel page to a maximum of 9999 lines before a new tab is generated.
Open the the rptdesign file and search for the string "pageBreak"
<property name="pageBreakInterval">50</property>
Change this to maximum of 9999:
<property name="pageBreakInterval">9999</property>
Save changes and import report into Report Administration application and click "Generate Request Pages" in order for the report to be updated in Maximo.
This property will impact the report output in PDF as well, so you may want to keep 2 versions of the report. One at 40 for PDF, one at 9999 for excel output.
The Bugzilla bugs link below also confirms this ability to change the page break by report.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=573117
https://bugs.eclipse.org/bugs/show_bug.cgi?id=573117
"The value of 40 is the default page-break interval defined for the table.
You can set the value to a higher value (the maximum allowed value is 9999 AFAIK)."
You can set the value to a higher value (the maximum allowed value is 9999 AFAIK)."
Related Information
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"BIRT","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0.x","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
20 March 2023
UID
ibm10740191
Manage My Notification Subscriptions