Is it possible to know whether report is still executing in report viewer? (Web Forms)

Hi All,

I have a Report Viewer and a Exit button in Web Form. Untill the report is processed i don't want to enable the button.

so Is it possible to know whether report is still executing in report viewer ?

I am using Remote Mode.

Any help will be appreciated.

Thanks

Akash

YOu can use the asynchronous methods for rendering the report, if the report did not raise the event of finishing you can be sure that the report is already running.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am using HistoryID to generate the report so i can't use the asynchronous thing.

Below are the lines which are generating the report.

ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerPath"].ToString());

ReportViewer1.ShowParameterPrompts = false;

ReportViewer1.ServerReport.HistoryId = strHistoryID; -- Assigning HistoryID

ReportViewer1.ServerReport.ReportPath = strReportPath;

ReportViewer1.ServerReport.Refresh();

Report is rendering asynchronously from the rest of the web page.(i.e. Report Viewer AsyncRendering attribute is set to true)

Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any function

Anyone know? I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do? Is that any function in SMO package that can do this for me?Hi,

that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any func

Anyone know? I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do? Is that any function in SMO package that can do this for me?Hi,

that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql