Page 1 of 1
There is a big issue when showing a huge amount of records
Posted: Wed Apr 30, 2008 5:09 am
by vijendra
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 ....
There is a big issue when showing a huge amount of records
Posted: Thu May 01, 2008 6:20 am
by Edward
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.
There is a big issue when showing a huge amount of records
Posted: Thu May 01, 2008 6:36 am
by vijendra
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
There is a big issue when showing a huge amount of records
Posted: Thu May 01, 2008 5:28 pm
by Vital
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.
There is a big issue when showing a huge amount of records
Posted: Fri May 02, 2008 12:04 am
by vijendra
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
There is a big issue when showing a huge amount of records
Posted: Fri May 02, 2008 12:16 am
by vijendra
Thanks a lot........................................
after setting the property RenderMode =RenderonlyCurrentPage this problem is solved
Thank You for your support
There is a big issue when showing a huge amount of records
Posted: Fri May 02, 2008 1:58 pm
by Edward
Please let us know if any help is required.
Thank you.