Page 1 of 1

binding report to viewer taking lots of time

Posted: Tue Sep 24, 2013 7:34 am
by soma@trackitme.com
Hi,

- Iam using stimulsoft reports.web 2013.1.1600.0 version.
- For 10,000 records of data
In my report i have 3 datasources, simple design font used tahoma 8 to 10 size and simple style components were used(style designer).
- 1st datasource it is taking 1 sec for regdata
- 2nd datasource it is taking 2 sec for regdata
- 3rd datasource it is taking 2 sec for regdata
and query also retrieving within 2 sec.
but while report binding to stimulsoft report viewer it is taking 6 min to bind the whole report .
- I have implemented all the optimizing technique
In my report optimization techniques i have applied are:
- removed subreport
- all group headers placed in one group header
- font sizes are decreased
- all text boxes are aligned to grid properly
- image stretch to false was given to image

How can load my report within seconds for lots(eg:10,000 to 50,000 that) of data ?

Regards,
prathyusha

Re: binding report to viewer taking lots of time

Posted: Wed Sep 25, 2013 6:02 am
by HighAley
Hello.

Please, send us your report template with sample data for analysis.

Thank you.

Re: binding report to viewer taking lots of time

Posted: Tue Oct 15, 2013 10:44 am
by soma@trackitme.com
WebApplication1.rar
(11.44 MiB) Downloaded 183 times
DBSamleStimul.rar
(60.69 KiB) Downloaded 178 times
Hello,
- Iam using stimulsoft reports.web 2013.1.1600.0 version.
- For 10,000 records of data
In my report i have 3 datasources, simple design font used tahoma 8 to 10 size and simple style components were used(style designer).
- 1st datasource it is taking 1 sec for regdata
- 2nd datasource it is taking 2 sec for regdata
- 3rd datasource it is taking 2 sec for regdata
and query also retrieving within 2 sec.
but while report binding to stimulsoft report viewer it is taking 6 min to bind the whole report .
I have attached webApplication.rar file and Database script file
I have made sample applicaton with data of 10,000 records,it is taking 9min to load the reports.
can you please check it out, how can i load my report within seconds?

regards,
prathyusha.

Re: binding report to viewer taking lots of time

Posted: Wed Oct 16, 2013 1:44 pm
by HighAley
Hello.

Sorry, but we couldn't reproduce your issue, because there is no Telerik.OpenAccess assembly.

Thank you.

Re: binding report to viewer taking lots of time

Posted: Thu Oct 17, 2013 4:54 am
by soma@trackitme.com
Hello,

you no need to install the Telerik.OpenAccess it is already present in the bin files of the web application sample that i have attached .Once again iam attaching the application rar folder can you please check it out.


regards,
prathyusha.

Re: binding report to viewer taking lots of time

Posted: Thu Oct 17, 2013 12:36 pm
by HighAley
Hello.

It's forbidden to post Stimulsoft licensed assemblies on this forum.
We have got another error with your project:
Could not load file or assembly 'Telerik.OpenAccess.Runtime
Could you send us a working project?

Thank you.

Re: binding report to viewer taking lots of time

Posted: Fri Oct 18, 2013 7:36 am
by soma@trackitme.com
Hello,
- Please find the attached bin.rar in that telerik.openacess.runtime.dll is present and replace the folder in the web application and the published files of web application are also attached as publishOct18.rar.
- I have attached the url for this web application i hosted in my system.

Can you please check it out.

Regards,
prathyusha.
[url]http://192.168.1.5:9090/StimulOct18/TAW ... tForm.aspx [/url]


[attachment=0]bin.rar[/attachment]
[attachment=1]publishOct18.rar[/attachment]

Re: binding report to viewer taking lots of time

Posted: Fri Oct 18, 2013 1:06 pm
by Alex K.
Hello,

We could not run your project. Please send us not published web project for analysis.

Thank you.