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 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 hide the report parameters after click on the view report button?

i am working in SQL Reporting services 2005. i had a requirement that
after selecting all the report paramters and click on the view report
button, i need to turn off or hide the report parameters.
please let me know is it possible to implement to do this.
any suggesstion
Thanks
VinodThere is a button the right side of the page of the reports browser
that look like to arrows on top of each other, click that and it will
hide the parameters. There are actually two sets, one for the
parameters and one for the web page header. Hope that helps.
Vinod wrote:
> i am working in SQL Reporting services 2005. i had a requirement that
> after selecting all the report paramters and click on the view report
> button, i need to turn off or hide the report parameters.
> please let me know is it possible to implement to do this.
> any suggesstion
> Thanks
> Vinod|||Thanks for the reply Kerrie.
i have seen the hide button icon in the report layout.but my
requirement is that i need to hide the parameters when i click on the
view report button in the report layout after selecting the all the
report parameters.
if user wants to modify the criteria again, he needs to click on the
hide icon in the report layout. then select the criteria and view the
report.
please let me know if you are not clear
Thanks
vinod
Kerrie wrote:
> There is a button the right side of the page of the reports browser
> that look like to arrows on top of each other, click that and it will
> hide the parameters. There are actually two sets, one for the
> parameters and one for the web page header. Hope that helps.
>
> Vinod wrote:
> > i am working in SQL Reporting services 2005. i had a requirement that
> > after selecting all the report paramters and click on the view report
> > button, i need to turn off or hide the report parameters.
> >
> > please let me know is it possible to implement to do this.
> >
> > any suggesstion
> >
> > Thanks
> > Vinod|||I'm pretty sure there's no function like that in RS out of the box. But I'm
thinking that if you can modify the View Report button's code, you could add
a java script that redirects to a url with parameters toolbar=false and the
chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
how easy that is.
Alternatively, create a aspx. page that creates the parameters to be chosen,
and send the users to a report using the same paramtererized url as
suggested above.
Kaisa M. Lindahl Lervik
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> Thanks for the reply Kerrie.
> i have seen the hide button icon in the report layout.but my
> requirement is that i need to hide the parameters when i click on the
> view report button in the report layout after selecting the all the
> report parameters.
> if user wants to modify the criteria again, he needs to click on the
> hide icon in the report layout. then select the criteria and view the
> report.
> please let me know if you are not clear
> Thanks
> vinod
>
> Kerrie wrote:
>> There is a button the right side of the page of the reports browser
>> that look like to arrows on top of each other, click that and it will
>> hide the parameters. There are actually two sets, one for the
>> parameters and one for the web page header. Hope that helps.
>>
>> Vinod wrote:
>> > i am working in SQL Reporting services 2005. i had a requirement that
>> > after selecting all the report paramters and click on the view report
>> > button, i need to turn off or hide the report parameters.
>> >
>> > please let me know is it possible to implement to do this.
>> >
>> > any suggesstion
>> >
>> > Thanks
>> > Vinod
>|||Thanks for the reply Kaisa.
i am not creating a aspx page for criteria. i have added 15 report
parameters in the report layout iteself. everything is fine upto this
point.
but my client requriment is that we dont want to show the report
parameters in the report layout after clicking on the view report
button. it should be hided.
let me know is it possible.
Thanks
Vinod
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure there's no function like that in RS out of the box. But I'm
> thinking that if you can modify the View Report button's code, you could add
> a java script that redirects to a url with parameters toolbar=false and the
> chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
> how easy that is.
> Alternatively, create a aspx. page that creates the parameters to be chosen,
> and send the users to a report using the same paramtererized url as
> suggested above.
> Kaisa M. Lindahl Lervik
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> > Thanks for the reply Kerrie.
> >
> > i have seen the hide button icon in the report layout.but my
> > requirement is that i need to hide the parameters when i click on the
> > view report button in the report layout after selecting the all the
> > report parameters.
> >
> > if user wants to modify the criteria again, he needs to click on the
> > hide icon in the report layout. then select the criteria and view the
> > report.
> >
> > please let me know if you are not clear
> >
> > Thanks
> > vinod
> >
> >
> > Kerrie wrote:
> >> There is a button the right side of the page of the reports browser
> >> that look like to arrows on top of each other, click that and it will
> >> hide the parameters. There are actually two sets, one for the
> >> parameters and one for the web page header. Hope that helps.
> >>
> >>
> >> Vinod wrote:
> >> > i am working in SQL Reporting services 2005. i had a requirement that
> >> > after selecting all the report paramters and click on the view report
> >> > button, i need to turn off or hide the report parameters.
> >> >
> >> > please let me know is it possible to implement to do this.
> >> >
> >> > any suggesstion
> >> >
> >> > Thanks
> >> > Vinod
> >

Is it possible to fire a WinForms app from SSRS?

Heya,

Imagine I've got a report with an 'Edit' button to the right of each record.

When the button gets clicked, I'd like to fire a WinForms app on the remote computer.

Is this possible? I'm thinking that I'd have to use the ReportViewer control, but I'm not sure...

Thanks for the insight.

Justin

One way you can accomplish this is to add hyperlink navigation to your "Edit" textbox. It can call a web page and pass in information identifying the data the user wants to edit. You can then either edit that information on a web page and redirect back to a refreshed view of the report. If you want a WinForms app, you can have that web page fire off a .net application (like we do with Report Builder), an embedded activex control, or an external application.

Thanks, Donovan.

Is it possible or Is it too much ?

Hi,
This is what i want to do. Is it possible ?
I have a report1 with a textbox button - and a table with 10 rows. when the
user clicks on the textbox button - it should open another report - report2 -
IN ANOTHER BROWSER. report2 takes filter values and has a close button - when
close button is clicked it has to close and come back to REPORT1 with data
passed to table on report1 .
Is it too much ?
RPTake a look at
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=fcfb2f99-9acf-4374-b939-42811f321d66
It's not a complete solution (you can't return to you first window), I think
that is also possible because the window.open method returns a pointer to the
window. So if you could store that in a global variable of some custom code,
I presume you coukd return to the origanl window. I'm not good enough with
VB.Net to pull that off. I hope somebody can tell me how to do it.
Hope this helps
"RP" wrote:
> Hi,
> This is what i want to do. Is it possible ?
> I have a report1 with a textbox button - and a table with 10 rows. when the
> user clicks on the textbox button - it should open another report - report2 -
> IN ANOTHER BROWSER. report2 takes filter values and has a close button - when
> close button is clicked it has to close and come back to REPORT1 with data
> passed to table on report1 .
> Is it too much ?
> RP