SQL Server Reporting Services Help

Hey guys,

I've been completely lost on how to manage the SSRS. I actually managed to create the reports from "static" data inside of my database. Now i was trying to access or print this data from my VB.NET project and i have absolutelty no clue on how to do that.

I was also wondering if its possible to pass values from VB.NET to SSRS. Because basically i create a SQL in my vb.net with input variables that would be impossible to rebuild in the SSRS. So i was wondering if i could asign the values from this query into the SSRS instead of having to use the "static" database...........

Thx in advance for the help :thumb:

anyone?
Its been so hard to find info on this concerns >.<

Quote:

---

Originally Posted by super_nOOb

anyone?
Its been so hard to find info on this concerns >.<

---

This will provide you some example and movie.

@ shakti5385 - Thx a lot for the reply. Ive actually taken a big dig in this website already. That is basically how i managed to learn the SQL Server Reporting. I even learned how to use visual basic in it and all. But my problem is being the other way around. I didnt find ways to see or print or even pass parameters from VB.NET to SSRS. I mean, how to interact both...........And this i dont think they have on the microsoft website. Ive been in a goolge quest but with not much luck. This is all i found....but id does not help me a lot since im using the express edition

Visual Studio Integration
Q. How can I add Reporting Services reports to my application?

A.

Visual Studio 2005 (Standard and Enterprise editions) contains a set of freely redistributable Report Viewer controls that make it easy to embed Reporting Services functionality into custom applications. Two versions of the Report Viewer exist, one for rich Windows client applications and one for ASP.NET applications.
Q. Do I need a report server to run reports in my application?

A.

In addition to publishing reports to a report server, you can build reports using the Report Designer that is directly integrated with Visual Studio language projects. You can embed reports directly in any Windows Forms or ASP.NET Web application without access to a report server. The data access in embedded reports is a natural extension of the Visual Studio data facilities. Not only can you use traditional databases as a source of data for your reports, you can use object collections as well.

The closest thing i found was a Microsoft Report Viewer Redistributable 2005
here: http://www.microsoft.com/downloads/d...displaylang=en
But i couldnt manage to add in my project cuz it was not listed there :confused:

EDIT:
______________________________________________
Ok i just managed to add the reportviewer. Now im researching on how to add my report in the local server so i can get it in vb.net :D

i just cannot connect to http://localhost/reportserver >.<

this is the error

Code:

---

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

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

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

The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services)

------------------------------
Program Location:

  at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
  at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
  at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
  at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
  at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated()
  at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
  at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
  at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

---

EDIT:
Ok solved this one. Skype was using the port. I am now getting another error

Code:

---

A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)

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

Unable to connect to the remote server (System)

------------------------------
Program Location:

  at System.Net.HttpWebRequest.GetRequestStream()
  at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
  at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
  at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated()
  at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
  at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
  at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

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

No connection could be made because the target machine actively refused it (System)

------------------------------
Program Location:

  at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
  at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
  at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

---

Concerning the second error, i managed to fix it. Now the problem is that when i debug this in a ReporViewer in VB.NET i get the msg unable to connect to server..............oh boy this sux :cry:

I'm taking a new approach now
Does anyone know if its possible to change the textbox values of the report (report.rdlc) from VB.NET
If so do you have any sample codes for that???
And question 2, if its possible to do so is it also possible to manage a code to create a new page for the report (in case i use a FOR NEXT)

Thx in advance