ReportViewer & custom datasource

Ok I tried using Server.MapPath and it made no difference.  I don't understand why I'm not seeing the actual control when I load the page.  Its just blank.  No error, no report viewer...

Oh my mistake. I did not notice that you are creating the reportviewer programmatically. Any particular reason? You may try using the me.Controls.Add(ReportViewer1) but i think it wont render. Try adding the report viewer to the page at design time.

Ah...something so simple.  Ok that seemed to work.  Now I just see this error:  Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

Remove this line
Me.Page.DataBind()


Cant think of any other reason for this error. Never heard of it.

It's a problem with the report url or path.  I thought I had the correct URL and reportpath but now its trying to look in the wwwroot for the reportfolder and report.

Where is the report saved?

It's published to my reportserver.

 ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://IP/ReportServer/Pages/ReportViewer.aspx?/")
 ReportViewer1.ServerReport.ReportPath = Server.MapPath("foldername/reportname")

when I use http://myip/ReportServer/Pages/ReportViewer.aspx?/foldername/reportname

I get the actual report rendered.  However, inside the reportviewer I keep getting that error.

Did you try removing the Server.Mappath?

Yes, still gives the same error.

I think you can just set the ReportSource of the viewer.

http://www.beansoftware.com/ASP.NET-Tutorials/Using-Crystal-Reports.aspx

This is for a sql reporting services setup, not Crystal.

Ok using that example I got the report to load after one other problem.  
Me.Controls.Add(ReportViewer1) had to be changed to
form1.Controls.Add(ReportViewer1)

Seems it didn't add the reportviewer inside the form tag which has runat=server.  Threw some odd error.  Got that fixed!

Ok with that finally working we can focus on my original question.  Each folder on the reportserver (just 2 folders) has a datasource setup for each of my clients.  How do I switch between different datasources depending on which client is viewing the site?

ReportViewer1.ServerReport.Datasources.add("datasourcename") doesn't exist like it does for "LocalReport".  The only info I can find on this is to setup the report to allow a parameter to be passed with the datasrouce info.  Is that correct?  How do I set this up in my code-behind?  I've also never set a parameter in a report to ask for datasource info...

Try the following links

http://forums.asp.net/p/1251074/2320892.aspx#2320892

http://bytes.com/topic/net/answers/760778-programmatically-deploy-sql-server-2005-reports-datasource



http://www.dotnetheaven.com/UploadFile/ursbgiri/106012007065515AM/1.aspx

http://codebetter.com/blogs/peter.van.ooijen/archive/2005/11/15/Using-SQL-reporting-services-in-an-asp.net-application-with-some-notes-on-report-parameters.aspx

The first two seem the most helpful but I can't seem to get the class correct.

Dim dDefinition As New ReportingService2005.DataSourceDefinition()  is not recognized.  

Make sure you add the proper import statements

http://msdn.microsoft.com/en-us/library/aa257615%28SQL.80%29.aspx

I'm confused.  I can't seem to find these statements.  Do I need to add a reference to a specific dll?  I can't find any reportingservice dll even though I have a full install of sql08 and RS08.

The example at following link has this import
Imports System.Web.Services.Protocols

http://msdn.microsoft.com/en-us/library/aa225833%28SQL.80%29.aspx

Even including that I still get problems with their sample.  

This is what I used:
' Create datasource for the report.
        Dim name As String = "dbname"
        Dim parent As String = "/"
        Dim rs As New ReportingService()
        rs.Credentials = System.Net.CredentialCache.DefaultCredentials
        Dim definition As New DataSourceDefinition()
        definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
        definition.ConnectString = "data source=192.168.0.103;initial catalog=" & strclientid
        definition.Enabled = True
        definition.EnabledSpecified = True
        definition.Extension = "SQL"
        definition.ImpersonateUserSpecified = False
        'Use the default prompt string.
        definition.Prompt = Nothing
        definition.WindowsCredentials = False
        rs.CreateDataSource(name, parent, False, definition, Nothing)

It's still having trouble with DataSourceDefinition() and CredentialRetrievalEnum.Integrated and CreateDataSource.  I must be missing something entirely...

Any ideas?  I'm certainly just missing a reference to a certain class but I can't seem to find it.

I dont know what's wrong. I have seen this class being used in almost all examples.

Should I have the entire section above wrapped in that class?

Refer to the examples and read the articles to see if there is any description of the class.

So am I supposed to just add that sub like so:

Public Sub CreateDataSource( _
   ByVal DataSource As String, _
   ByVal Parent As String, _
   ByVal Overwrite As Boolean, _
   ByVal Definition As [Namespace].DataSourceDefinition, _
   ByVal Properties() As [Namespace].Property _
)
   Member of [Namespace].ReportingService
    End Sub

What exactly is [Namespace] supposed to be?  Sorry, I've never used "member of" before.

I tried creating this just above my main class already in use:

Class MyNameSpace
    Public Shared Sub Main()
        Dim rs As New ReportingService()
        rs.Credentials = System.Net.CredentialCache.DefaultCredentials

        Dim name As String = "AdventureWorks"
        Dim parent As String = "/"

        ' Define the data source definition.
        Dim definition As New DataSourceDefinition()
        definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
        definition.ConnectString = "data source=(local);initial catalog=AdventureWorks"
        definition.Enabled = True
        definition.EnabledSpecified = True
        definition.Extension = "SQL"
        definition.ImpersonateUserSpecified = False
        'Use the default prompt string.
        definition.Prompt = Nothing
        definition.WindowsCredentials = False

        Try
            rs.CreateDataSource(name, parent, False, definition, Nothing)

        Catch e As SoapException
            Console.WriteLine(e.Detail.InnerXml.ToString())
        End Try
    End Sub
    Sub CreateDataSource( _
       ByVal DataSource As String, _
       ByVal Parent As String, _
       ByVal Overwrite As Boolean, _
       ByVal Definition As MyNameSpace.DataSourceDefinition, _
       ByVal Properties() As MyNameSpace.Property _
    ) Member of MyNameSpace.ReportingService
    End Sub
End Class

This is a copy/paste of the example basically.  I'm not sure if I used it correctly since it doesn't recognize "MyNameSpace" or "member of".  It also still doesn't recognize DataSourceDefinition making me think I still don't have the correct reference.

http://msdn.microsoft.com/en-us/library/aa258104(SQL.80).aspx

I'm thinking that's what I need to use since the datasources already exist on the reporting server.

Ok I found out why I was having trouble referencing ReportingService().  For some reason my 2008 RS server doesn't have the dll I have to reference.   So I did web reference and connected to one of our 2005 RS servers and found the dll there and added it to my project.  Now those examples don't give me errors.

So after changing things like the version from 8.0 to 9.0 I don't see any errors.  However when I try to load the webform I get an error:

Compiler Error Message: BC30002: Type 'ReportingService' is not defined.

Source Error:

 

Line 18: Class Sample
Line 19:     Public Shared Sub Main()
Line 20:         Dim rs As New ReportingService()
Line 21:         rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Line 22:
 

Source File: C:\inetpub\wwwroot\New\GM\GM.aspx.vb    Line: 20


Odd it doesn't show this in the actual developer.  I'm still not sure how to set the report to use a specific datasource.

If you mix up 2005 and 2008 references then you would create further problems. It appears to me that this particular namespace has been removed from the 2008 version or has been reengineered. Try using the 2005 version of all the DLLs.

Well I added the 2005 web reference and changed all the references to it to version 9.0 and it gives the same error.  When I change all references to 8.0 I get the 'ReportViewer' is ambiguous in the namespace 'Microsoft.Reporting.WebForms'  error.  Not sure why this is happening now.

The ambiguity is because of the version conflicts. There are now 2 reportviewers one from 2005 and one from 2008. I suggest you read the articles i linked above and try to bottom out the issue by refering to examples.

I've gone over the examples a lot.  I've tried changing versions with no luck.  I also don't see any duplicate references.  Not sure how to find this any easier.  I only added the dll reference once.  I'm using VS08 so I'm sure the reportviewer control I added is causing this but I'm not sure how to fix it.

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

That's whats on my aspx page.  The webconfig also contains references to the same assembly.  Switching them between 8 and 9 just gives me the same errors.  I don't see any othere references anywhere but I'm not sure where to look.

I am out of suggestios now to be honest.

Well I've gone through the entire project and made sure it was version 8.  I still get this error:

Compiler Error Message: BC30002: Type 'ReportingService' is not defined.

Source Error:

 

Line 18: Class Sample
Line 19:     Public Shared Sub Main()
Line 20:         Dim rs As New ReportingService()
Line 21:         rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Line 22:         Dim reference As New DataSourceReference()
 

Source File: C:\inetpub\wwwroot\New\GM\GM.aspx.vb    Line: 20

I'm not sure what else to do at this point.

I added the web reference to the 2005 RS server.  "reportservice.wsdl"  Then added the code below.  I don't get any errors till I actually load the aspx page.

Imports ReportingServices
Class Test
    Public Shared Sub Main()
        Dim rs As New ReportingService()
        rs.Credentials = System.Net.CredentialCache.DefaultCredentials
        Dim reference As New DataSourceReference()
        reference.Reference = "/myfolder"
        Dim dataSources(1) As DataSource
        Dim ds As New DataSource()
        ds.Item = CType(reference, DataSourceDefinitionOrReference)
        ds.Name = "MyDS"
        dataSources(0) = ds
    End Sub
End Class

I'm awarding points since you definately helped me fix one of my original problems.  I'm out of ideas for the rest of the issues so I'm going to open another question in hopes of getting some more responses.  Thanks!

Thanks for awarding the points and apologies for not being able to solve the big problem.