There is a big issue when showing a huge amount of records

vijendra · Post by **vijendra** » Wed Apr 30, 2008 5:09 am

Hello Members ,
There is problem regarding stimulsoft reports when my query return large no of records say more than 2000 then stimulsoft veiwer does not show report even after a long wait.....................if someone has faced the same problem them please let me know ...and also...the solution........as soon as possible........

If stimulsoft developer has a solution then please let me know...as soon as possible ....

Post by **Edward** » Thu May 01, 2008 6:20 am

Is that query executed without problems in the SQL command window of your server? And all records are retrieved successfully.

Also please try to execute this query in the DataSource editor window. Does it succeed in the Design-time?

Thank you.

vijendra · Post by **vijendra** » Thu May 01, 2008 6:36 am

yes the query is executed successfully and returning records.
Table of Dataset is also filled.

When Records Exceeds about 2000 rows it Report Does not show records(Blank Page Comes) or system is hang
When query returns about 1000 rows it works properly

the code Where it gets Hang is

StiWebViewer1.Report = pStiReport

at this line we assign STI report to the STI web viewer

Post by **Vital** » Thu May 01, 2008 5:28 pm

Hello,

Please say me in which events of page you generate code? For also try to set property RenderMode of StiWebViewer to RenderOnlyCurrentPage value.

Thank you.

vijendra · Post by **vijendra** » Fri May 02, 2008 12:04 am

This code is in the page load event of the page
and the property is set to rendercurrentpage is already set for the web viewer

vijendra · Post by **vijendra** » Fri May 02, 2008 12:16 am

Thanks a lot........................................
after setting the property RenderMode =RenderonlyCurrentPage this problem is solved
Thank You for your support

Post by **Edward** » Fri May 02, 2008 1:58 pm

Please let us know if any help is required.

Thank you.