We have a SSRS Report which has
52 thousand lines the same report on another company has 5 thousand
lines. The firstone goes into a timeout and cant be processed and viewed
not even with batch processing and email sent.
I am currently searching for a way to split the Report into multiple
processes so the workload gets split and the user can still view the
report without a timeout but i dont find a way how to.
My goal would be that the user opens the Report and for example it loads the first 10 thousand lines and after the user closes it it opens the next 10 thousand and so on.
If you have any better solution please consider telling me about it.