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.
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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