Execution time for report is more when compared to dataset

Question

Hi all

my first data set takes 2 minutes for execution and my second takes 1.5 minute

but when i run report on these data sets it takes around 6 minutes. How to decrease this??

please help me..

Answer 1

Can you post the queries?

To All:

The more information you give, the faster assistance you get.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Answer 2

Hi,

In general, it is caused because of lots of data rows and huge amounts of calculations on your report. You can manage to do some calculations in Database Engine to reduce reporting load if possible. If you want further help, please provide more information.

thanks,
Jerry