Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Page Break function not working for excel(MHTML) output format

Received Response
33
Views
3
Comments
Somasekhar Basetty -Oracle
Somasekhar Basetty -Oracle Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

Hi Team,

The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab.

We have developed the multi-tab report using the RTF template. In the RTF template, we used the page break option to split the data into multiple tabs (data groups), and it works fine when the output is in Excel format.

However, when we select the Excel (MHTML) output, the data from two tabs is displayed in a single tab.

Has anyone worked on a similar requirement? If so, please share your insights on how we can achieve this.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi @Somasekhar Basetty -Oracle

    Welcome to Analytics community.

    I hope this is an Expected Behavior when you convert the output into MHTML format.

    FYI, We are process of Introducing the New Feature - Excel Template Upgrade to .xlsx format which can resolve the limit issue.

    Regards,

    Arjun

  • Somasekhar Basetty -Oracle
    Somasekhar Basetty -Oracle Rank 1 - Community Starter

    Hi Arjun,

    Thanks for the update. could you please share when the new feature will available in excel template and how to update to xlsx format .

    Regards,

    Soma

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics & AI Lead

    Using MHTML output has the same 65k record limitation.

    Currently you can use an RTF or XPT layout to generate xlsx output.

    Rgds,

    Kevin