Page Breaks or New Tab Breaks in Excel Exports from Oracle OBIEE Reporting

Dr J Harrison

Description

Page breaks show in PDF and PowerPoint exports, but not Excel Exports from OBIEE Reporting. This makes the formatting very hard to manage if the requirement is for an Excel report.

Use Case and Business Need

We have the UseCase:

As a line manager of a recruitment team i want to have reports delivered on a schedule in Excel so that i can prepare reports for the management team.

Our reports are built so that there is a summary table at the top- giving an overview, a pivot table giving a further breakdown and then details of one or more specific types. Without page breaks, even when using titles to separate the tables, the formatting (width/height) of these is set by the first table, leading to some unreadable areas of the report.

Adding a Page Break should resolve some of the formatting issues (using Page Break on inner most or outermost column) in the tables.

These page breaks show and are correct in PDF and PowerPoint exports, but not in Excel.

This idea to have either Page Break or "New Tab" breaks available for Excel.

Original Idea Number: fe168ec832

Ahmed Maher K.

Will be good feature.