Stimulsoft report taking very long time to load

[soma@trackitme.com]

Hi,

- Iam using stimulsoft reports of stimulsoft.web version 2013.1.1600.0 .
- Iam giving full trust property to false and calculation mode property of report to interpretation.
- when iam trying to load the report for 10,000 records of data report not getting loaded,but my query is returning the data
within 10 seconds .
- how can i retrieve report data fastly , please help me out in this task as soon as possible.

regards,
prathyusha.

[HighAley]

Hello.

There are some new articles on report optimization on our Blog. http://blog.stimulsoft.com/
Please, read them all at first. If it will not help then we need to see your report template with sample data for analysis?

Thank you.

[soma@trackitme.com]

Hi,

- We have optimized our reports with whatever suggestion you have given to us,but then also it is taking 2min to load the reports when the records are increasing to 50,000 records it is taking so long time to load.

- we want to load the report according to page no wise, per page 50 records like that,while paging we can retrieve records.
for eg:1st page 30 records,2nd 30-50 records...
so,please can you help me out in this giving some samples how can we do records loading per page wise.

regards,
prathyusha.

[HighAley]

Hello.

- We have optimized our reports with whatever suggestion you have given to us,but then also it is taking 2min to load the reports when the records are increasing to 50,000 records it is taking so long time to load.

It's too much data for the Web. You should split your report to several parts.

- we want to load the report according to page no wise, per page 50 records like that,while paging we can retrieve records.
for eg:1st page 30 records,2nd 30-50 records...
so,please can you help me out in this giving some samples how can we do records loading per page wise.

You could add a parameter to your query end show data piece by piece.

Thank you.

[soma@trackitme.com]

As suggested by you,we are trying to split the data by getting 10 or 20 records from the query .
We want to send the report pagenumber as parameter to the query and retrieve the data based on the pagenumber.
we tried to get the report pagenumber using below code but it is always returning pagenumber as zero.

Dim repnew As StiReport = New StiReport()
Dim Info1 As String = (repnew.PageNumber).ToString()

Is there any event for page changing or to get the current page pagenumber?

[Vladimir]

Hello,

To get the page number in the WebViewer you can use the StiWebViewer1.CurrentPage property.

But, the number of pages of a rendered report depends on the amount of data in the query. As well when the data changes the report will be built anew. You can not use the current page number in the query. You need to use the Request from User variables in the report, which will indicate the number of the first and the last record to SQL query, or their amount.

Thank you.

[HighAley]

Hello.

We want to send the report pagenumber as parameter to the query and retrieve the data based on the pagenumber.

Unfortunately, it's impossible to get any page without building the whole report.
Also it's impossible to know what data will be on what page till the whole report will be built.
It needs some time to build the report.
So the only way is to request part of the data and build the report with it.

Thank you.