all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Setting Reference?


Setting Reference? Wayne Wengert
10/29/2005 4:40:45 AM
sql server reporting services: I have just starting to try to use RS and I have some questions. (My
development environment is VS 2003/VB). I use a shared hosting service for
SQL Server 2000 with RS. I built a report in VS 2003 and deployed it to the
RS server I am assigned. Now I want to view that report from a web page. The
instructions I found at the ISP are shown below. I have these quesstions:
- How do I create the "web service proxy class"? I don't understand what
they want?
- What "Imports" do I need to add? (the "ReportinService" is flagged as
undefined?

I appreciate any pointers to help me figure this out.

Wayne

============================================
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
' You must create the web service proxy class to point to
' https://rs.myisp.net/ReportServer/reportservice.asmx
' before using this code

Dim rs As New ReportingService()

rs.Credentials = New
System.Net.NetworkCredential("<report_username>", "<report_password>", "")

Dim results As Byte(), image As Byte()
Dim streamids As String(), streamid As String

' Render the report to HTML4.0

results = rs.Render("/<path_to_report>", "HTML4.0", _
Nothing,
"<DeviceInfo><StreamRoot>/WebApplication1/</StreamRoot></DeviceInfo>",
Nothing, _
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)

Response.BinaryWrite(results)

End Sub


================================================

Got it Working Wayne Wengert
10/30/2005 3:44:14 AM
I found a couple of items via Google that explained the process of setting
up the Proxy. I realize now that once I defined and referenced thew proxy,
the references are o longer undefined.

Wayne

[quoted text, click to view]

AddThis Social Bookmark Button