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 |
|
mrm23
Posting Yak Master
198 Posts |
 Posted - 2010-05-13 : 05:38:50
|
| Hi All,I want to know how one can increase the performance of a report.in my report i will be passing nearly 10000 ids to the parameters.this happens in the main report. however, my subreport will show data for only one id at a time.i am passing fields!id.Value to my subreport hoping this would increase its efficiency.can i do anything else to increase its performance? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-13 : 10:51:09
|
| what does subreport display? can the data be merged into main report itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mrm23
Posting Yak Master
198 Posts |
Posted - 2010-05-14 : 00:06:15
|
| hi,no we cannot merge the subreports into the main report. the main report is a single row report which shows the summarised data.....ex: User Reqs Resumes Interviews Offer Made Offer Accepted JoinedAAA 2 29 12 8 6 5and the detail report will show all the details of all the fields for AAA.hence we need to keep detail reports separately. |
|
|
|
|
|
|
Performance of Reports