Server-side paging

[beginner]

Hi,

I'm using SQL Connection Data Source in my report. In some scenarios I have a very large report, maybe 400 pages, I've noticed that Stimulsoft will generate the whole report at once before sending it to the browser which causes a long loading time.

Please guide me if I can enable paging on the server-side, so just current page is generated.

If it's not available in SQL Data Source, please point me to the right direction. What else can I do increase my app's performance and shorten loading time.

Thanks in advance,

[HighAley]

Hello.

Unfortunately, it's impossible to show the first page until the whole report is rendered.

As a way you could split report on parts and ask user what part of the report to show.

Thank you.