ReportingServices2000 and RS2005 client report desgin tools?

We have a project that is going to report from a sql2000 server utilizing
Reporting Services(RS). So the natural thing to use is RS2000, (i assume
based on licensing). I am confused concerning client report development
tools for each version.
For RS2000 -
1) The designer requires some version of 2003.net (vb,vs,etc..)?
2) One cannot use RS2005 tools?
For RS2005
1) Does this require VS2005?
2) Is there a tool built into the Sql Studio Management suite that can be
used instead of VS2005?
3) What about using 2003.net, is this an option?
TIA
CDRS 2000. True
RS 2005: It comes with a version of VS 2005 for the designer so no
additional purchase/install necessary. If you have VS 2005 installed it will
install in that but otherwise it installs a version just for the designer.
And, no, vs 2003 will not work.
RS 2000 is 1.1 framework and RS 2005 is 2.0 framework which is a big reason
for the VS version dependency.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:eHLxnSTPGHA.1460@.TK2MSFTNGP10.phx.gbl...
> We have a project that is going to report from a sql2000 server utilizing
> Reporting Services(RS). So the natural thing to use is RS2000, (i assume
> based on licensing). I am confused concerning client report development
> tools for each version.
> For RS2000 -
> 1) The designer requires some version of 2003.net (vb,vs,etc..)?
> 2) One cannot use RS2005 tools?
>
> For RS2005
> 1) Does this require VS2005?
> 2) Is there a tool built into the Sql Studio Management suite that can be
> used instead of VS2005?
> 3) What about using 2003.net, is this an option?
> TIA
> CD
>

Reportingservice2005 is not defined, Please how to webreference it

I have rs2005 on my machine, how can i do the webreference to Reportingservice2005.asmx

Dim rs As New ReportingService2005

I am getting an error when i am using the above dim statement, it says reportingservice2005 is not defined.

Please help thank you very much.

Where are you calling the web service from?

If it's from a VS solution (Web or forms) then you need to add the web reference there so it can create the proxy file.

|||

To add a Web Reference in Visual Studio follow the steps listed on MSDN:
http://msdn2.microsoft.com/en-us/library/d9w023sx.aspx

The Url of the ReportingService2005.asmx will be in the ReportServer virtual directory, which is installed by default at http://<servername>/reportserver/reportingservice2005.asmx. If the ReportServer Url was changed you can find it by using the Reporting Services Configuration app.

HTH, Jason Tremper

|||

Hello Jason,

I am using VS 2003 with RS 2005, and trying to webreference Reportingservice2005, but i don't find it

i do find just reportservice.asmx instead,

I used the reportingservice.asmx and it does work without anyproblem, but the report does'nt get displayed at all am i doing something wrong:

here is my code:

Dim rs As New ReportingService

Dim LogonCredentials As System.Net.NetworkCredential

Dim Items As CatalogItem

LogonCredentials = New System.Net.NetworkCredential("username", "password", "mydomainname")

rs.Credentials = LogonCredentials

'rs.Credentials = System.Net.CredentialCache.DefaultCredentials

rs.PreAuthenticate = True

' Render arguments

Dim result As Byte() = Nothing

Dim reportPath As String = "/PCSnetReports/StatusReport"

Dim format As String = "MHTML"

Dim historyID As String = Nothing

Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"

' Prepare report parameter.

Dim parameters(1) As ParameterValue

parameters(0) = New ParameterValue

parameters(0).Name = "eStatus"

parameters(0).Value = "All"

parameters(1) = New ParameterValue

parameters(1).Name = "UserName"

parameters(1).Value = "johnsmith" ' June

Dim credentials As DataSourceCredentials() = Nothing

Dim showHideToggle As String = Nothing

Dim encoding As String

Dim mimeType As String

Dim warnings As Warning() = Nothing

Dim reportHistoryParameters As ParameterValue() = Nothing

Dim streamIDs As String() = Nothing

Dim sh As New SessionHeader

rs.SessionHeaderValue = sh

Try

result = rs.Render(reportPath, format, historyID, devInfo, parameters, _

credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)

sh.SessionId = rs.SessionHeaderValue.SessionId

Console.WriteLine("SessionID after call to Render: {0}", rs.SessionHeaderValue.SessionId)

Console.WriteLine("Execution date and time: {0}", rs.SessionHeaderValue.ExecutionDateTime)

Console.WriteLine("Is new execution: {0}", rs.SessionHeaderValue.IsNewExecution)

Catch e1 As SoapException

Console.WriteLine(e1.Detail.OuterXml)

End Try

' Write the contents of the report to an MHTML file.

Try

Dim stream As FileStream = File.Create("report.mhtml", result.Length)

Console.WriteLine("File created.")

stream.Write(result, 0, result.Length)

Console.WriteLine("Result written to the file.")

stream.Close()

Catch e2 As Exception

Console.WriteLine(e2.Message)

End Try