Question:
Hi,
In a Web report we have a query that returns a very large table (40,000+ rows). We want to be able to display all the rows on the same web page.
When we try to do this by setting the Number of Data Rows Displayed at Once (BLOCK_SIZE) option for the table in our Web Template, the web page takes absolutely forever to load (and Internet Explorer freezes).
Does anyone know if such an amount of rows can be generated in one page?
Would it help to precalculate / pre-render the HTML?
Please, if you can share your thoughts on this.
Thank you!
Answer:
My first impression is : why the hell do you need 40 000 rows to be displayed ON THE WEB !!! (same reaction for the BEX)
BW is not here for mass reporting, to me.
Other inputs ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
jolu....
you want 40000 lines on one page ......
how do you plan to read the report.....
or are you talking about scrolling .....
Answer:
use reporting agent to precalculate
use excel for reporting
Answer:
Thanks for intelligent answers...?
It is a client requirement - No point of going into all details here, but it is necessary for us to do this. The total report will most likely contain more than 40,000 rows (closer to 80,000 when not filtered on anything specific).
BEx is not an option, unfortunately.
We will try to get it (data + html) precalculated. After doing this, we need to remove (yes) all rows that are not "Overall Results" (totals).
We cannot do this in the query because of the complexity of the calculations and cell definitions. If we hide the rows/structure in the query, the totals are calculated incorrectly. This is a confirmed bug in BW..
Anyway, still appreciate your input.