WebIntelligence Scheduled Excell Report is Cutting Off Information After 65000 Rows

We have version XI running on a windows server, and have the ability to schedule WEBI reports to run and send to people via email distribution. our problem is we only have the option to send PDF or Excel format.

If we send Excel, it is cutting off lines after 65,000 rows. I have noticed that Microsoft Excel is not even loaded on the server at all, so I am not sure where it is getting the excel client to use.

We need either an updated version of an Excel output that delivers > 65K rows, such as Excel 2007, OR the ability to send a report in a *.csv format.

Steps to Reproduce:

Navigate to a BOBJ WEBI report. Schedule report, and under Destination set up email. Under format, the options are only Excel or Adobe PDF.

Do I have more options than that?
akrinanAsked:
Who is Participating?
 
asimmunshiCommented:
am afraid not.
Excel 2007 is supported with XIR3 and beyond
0
 
asimmunshiCommented:
You could of course use the SDK to do some custom development to get a CSV output
0
 
akrinanAuthor Commented:
Thank you. I will deliver this information to my client.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.