Focal Point
How much amount of data we can load in Active report.(ahtml)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9477082096

May 31, 2018, 02:57 PM
Neelima
How much amount of data we can load in Active report.(ahtml)
Hi All,

Does anyone know about the maximum size of Active Report(AHTML) ouput file.

Thanks in advance


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
May 31, 2018, 03:00 PM
BabakNYC
According to doc, an active report has a processing limit of approximately 5,000 records or 100 pages of output.

https://webfocusinfocenter.inf.../activetech_8203.pdf


WebFOCUS 8206, Unix, Windows
May 31, 2018, 03:27 PM
Neelima
Thanks for quick reply..

Its true for processing limit.

If I want to put 5 Graphs, 5 reports and 1 image, what will be size of Active Report output file(AHTML).
I have searched over the net and found that 20 MB size of output is good as per performance.Anything beyond 20 MB leads to performance degradation.

And we are using 8104.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
May 31, 2018, 03:43 PM
BabakNYC
You might want to open a case with IB Tech support for the official response. What you'll get here is anecdotal.


WebFOCUS 8206, Unix, Windows
June 01, 2018, 03:51 AM
Neelima
Ok BabakNYC.. I have opened case for same. but I need to know one more thing, can we measure the chart output size which is generated by GRAPH FILE statement.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
June 01, 2018, 12:28 PM
CoolGuy
My 2 cents: Use DataTables.js.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
June 01, 2018, 02:30 PM
Neelima
Hi CoolGuy,

Can you please share some reference link for integration DataTables.js with WF. it will be great help for me to look into it

Thanks in Advance


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
June 01, 2018, 04:54 PM
CoolGuy
There's an extension in IBI's official Github repo that does it for you within IA+; as well as many articles on it and how to use it here on the forums. Just search for DataTables.js.

The official site is datatables.net.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
June 04, 2018, 01:16 AM
Neelima
Hi CoolGuy,

I want to create Active Report. But it looks DataTables.js for HTML report.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies