You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract more than 65000 records per excel sheet with BIP Report

edited Sep 9, 2024 2:13AM in Reporting and Analytics for SCM 4 comments

Summary:

Hi,

Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, we can get in one sheet, but some fields has carriage returns and cannot use it.

Is there a way to get XLSX format (using excel template) or more than 65K records per sheet using excel.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

24A

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!