Render report via web service, graph not shown

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Render report via web service, graph not shown

Author

Topic

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2005-03-25 : 08:40:02

Hi, i am a bit of a newbie to SQL RS and I am building my first app. I have built a basic report which has a table and a pie chart. I have two problems.

Problem 1
The report has a drill down table that is displayed perfectly in my aspx page (eg, http://localhost/test.aspx) however when I go to drill down into the table the page jumps my RS server (http://server-sql/myreports/testReport) How can I prevent this from happening? I only want to expose my web server and not my sQL server?

Problem 2
I am rendering the report using a web service, teh table of teh report shows fine however the pie chart is not displayed, it shows it as missing image (you know when you get a small red x instead of the image). Im not to sure what im doing wrong, is it a mime problem. I have included a my code below:

' Create Web proxy object and set credentials
Dim rs As New ReportingService
Dim reportCredentials As New System.Net.NetworkCredential("userx", "passwordx")
rs.Credentials = reportCredentials

Dim path As String = "/nsdReports/SearchTypes"
Dim format As String = "HTML4.0"
Dim parameters As ParameterValue()
Dim encoding As String
Dim mimeType As String
Dim parametersUsed As ParameterValue()
Dim warnings As Warning()
Dim streamIds As String()

' Render the report as an HTML4.0 fragment using the Web service
Dim results As [Byte]()
rs.Url = "http://server-sql/reportserver/reportservice.asmx"

results = rs.Render(path, format, Nothing, Nothing, parameters, _
Nothing, Nothing, Nothing, "text/html", parametersUsed, _
warnings, streamIds)

Response.BinaryWrite(results)

Im sorry about the lengthy post, but your help would be much appreciated.

Thanks in advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources