Hi,
I an new to SQL Server reporting Services. I have deployed my report on win2k server and is working perfectly when run from report server. Now I want to run that report from my Win2000 client Using VB.NET.
Can any one have an idea how it will be done. I have no idea how to run that report from my win2k client and passing parameters from VB.NET programe to report on win2k server.
ANy sample code will be very helpfull
Thank you in Advance.
Shak
Running Parametrized report From VB.NET
rswipe
I just want to display the report on I.E by running my ASP.NET client, that is, my ASP.NET client could be able to access the report and display it in I.E. For this procedure ...where can I find the information.
Any help would be highly appreciated.
Shak
amirmira
Thank you for your response.
The method through which we can use Web Services by refrencing Web Services of SQL reporting service (you mentioned in first section) only return few properties of the report. I am looking to run the entire report by passing parameters and the report shud be open in Internet explorer.
I also have got an article in MSDN regarding the slotuion of this issue, but it gives me an error at the time I try to create this object :
Dim iex1 As New SHDocVw.InternetExplorer
Error states that "Access Denied: you don't have permission to acesss the resources"
Thank you
Shak
PremSamuel
There are different ways you can execute a report from a remote client.
1. Using Reporting Server WebService API you can execute reports from VB.NET client. Books Online has detailed instructions on this.
Read this chapter on BOL that has nice examples also
Accessing the Report Server Web Service Using Visual Basic or Visual C#
http://msdn2.microsoft.com/en-us/library/ms169926(SQL.90).aspx
2. You can deploy report viewer control in the VB.NET app which you can find at this location:
http://www.gotreportviewer.com/
Let me know if you need more details
Best Regards
Uday Hegde