Last post Dec 18, 2011 11:53 PM by Srikanth Kasturi
Dec 15, 2011 04:35 PM|erobinson|LINK
I have a simple report which should populate 45000 record, the sql takes less than 3 sec and it takes 15 min to open the report.
How do i improve the performance.
Dec 15, 2011 10:14 PM|jeeveshfuloria08|LINK
For rendering large reports and the upcoming timeout issues, you may refer John Gallardo's blog, which has explained it clearly.
The problem is that while the report is being executed, the user's session is locked (as we are populating the user's temporary snapshot) and the keepalive from the viewer control will be blocked. Normally, this is not a problem because report executions
aren't supposed to take a long time and quite often they finish before the session timeout hits. Unfortunately, there are some cases where reports (for whatever reason) take an incredibly long time to execute. What happens in this case is that the user's
session is aged out while the report is being executed, resulting in all sorts of strange behavior.
Here’s the solution he provided,
1,Reduce the time it takes to run the report. Generally this involves simplifying the report or moving some of the aggregation/sorting to the database layer (RDBMSs are generally better at this than we are).
2,Consider running the report offline. Try creating a schedule by which the report is executed during off-hours, and users only see this snapshot of the data. This can greatly improve execution performance for large reports which involve lots of grouping/sorting
in the report server.
3,Consider delivering the reports via a subscription. Probably your user doesn't want to leave IE sitting open for two hours waiting for a report to render. It is too easy to accidently close the window and now he or she is back at square one. If you have
a report which takes hours to generate, consider creating a subscription and delivering the report to the person via email or a file share.
check some link for report performance issue:-
Dec 16, 2011 01:35 PM|erobinson|LINK
This report doesn't have any aggregation / sorting , just a select statement.
Can anybody provide me a code that will allow to send a rdlc report through email in C#.
Dec 18, 2011 11:53 PM|Srikanth Kasturi|LINK
The best way to accomplish this task is using the scheduler feature of the reporting server.
This can be used to run a schedule a report to run and email the required format (CSV,WORD,EXCEL,PDF) to any number of receipents.
You can do this by using following steps:
1. Open report server in IE.
2. Click on the arrow beside the desired rdlc file(Report) you wish to email.
3. Click on Subscribe.
4. Click on New Subscription and enter the To, Cc, Bcc address as required.