Hi
I have a very serious problem on load huge data to stiWebViewer.
It's very very time consuming.
I have about 40,000 records and some times I need to show all of them to use.[for export or viewing]
but unfortunately loading data in about 1200 page is very slow.
Is there any solution to reduce this time.
I have check render mode and in "AjaxWithCache" that all data cash in ram in the server going to next page takes 3-4 sec and load all data take about 100 sec.
another problem is, after all data load, in page 1, I have data but in another pages There isn't any data showing.but in last pages again show data!
I check data based for null values and I'm sure we have data in all records in data base.
In above scenarios I connected report directly to SQL server for best performances,but in real project we have an ORM (NHibernate) layer and need to use it to load data,and when I use this and load data in List collection and set datasource of report with this list loading huge data is more disappointing.
can you please help me to solved this problems?
I have use last version 2011.3
load larg data
load larg data
Hello,
You can try to use caching. To do this, please set the following report property:
report.ReportCacheMode = StiReportCacheMode.On;
It is also necessary to set the caching folder:
StiOptions.Engine.ReportCache.CachePath = path;
This directory must be writable for ASP.NET applications.
This issue was discussed in the following topic: http://forum.stimulsoft.com/Default.aspx?g=posts&t=5091
Thank you.
You can try to use caching. To do this, please set the following report property:
report.ReportCacheMode = StiReportCacheMode.On;
It is also necessary to set the caching folder:
StiOptions.Engine.ReportCache.CachePath = path;
This directory must be writable for ASP.NET applications.
This issue was discussed in the following topic: http://forum.stimulsoft.com/Default.aspx?g=posts&t=5091
Thank you.
load larg data
Thanks for your response.
I have read all post of linked topic and use from ReportCacheMode and StiOptions.Engine.ReportCache.CachePath in my code.
Now The problem about blank page is solved but other problems aren't solved.
Is it possible to prevent rendering all pages at initial time?
It means,after select all data from data base only first page render for showing to user and other pages render only when needed.(when clicked on next page in webviewer, page created.)[in Crystal report it's easy and loading reports with huge data is awesome.] in this case,It's obviously that no need to show count of last page at webviewer.
or even better solution is get data from data base server with paging.It means when in one page only 10 or 15 records can be display just this records fetch from data base and when click on next page other 15 records fetch for displaying.(Just like paging in DataGridView asp.net control)
I changed render mode to standard or another option but unfortunately after each next page clicked all data select from data base not only needed data!
and at last if you cann't handle paging, Is it possible to get me an event on next and back page button in webviewer or somewhere like that to handle loading data with paging myself?
I have read all post of linked topic and use from ReportCacheMode and StiOptions.Engine.ReportCache.CachePath in my code.
Now The problem about blank page is solved but other problems aren't solved.
Is it possible to prevent rendering all pages at initial time?
It means,after select all data from data base only first page render for showing to user and other pages render only when needed.(when clicked on next page in webviewer, page created.)[in Crystal report it's easy and loading reports with huge data is awesome.] in this case,It's obviously that no need to show count of last page at webviewer.
or even better solution is get data from data base server with paging.It means when in one page only 10 or 15 records can be display just this records fetch from data base and when click on next page other 15 records fetch for displaying.(Just like paging in DataGridView asp.net control)
I changed render mode to standard or another option but unfortunately after each next page clicked all data select from data base not only needed data!
and at last if you cann't handle paging, Is it possible to get me an event on next and back page button in webviewer or somewhere like that to handle loading data with paging myself?
load larg data
Hello,
Please specify in which event you load a report and assign its to viewer?
Thank you.
Please specify in which event you load a report and assign its to viewer?
Thank you.
load larg data
I have a button and a webviewer in my aspx page,
in click event of button I have loaded report from file and after load assign its to viewer.
I think, It's simplest way to show report.
in click event of button I have loaded report from file and after load assign its to viewer.
I think, It's simplest way to show report.
load larg data
Hello,
When using the AjaxWithCache render mode, the rendered report will be placed to the server cache. When you change the page number, the report is loaded from the cache again. On the web server side it is slower because of limited resources. Also load time will depend from the complexity of the report and the number of components on the page. At this point, there are no another ways to load report in report viewer.
Thank you.
When using the AjaxWithCache render mode, the rendered report will be placed to the server cache. When you change the page number, the report is loaded from the cache again. On the web server side it is slower because of limited resources. Also load time will depend from the complexity of the report and the number of components on the page. At this point, there are no another ways to load report in report viewer.
Thank you.
load larg data
If i use another render mode is it better and faster in loading data???
I have a very simple report without any complicated components.
I'm very very disappointed from Stimulsoft, because I think loading huge data is very important issue that must be done in minimum of time.
I have to use Crystal Report only and only for this purpose. :dumb:
I have a very simple report without any complicated components.
I'm very very disappointed from Stimulsoft, because I think loading huge data is very important issue that must be done in minimum of time.
I have to use Crystal Report only and only for this purpose. :dumb:
load larg data
Hello.
Also you could try to use StiWebViewerFx.
Thank you.
Please, try to use other render modes.alirezaf wrote:If i use another render mode is it better and faster in loading data???
I have a very simple report without any complicated components.
I'm very very disappointed from Stimulsoft, because I think loading huge data is very important issue that must be done in minimum of time.
I have to use Crystal Report only and only for this purpose. :dumb:
Also you could try to use StiWebViewerFx.
Thank you.
load larg data
I have try all render mode and also StiWebViewerFx,
but unfortunately the performance of load large data in stimul report is too bad.
I'm so confused
but unfortunately the performance of load large data in stimul report is too bad.
I'm so confused
load larg data
Hello.
Thank you.
Unfortunately, there is no solution for this problem. In our release 2012.1 the code optimization was done. Please, try it when it will be available.alirezaf wrote:I have try all render mode and also StiWebViewerFx,
but unfortunately the performance of load large data in stimul report is too bad.
Thank you.