Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Desktop Export to Excel - 65536 rows only

590587Nov 14 2008 — edited Nov 20 2008

Hi,

When I run the same report agains plus and export the results, all the rows gets exported to the excel. Since its a huge data that I am reporting on, the excel automatically spans into multiple tabs/sheets and i get all my data exported correctly.

However, when I export the same report output from Desktop, only 65536, the maximum number of rows in excel is getting exported. The excel does not span into m-sheets as it does with plus export.

And I have not limited my number of rows retrieved. It is uncheked.

Can someone suggest me a solution to this. I would not want to use Plus for export, I am looking to acheive export of entire rows into an excel through Desktop only.

Your inputs are highly appreciated.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2008

Added on Nov 14 2008

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

2 comments

1,094 views