Views Reply Votes
Vinh Nguyen
Vinh
 18
Export the report to excel file with over 100K rows?
141
4
0 (0 Votes)
Posted: Jan 30, 2019   
Votes
Chad Stone
Chad
 412
Replied 

If this is a QAD Reporting Framework report, then this is not supported. The underlying 3rd party render engine is limited to the old Excel-binary XLS file limitation of 65.000 rows. 

This limitation would be very difficult for QAD to overcome without changing render engines and reqriting a lot of the reportign solution.

0 (0 Votes)
Replied: Jan 31, 2019
Votes
Francis Malengier
Francis
 15
Replied 

Hi,

I was able to solve the export limitations using the setup in this article of the knowledgebase AA-94723 (https://knowledgebase.qad.com/kmp/article/AA-94723)

It is a workarround for exporting from browses and views. Maybe your report is built on a browse, and you can export your data from the browse instead of the report.

 

 

kr,

Francis

0 (0 Votes)
Replied: Feb 05, 2019
Votes
Mark Garnett
Mark
 9
Replied 

From a business perspective, probably 100,000+ rows are not going to be processed by a user in a spreadsheet.

Can you either filter the browse before export or create a custom browse that summarises the data in some way?

You culd then have a sub-browse that gives the detail to show how the summary was arrived at.

As an example, you could have an inventory summary-by-product-line browse (to show value of inventory held for each product line).  This would likely be a manageble number of rows.

Then a browse collection would link this to the detailed browse  but would only have to show the items for the product-line currently high-lighted.   This is also likely a managable number of rows (so fast enough to show the details adds up to the total).

A browse collection cant be easily exported to spreadsheet, but I woud suggest its better to look at the real live data rather than an out-of-date unmanagmentable large spreadsheet anyway.

0 (0 Votes)
Replied: Mar 13, 2019
Votes
Alban Bentein
Alban
 849
Replied 

Export from a browse of knowledgebase AA-94723 if only a solution if the report can be run as a browse.

If that is not possible, then there is another alternative: you can create a new Report Resource Design layout that gives the data in a flat file CSV format.

Then use the Plain Text output option of the Reporting Framework. 

Note that with the 2018 September release of Channel Islands we have Action Centers that use a new Quey Service engine that can aggrgate millions of browse records in a summarized report or chart.

0 (0 Votes)
Replied: Mar 14, 2019
Forums
All
Forum Help
Help Using Forums