I have an active report that sometimes is as large as 80K rows. If it has around 10K lines, the report can export to Excel without a problem. But when the report is much larger, say 40K, the export fails. Does anyone know if this is a known issue or if there is a work around?
Thanks so much!

This message has been edited. Last edited by: FP Mod Chuck,

Hello Melsmith and welcome to Focal Point!

Can you try setting Active Cache to ON? This might speed it up and let it handle more rows.

You can see a little more information on Active Cache and how to enable it in our manuals. For instance, click here for information on the Active Cache in InfoAssist.

Hi Melsmith,
Why would anyone want to have a report with 80,000 lines?
If this is a request from a user, maybe you should explain to the user that his parameters are not "focused" enough...