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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Rendering report from .NET

Author  Topic 

roy mm
Yak Posting Veteran

62 Posts

Posted - 2008-09-13 : 09:03:01
Hello.
I have a report that get a parameter (lets say "id").
The report take about 5 minuts to run.

I have an application in .Net that use the RS web services to render the report and save him as a pdf file.

The problem is that I need to render the report 20 time because the id parameter have 20 available values.

So it take me more then an hour and a half to do so.

Is there a way you think I can get pass that?

I thought about changing the the parameter to filter and then use a snap shot or something like that.
Maybe then after the report will run once, when I'll call him with the next parameter it will run a lot faster.

I'll be glad to hear your opinion about that.

Thanks.
   

- Advertisement -