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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-11-24 : 09:52:29
|
| Hi there,I recently developed a report using a rather large dataset which includes various calculations aggregates and tables etc. When I went to run the report it took 7 minutes to finish. This was unacceptable for clients so I decided to populate with the query over night so the report could run faster; which it did. The table would first be truncated and then updated with the recent dataset from the query. However, the data wasn't real time which was not great.I'd like to ask folks if there's a comprimise to this. If there's someway to still run a report (SSRS) as real time as possible but still being able to update the table for the report. Just to mention, users will be running the report at anytime during the day so hopefully there's a method that will not affect the running of the report too much.Any help is appreciated.:) |
|
|
|
|
|
Running report while updating dataset?