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?