Categories
Excel Template Scalable Mode to true from Runtime Properties?

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?
Answers
-
At report level or server-wide in the Administration page > Runtime configuration > Properties.
0 -
I cant able to identify the path
0 -
Open report in edit mode → properties → Formatting → Excel Template. Set report value to true and save.
0 -
Hi @User_4FWIE
Below is the navigation screenshots for your reference - system level Using Administration page.
OR
Report level -
Regards,
Arjun
0 -
It does not copy the header column. How can we get the header column
0 -
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).
0