SSRS reports are very slow

i have generated SSRS reports... the report takes very long time to generate(around 1 minute).. the stored procedure runs very fast(less than a second)..
and i have one paramter for the stored procedure..
there is no problem with the stored procedure..it runs very fast.. its the problem with ssrs..
why does it run so slow??
gautam_reddycAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tim HumphriesDirectorCommented:
Hi,

What is the nature of the parameter you have - are you populating a drop down list for users to select from?

If so, and there are a lot of items in the list, that could be your problem.

Tim
0
blandyukCommented:
Only issue I encounter with SSRS is when it first starts, it takes awhile to load but once done, it's normally ok. As above, how much information is this report holding?
0
Tim HumphriesDirectorCommented:
@blandy - yes, this can be caused by IIS being a bit rubbish. Hence the move away from IIS as a hosting platform in 2008.
Re 'info that report is holding' - you're thinking that maybe the rendering time is high?


Tim
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

gautam_reddycAuthor Commented:
the report is holding lot of records.. when i modified the records to retrieve top 100 rows and parameter to display top 10 values..it is rendering in 2-3 seconds..
what should i do to display 1000 records.. i found some articles on internet mentioning about 'parameter sniffing'.. i didnt make much of a difference
0
gautam_reddycAuthor Commented:
Tim,
  Yes, there are lot of items in the drop down list... how do you work around that?
0
Tim HumphriesDirectorCommented:
Very difficult...if you can categorise your list you can provide multiple parameters - a 'top level' that provides high level filtering on he parameter, which then restricts lower level lists. However, this doesn't work well if you want the users to be able to select multiple items across different categories.
Other than building your own parameter picker code, and hosting the report in a different (i.e. not Reporting Services) front end, your options are limited.

Tim
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gautam_reddycAuthor Commented:
Tim,
  Thanks for the info.. will try to host the reports in ASP.NET using the Report Viewer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.