All geek questions in one place

Great reports for MSRS

I have a report that should be able to display a very large number of pages (about 4,500 in this case) in a web browser. The total time it takes to shut down the report server from start to finish is about 30 minutes for the instance that I am viewing. Does anyone know what options exist for handling rendering such a large report in a web browser?

In terms of how this can be solved, I have already completed the following tasks. The report displays data from a database table that already has data smoothed to such an extent that the TimeDataRetrieval on the report server is 17812 or about 18 seconds. The report itself was reformatted to include the least expensive report objects that it can do to display the data in the correct format. I basically consists of a table with about 4 nested tables, and that is it. We tried to do this on the 2005 report server, but continued to encounter memory problems that were not possible for our customers. In response to this, we transferred it to the 2008 report server in order to take advantage of the fact that it uses the file system instead of memory and, finally, was able to make it work without exhausting the available memory, but,Of course, it takes much longer.

+3
source share
3 answers

I would say that this is impossible, the browser is not able to process this amount of data. It’s hard for me to believe that someone finds a useful report of 4,500 pages.

If this data is roughly the same format for all pages, you should separate it into a sub-report style report. Have a basic multi-page report full of links to other subreports.

+2
source
  • Create a report on disk as HTML
  • Each of 4,500 pages is one HTML page.
  • Link from your GUI to the report page + pointer to each of 4,500 pages on disk
0
source

, , , .

0

Source: https://habr.com/ru/post/1738331/

More articles:


All Articles