locked
ReportViewer without strongly typed dataset RRS feed

  • Question

  • User-125438676 posted

    I am new to the ReportViewer control and I think I'm trying to do something that cannot be done.  The page itself is very simple, just a form with a control:
    <body>
        <form id="form1" runat="server">
        <div>
            <rsweb:reportviewer
                id="rvCapacityPlanning"
                width="800px"
                Font-Size="8pt"
                Height="600px"
                runat="server" />
        </div>
        </form>
    </body>I created a Dataset but canceled out of the configuration wizard and just added a DataTable with some columns.  In the code behind on my page I have the following:
        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

            'Set the processing mode for the ReportViewer to Local
            rvCapacityPlanning.ProcessingMode = ProcessingMode.Local
            Dim rep As LocalReport = rvCapacityPlanning.LocalReport
            rep.ReportPath = "rptCapacityPlanning.rdlc"
            Dim rds As New ReportDataSource

            rds.DataSourceId = "ObjectDataSource1"

            Dim EmployeeData As EmployeeData = GetSalesData()

            'Create a report data source for the sales order data
            Dim dsCapacityPlanning As New ReportDataSource
            dsCapacityPlanning.Name = "EmployeeData_Data"
            dsCapacityPlanning.Value = EmployeeData.Tables("Data")

            rvCapacityPlanning.LocalReport.DataSources.Clear()
            rvCapacityPlanning.LocalReport.DataSources.Add(dsCapacityPlanning)

        End Sub

        Private Function GetSalesData()
            Dim ds As New EmployeeData
            Dim oConn As New SqlConnection(GetConnectionString)
            Dim oCmd As New SqlCommand

            Dim iYear As Integer = 2008
            Dim sITCostCenter As String = ""
            Dim sWebUser As String = "a76211"

            With oCmd
                .Connection = oConn
                .CommandType = CommandType.StoredProcedure
                .CommandText = "sp_getProjectHoursByOrgByProjByEmployee"

                .Parameters.Add("@rptYear", SqlDbType.Int).Value = iYear
                .Parameters.Add("@ITCostCenter", SqlDbType.VarChar).Value = sITCostCenter
                .Parameters.Add("@webuser", SqlDbType.VarChar).Value = sWebUser

                Dim salesOrderAdapter As New SqlDataAdapter(oCmd)
                salesOrderAdapter.Fill(ds, "Data")
                salesOrderAdapter.Dispose()
                .Dispose()
            End With

            Return ds

        End Function
     When I try to run the report I get the following error:'A data source instance has not been supplied for the data source 'DataSet1_DataTable1'.I've been trying to re-do this all day and I just keep running into roadblocks.  The name of the DataSet, the one stored in App_Code, is also called EmployeeData.  Hoping someone has some input on this.TIA, N

    Wednesday, March 12, 2008 4:43 PM

All replies

  • User-2136750015 posted

    Hi,

          I am stuck with same problem. Could let me know how you solved your problem,

     

    Thank you

    Sunday, March 15, 2009 11:24 AM
  • User965011518 posted

    rvCapacityPlanning.LocalReport.DataSources.Add(dsCapacityPlanning)

    should be

    rvCapacityPlanning.LocalReport.DataSources.Add("Data", dsCapacityPlanning)

    Wednesday, March 7, 2012 6:44 AM