tags:

views:

10

answers:

0
Q: 

Reporting service slow but sql procedure is fast

I have now seen it several times and was wondering if there is a solution for this problem. WHen I run procedure (which I have heard is the fastest method) it takes 1 sec but in report manager it takes like 20 sec. And if run the query in report builder (BI) it takes appx.17 sec and the last 3 sec to render the report.

Any suggestions here?

I'm using MS SQL 2005 with Reporting service

related questions

SSRS 2005 Saving Report Parameters
Returning data from SQL Server reporting web service call
SSRS 2005 Report Automatically Rendering
Modifying parameters with code in Microsoft Reporting Services
Subreports try and keep together leaving blank spots/pages
Locking SSRS fields in place
Subtotal error on calculated field in a Reporting Services Matrix
Dual Axis Graphs - Reporting Services 2005
Report Builder, prompt filter, how to ignore the filter?
In SQL Reporting services, is there a way to dynamically hide some parameters (but not all) from users?
How to use Multiple result sets in Reporting Services
Dimension Security in SSAS & SSRS
Using an ASP.NET server control in a sql server 2005 reporting .rdl file
Setting up Windows Authentication In Reporting Services Using Kerberos
SSRS 2005 - How do I find the value of a cell 1 column over and 2 rows up?
HTTP 400 returned while accessing SQL Server 2005 Reporting Services Report Manager
Rendering SSRS reports from VB.Net
Exporting from SSRS to Excel with no headers
How to control the target frame of reporting services (SSRS) drill down
Set a table's visibility to false when it has no rows (in reporting services)
How do I best display CheckBoxes in SQL Server Reporting Services?
How to set sql profiler to profile SQL 2005 reporting services
3rd party controls for MS SQL 2005 Reporting Services
How do you view SQL Server 2005 Reporting Services reports from ReportViewer Control in DMZ
SQL 2005 Reporting Services custom report item (CRI) - what are the limits?