Repot Manager Hangs

This happens very frequently on our server and I can't determine the cause.
The basic issue is that SRs gets into a state where it hangs, you can't
render reports,you can't even vire proprties, navigate folder etc, so I know
its not extenal data sources.
One things I tried was disabling Script Blocking which was enabled on our
antivirus. This is mentioned in this Kb:
http://support.microsoft.com/kb/295375/en-us
I also set the IIS Idle rest to 8 hours. But that wasn't the initial issue.
I've been looking at perfmon (thread counts, pages\sec, disk queues, working
set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
I appreciate any addiional info on things to try.
Thanks,
-pWhat version?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> This happens very frequently on our server and I can't determine the
> cause.
> The basic issue is that SRs gets into a state where it hangs, you can't
> render reports,you can't even vire proprties, navigate folder etc, so I
> know
> its not extenal data sources.
> One things I tried was disabling Script Blocking which was enabled on our
> antivirus. This is mentioned in this Kb:
> http://support.microsoft.com/kb/295375/en-us
> I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> issue.
> I've been looking at perfmon (thread counts, pages\sec, disk queues,
> working
> set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> I appreciate any addiional info on things to try.
> Thanks,
> -p|||SQL 2005 w/ latest SPs and fixes.
"Bruce L-C [MVP]" wrote:
> What version?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
> news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> > This happens very frequently on our server and I can't determine the
> > cause.
> > The basic issue is that SRs gets into a state where it hangs, you can't
> > render reports,you can't even vire proprties, navigate folder etc, so I
> > know
> > its not extenal data sources.
> >
> > One things I tried was disabling Script Blocking which was enabled on our
> > antivirus. This is mentioned in this Kb:
> > http://support.microsoft.com/kb/295375/en-us
> >
> > I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> > issue.
> >
> > I've been looking at perfmon (thread counts, pages\sec, disk queues,
> > working
> > set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> >
> > I appreciate any addiional info on things to try.
> >
> > Thanks,
> > -p
>
>

ReportViewer.Format?

is this not available in the SRS 2005? is there no way to set the report format using code behind?

thanks.

is this a local or remote report?|||

remote report.

in the 2000 version, it was simply ReportViewer.Format. Now, unless i'm missing something obvious, I cannot find this property.

thanks for any help.

|||

If you are using the reportviewer control in 2005 and you wish to control the output in code behind, your syntax would be something like...

ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri([url of report server]); //if you want to override the control properties
ReportViewer1.ServerReport.ReportPath = "report path and report name"; //if you want to override the control properties
ReportViewer1.ServerReport.SetParameters(paramList); // if you have parameters...

byte[] result = ReportViewer1.ServerReport.Render("EXCEL", null, out mimeType, out encoding, out extension, out streamids, out warnings);

Good Luck!

|||excellent! that worked great. thanks so much.