1

I am using SSRS report 2008. My report was working fine suddenly he start taking very long while rendering. I check my query that is working fine and responding in 2, 3 sec but report takes up to 7,8 min to render. I have restart my BI tool and restart my machine but still getting same issue. Any idea how I can fix it? I search a lot from google but didn't found any suitable answer which can solve my problem.

Muhammad Rizwan Shahid
  • 153
  • 2
  • 6
  • 11
  • How are you getting the data to your report?, are you using a stored procedure? – Lamak Sep 12 '13 at 19:56
  • 1
    possible duplicate of [Fast query runs slow in SSRS](http://stackoverflow.com/questions/2283943/fast-query-runs-slow-in-ssrs) – bubbassauro Mar 24 '14 at 18:29

1 Answers1

0

Try rendering it in a different web browser. I'm assuming you are talking about when it is deployed to the server?

Also, sometimes there is an issue with the grouping of the data. So you might want to play around with the keep together and pagebreak options, for the report under the tablix member properties.

Sewder
  • 754
  • 3
  • 11
  • 37
  • I have not deployed yet. – Muhammad Rizwan Shahid Sep 12 '13 at 19:50
  • Some things I've tried inlcude: 1. Taking out the Order By and Sorting using SSRS instead of script. 2. Taking out filters and instead putting parameters into the query itself. 3. Making rows and columns as small as possible so the report has to generate less pages. – Sewder Sep 12 '13 at 20:10