is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck

is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck|||

Hi;

I am working on report view of a web form. I am looking for some event can fire after a report rendering. I only find a RendingComplete event of report viewer in a window form. But I could not find a similarly enent in the web form. Could some one help me?

Jennifer Xu

Is it possible to customize the look of the parameters form?

Hi all...
When a report is viewed in web browser, a parameters form appear at the top
of the screen so that user can enter parameters and then press View Report.
Is it possible to display a title before that form? or to customize the
colors and fonts for that form?
Thanks
JaimeHave the SAME question!! =:)
"Jaime Stuardo" wrote:
> Hi all...
> When a report is viewed in web browser, a parameters form appear at the top
> of the screen so that user can enter parameters and then press View Report.
> Is it possible to display a title before that form? or to customize the
> colors and fonts for that form?
> Thanks
> Jaime|||You can adjust the colours of the parameters form by changing the
htmlviewer.css stylesheet. Supposedly if you have installed the hot fix for
sp2 then you should find a proptery called htmlviewrstylesheet which you can
set to any style sheet you have created to be th edefault for all reports but
I havent found this.
so in the url of the reports when they are called from another web page I
use the command rc:Stylesheet=stylesheetname
"=:)" wrote:
> Have the SAME question!! =:)
> "Jaime Stuardo" wrote:
> > Hi all...
> >
> > When a report is viewed in web browser, a parameters form appear at the top
> > of the screen so that user can enter parameters and then press View Report.
> >
> > Is it possible to display a title before that form? or to customize the
> > colors and fonts for that form?
> >
> > Thanks
> > Jaime|||IS there a way of hiding the parameters completely as I dont want to
allow the users to change the parameters.
Sorry for the dumb question but this is my 2nd day on reporting
services and i'm trying to get to grips with it very quickly|||Hi Jim,
&rc:Parameters=False is an option.
(have a look here:
http://weblogs.asp.net/mhawley/archive/2004/11/17/259178.aspx for more).
HTH,
Ed Richard
"JimW13UK" <jimw13uk@.uku.co.uk> wrote in message
news:1120725823.751966.67920@.g14g2000cwa.googlegroups.com...
> IS there a way of hiding the parameters completely as I dont want to
> allow the users to change the parameters.
> Sorry for the dumb question but this is my 2nd day on reporting
> services and i'm trying to get to grips with it very quickly
>|||Thanks Ed. The link you posted has answered my question. I can program my
custom parameter form using either VB.NET or C# and using ReportViewer
control to actually show the report.
Jaime
"Ed Richard" wrote:
> Hi Jim,
> &rc:Parameters=False is an option.
> (have a look here:
> http://weblogs.asp.net/mhawley/archive/2004/11/17/259178.aspx for more).
> HTH,
> Ed Richard
> "JimW13UK" <jimw13uk@.uku.co.uk> wrote in message
> news:1120725823.751966.67920@.g14g2000cwa.googlegroups.com...
> > IS there a way of hiding the parameters completely as I dont want to
> > allow the users to change the parameters.
> > Sorry for the dumb question but this is my 2nd day on reporting
> > services and i'm trying to get to grips with it very quickly
> >
>
>

Is it posiable to close the screen

Hai

Is it possiable to close the current connection screen in the query
analyser , not to close the query analyser.

With Thanks
RaghuControl+F4 or click the window close button.

--
David Portas
SQL Server MVP
--

"Raghuraman" <raghuraman_ace@.rediffmail.com> wrote in message
news:66c7bef8.0402150118.44139866@.posting.google.c om...
> Hai
> Is it possiable to close the current connection screen in the query
> analyser , not to close the query analyser.
> With Thanks
> Raghu|||
Dear Portas

Thanks for your suggestions. Actually i meant that query thru code .

Eg

The shutdown command(sql server7.0) removes the network connection from
sqlserver.Like wise is there any command to close the current screen of
the query analyser.

With thanks
Raghu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||No. Transact SQL isn't an application development language - it doesn't
control the client GUI at all.

Use another language to execute your SQL or, if you want to run some batched
process without a GUI, run the OSQL utility from the OS command line.

--
David Portas
SQL Server MVP
--