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

Somasekhar Basetty -Oracle

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.

Mallikarjuna Kuppauru-Oracle

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

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

Using MHTML output has the same 65k record limitation.

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

Rgds,

Kevin