Reports very slow.

shilpa · Post by **shilpa** » Fri Aug 19, 2011 1:37 am

Hi ,

Sorry for the late reply.I have enabled caching to "On" and done the necessary coding to implement that.
Now, I am happy to say that atleast we are able to see the report.But, there is a small problem.The report we are getting has 624 pages and we can see only 50 pages now.Remaining pages are blank.

What can be the issue ?I have use the below code for that.

Dim CacheFolder As String = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "StimulsoftReportsCache")
If Not System.IO.Directory.Exists(CacheFolder) Then
System.IO.Directory.CreateDirectory(CacheFolder)
End If
ssoftRpt.ReportCachePath = CacheFolder
ssoftRpt.ReportCacheMode = Stimulsoft.Report.StiReportCacheMode.On
ssoftRpt.RenderedPages.CanUseCacheMode = True
ssoftRpt.RenderedPages.CacheMode = True
ssoftRpt.RenderedPages.Clear()

Secondly, I want to make my own cache folder ( I mean the path for the cache folder) instead of the folder which is created at the LocalApplication.Can u tell me the appropriate way to the same ?

Thank you.

Post by **Vladimir** » Fri Aug 19, 2011 9:00 am

Hello,

The first 50 pages are stored in memory, the rest of the pages are cached in the file. Most likely there are no rights to write to a temporary directory for ASP.NET applications. You can specify the cache directory, use the following option:

StiOptions.Engine.ReportCache.CachePath = path;

For this you need to set the write permissions for this directory.

Thank you.

shilpa · Post by **shilpa** » Sat Aug 20, 2011 7:48 am

Hi,

You solved my second problem to store the cache folder in the path I want.Thnx for the help.I tried this .

But, Can u tell me why I am seeing only 50 pages out of 624 pages in my report ?
Out of 624 pages,1st page contains data.
From 2nd page to page no. 575 ,the data is not visible.
Then from page 576 to 624, data is visible.

In all, I can see total 50 pages.

Thank you.

Post by **Vladimir** » Mon Aug 22, 2011 8:58 am

Hello,

We have made improvement of the WebWiever component, now it supports the reports with enabled cache mode. The update will be available in the next prerelease build.

Thank you.

shilpa · Post by **shilpa** » Thu Aug 25, 2011 12:55 am

Hi,

Thank you for the update. Will update the Webviewer component from the next prerelease build and let u know .

Thank you.

Post by **HighAley** » Fri Aug 26, 2011 1:41 am

Hello.

shilpa wrote:Thank you for the update. Will update the Webviewer component from the next prerelease build and let u know.

Waiting for your reply.

Thank you.

shilpa · Post by **shilpa** » Tue Aug 30, 2011 7:40 am

Hi,

I am very happy & delighted to say that the updation of Webviewer component from the new release (Stimulsoft Reports.Web 2011.08.25 Trial ) has solved my problem. Now, I can see the whole report unlike the report before (showing only 50 pages -remaining pages blank ).

Thank you very much. :biggrin:

But, now one more problem has arose.When I am saving the report in any format say- pdf, excel ,word etc , I am getting a blank data.
what can be the reason for this now?
:pffft:

Thank you.

Post by **HighAley** » Wed Aug 31, 2011 12:57 am

Hello.

shilpa wrote:But, now one more problem has arose.When I am saving the report in any format say- pdf, excel ,word etc , I am getting a blank data.
what can be the reason for this now?
:pffft:

Please, send us a generated report to reproduce your issue.

Thank you.

shilpa · Post by **shilpa** » Wed Aug 31, 2011 5:33 am

Hi,

The problem has been solved. May be there was some problem.Now we can save the report in pdf.

Thank you.

:biggrin:

Cheers !!

Post by **Andrew** » Wed Aug 31, 2011 6:12 am

Great! :biggrin:

Have a nice day!
Thank you.