sivabisani

 Profile Answers by sivabisani 

• Nov 13th, 2008

 

To improve performance of a report we can approach these method


In database level:

1)In this level to improve performance create indexes to improve the performance.

In model level :

1)you can remove loop's at that time you can improve performance at model level
2)use indexes you can improve performance
3)Change the property of query processing to Limited local or database only.

In report level:

1)you can reduce the calculation and conditions in the report
2) you can limit the cut copy paste operations for user's
3) you can limit access no of report's at peek time you can improve performance at report level
4)in the report studio query properties we can set query exccution method to concurrent.

Thanks
siva