Hi I am getting the following error message when using drillthrough and
jump to another report in the same reportviewer.
Error message:
A Datasource instance has not been supplied for the data source
'DataSetProductDetail_ShowProductByProductID'
-------------------------------------
MyCode:
Protected Sub DemoDrillthroughEventHandler(ByVal sender As Object,
ByVal e As DrillthroughEventArgs) Handles ReportViewer1.Drillthrough
Dim drillthroughReport As LocalReport = CType(e.Report, LocalReport)
Dim MydataSet As DataSet = New DataSet()
Dim thisConnection As SqlConnection = New
SqlConnection(ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString)
Dim myCommandDataAdapter As SqlDataAdapter = New
SqlDataAdapter("DataSetProductDetail_ShowProductByProductID",
thisConnection)
myCommandDataAdapter.SelectCommand.CommandType =
CommandType.StoredProcedure
myCommandDataAdapter.SelectCommand.CommandText =
"ShowProductByProductID"
myCommandDataAdapter.SelectCommand.Parameters.Add(New
SqlParameter("@ProductID", 2))
myCommandDataAdapter.Fill(MydataSet,
"DataSetProductDetail_ShowProductByProductID")
'Associate thisDataSet(now loaded with the stored procedure
result)
'with the ReportViewer datasource
Dim datasource1 As ReportDataSource = New
ReportDataSource("DataSetProductDetail_ShowProductByProductID",
Mydataset.Tables(0))
ReportViewer1.LocalReport.DataSources.Clear()
ReportViewer1.LocalReport.DataSources.Add(datasource1)
ReportViewer1.LocalReport.Refresh()
End Sub
---------
Any ideas?
[quoted text, click to view] dagha wrote:
> Do you still have these problems by viewing a new report in the same
> reportviewer control after you activate a "jump to report" in the original
> report (Me too....)
>
> I will try to experiment more with it this evening.
>
> Do somebody already have an answer
> --
> Regards
> dagha
>
>
> "hurst.andy@gmail.com" wrote:
>
> > I've searched and searched and can't find how to do this.
> >
> > I've got a main report and a report that I am trying to use the 'Jump
> > to' ability with. I am capturing the ReportViewer1.DrillThrough event
> > and am doing this:
> >
> > ReportViewer1.LocalReport.DataSources.Add(New
> > ReportDataSource("JobApplications_ApplicantDetails",
> > LoadApplicantDetailsData()))
> >
> > I have set this report as the 'main' report that runs in the viewer
> > when it first loads and it works correctly but just not when 'jumped
> > to'. I have removed all parameters that need to be passed to the
> > report so there is nothing missing there.
> >
> > This is the actual error I recieve:
> > A data source instance has not been supplied for the data source
> > 'JobApplications_ApplicantDetails'.
> >
> > Any help is greatly appreciated.
> > Thanks
> >
> >
