Excel Template Scalable Mode to true from Runtime Properties?

User_4FWIE

Waiting Time: 0.6 seconds

Data Fetch Time: 1.9 minutes

Total Execution Time: 2.3 minutes

Job Priority: Normal

Output fejlede.

[INSTANCE_ID=bip.bi_server1] [OUTPUT_ID=1608279] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.

[INSTANCE_ID=bip.bi_server1]

How do we turn that Excel Template Scalable Mode to true ?

Which run time properties are the error refering to?

Gianni Ceresa

At report level or server-wide in the Administration page > Runtime configuration > Properties.

User_141AF

I cant able to identify the path

Zaid123

Open report in edit mode → properties → Formatting → Excel Template. Set report value to true and save.

Mallikarjuna Kuppauru-Oracle

Hi @User_4FWIE

Below is the navigation screenshots for your reference - system level Using Administration page.

OR

Report level -

Regards,

Arjun

User_86E2M

It does not copy the header column. How can we get the header column

Gianni Ceresa

@User_86E2M ,

Not sure what you mean with your message (the thread is about where to set a parameter based on an error OP got).

Because this is a old thread, you could ask a new question, describing your situation, your question, the current behavior, the expected behavior, and what you did so far to try to change it. And also the product name and version you are using (as features can be different based on the product you use).