Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijaymy4rds
Starting Member
2 Posts |
 Posted - 2011-03-10 : 20:33:13
|
Hello Everyone,AnyOne Please help me out from my problem.I have a report which have many filters in it. The data retrieval time is good, but data processing time is more. How can I improve the performance of my report? Is there any way I can reduce the filters by using them in Query? How can I change filters to Query? To improve performance of report not from query part but from design part, Are there any steps I can follow?Thanks in Advance... |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-11 : 10:59:45
|
| I would say that anything that is used as a filter in the report could probably be translated into SQL code in the query. It might take the use of temporary tables and such, but it could probably be done. We need more info though.Hey, it compiles. |
 |
|
|
vijaymy4rds
Starting Member
2 Posts |
Posted - 2011-03-11 : 20:18:06
|
| hey Thanks For Replying...The problem I am facing is, at query level the query is executed in 1 sec and when it is executed at report level its take longer time like 10min. What might be the reason? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-13 : 05:05:39
|
| Is the report server on some slow machine ?PBUH |
|
|
|
|
|
|
How to improve performance of Report in SSRS?