Columns get cut off when QBR is exported to .PDF

Answer

There is a known limitation of the Adobe Reader PDF format, that is used in QBR reports. Upon exporting a QBR report to PDF with a large number of columns, it cuts off some of the columns. This is due to the fixed number of fields.


This topic is discussed in more detail in the following guide:
V75_QBR_Ad Hoc Reporting.pdf (click to open)

Section labeled "QBR report Display Notes" states the following:"

..there are no limitations to the number of fields a user can add to the report. A user can choose to only include a single data field, or a very large number like 50 fields. If the user adds a very large number of database fields to their QBR report, this will require the user to scroll through the Report Browser to view all of their fields.

Additionally, if the user prints or exports the report with a very large number of fields to Adobe, all of the report fields will not display due to the fixed page size of Adobe. Also, if the user prints the report to HTML, the user will need to scroll through the Report Browser to view all of their fields – but only a portion of those fields will print in HTML due to the fixed page size.

However, these constraints should not limit users to a minimum number of fields because many users want a large number of fields to export to .csv or .xls for additional data analysis. Since the export of data to .csv/.xls is a primary requirement of this functionality, the number of fields the user can utilize in his QBR report will not be limited by scrolling or incomplete display of data in pdf."

The alternative is to use other available files types, such as .XLS, to export a report with a large number of columns.

Please be advised that this is not a Maximo issue, but a .PDF file type limitation.