Very Very Urgent...!!! Please Help me...
Thanks for the response.... its not a performance issue..its my requirement to display the report like the first group of data- the first five pages- displaying for 60 seconds on the first web page and then the next group of data and so on.... I dont know how can i do this....do i need to write any custom code??
February 12th, 2011 12:58am
Hi, I created a report through data set(SQL Query) by joining two tables that contain one million records in each table. After deploy into report manager,I need to Display the report on the first web page in 60 seconds for the first group data. Such as the first 5 pages, then next 5 pages and so on. How Can i do this...Please Please Please Help me..... Thanks in Advance.
February 12th, 2011 1:06am
Do you have to move on to the next group of data for every 60 seconds automatically?
February 12th, 2011 2:02am
I don't clear understand your problem, is it performance issue ? if so there are few ways to improve performance on DB level - try to play with indexes, Database Engine Tuning Advisor and etc on SSRS level - you can set up reports from snapshots or cache, schedule time to pre-build snapshots http://msdn.microsoft.com/en-us/library/ms159241.aspx http://msdn.microsoft.com/en-us/library/ms156325.aspx
February 12th, 2011 2:28am
Hi sunny_pachi, When a user pages through a report, the report processor will combine data and report layout information for each report page and passes the page to the report renderer, so to a report that has no page breaks, the whole report must be processed before the user can view the first page, so I would recommend you add a pagebreak to the group, however this still could not ensure that your report could show the first page within 60 seconds, as it has some relationship with your amount of the data and hardware's performance. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
February 18th, 2011 10:49pm