Reportviewer A data source instance has not been supplied for subreport

[KimberlyLord]

I have created a report and subreport in VB/ASP.NET. The report works fine but the subreport will not display. The subreport, when displayed as a standalone report, works fine. But when viewed as a subreport I get the error that the datasource for the subreport is missing.
I set a breakpoint in the sub that should set the subreport's datasource and the breakpoint is never hit. I have added a handler like shown in many examples. Why is the subreportproces sing event never firing? I have spent days trying to figure this out but most examples refer to the WinForms.Report Viewer and
none to the WebForms.Report Viewer. I have never found a complete webforms example using a subreport.
Any help would be greatly appreciated,
Kim

[adunn]

This may just be a configuration issue. Check your subreport's Data Sources. The report designer seems greedy and grabs all available datasources. Delete the ones you don't need, and you should be good to go.

[sivakumarcse]

Hi Try this , will work for you...


public partial class _Default : System.Web.UI.P age
{
int ordno = 134085104;
string thisConnectionS tring = "server=.;initi al catalog=vivotec h;uid=sa;pwd=sq l";
SqlConnection thisConnection = new SqlConnection(t hisConnectionSt ring);
protected void Page_Load(objec t sender, EventArgs e)
{
ReportViewer1.V isible = true;

thisConnection. Open();
{
SqlCommand cm = new SqlCommand("Viv o_Report", thisConnection) ;
cm.CommandType = CommandType.Sto redProcedure;
cm.Parameters.A dd("OrderNumber ", SqlDbType.Int). Value = ordno;
SqlDataAdapter da = new SqlDataAdapter( cm);
System.Data.Dat aSet thisDataSet = new System.Data.Dat aSet();
da.Fill(thisDat aSet, "Vivo_Repor t");
ReportDataSourc e datasource = new ReportDataSourc e("DataSet1_Viv o_Report", thisDataSet.Tab les[0]);
ReportViewer1.L ocalReport.Data Sources.Clear() ;
ReportViewer1.L ocalReport.Data Sources.Add(dat asource);
this.ReportView er1.LocalReport .SubreportProce ssing += new SubreportProces singEventHandle r(SubreportProc essingEventHand ler);
ReportViewer1.L ocalReport.Refr esh();
}
thisConnection. Close();
}
protected void Button1_Click(o bject sender, EventArgs e)
{

}

public void SubreportProces singEventHandle r(object sender, SubreportProces singEventArgs e)
{
SqlCommand cm = new SqlCommand("Viv o_Report", thisConnection) ;
cm.CommandType = CommandType.Sto redProcedure;
cm.Parameters.A dd("OrderNumber ", SqlDbType.Int). Value = ordno;
SqlDataAdapter da = new SqlDataAdapter( cm);
System.Data.Dat aSet thisDataSet = new System.Data.Dat aSet();
da.Fill(thisDat aSet, "Vivo_Repor t");
e.DataSources.A dd(new ReportDataSourc e("DataSet1_Viv oReport", thisDataSet.Tab les[0]));
thisConnection. Close();
}
}

[sivakumarcse]

Iam using the below code, everything is working fine am able to get the main report but the problem is report viewer doesn't show the subreport throws a error message: subreport could not be shown
Pls help me.

public partial class _Default : System.Web.UI.P age
{
int ordno = 134085104;
string thisConnectionS tring = "server=.;initi al catalog=vivotec h;uid=sa;pwd=sq l";
SqlConnection thisConnection = new SqlConnection(t hisConnectionSt ring);
protected void Page_Load(objec t sender, EventArgs e)
{
ReportViewer1.V isible = true;

thisConnection. Open();
{
SqlCommand cm = new SqlCommand("Viv o_Report", thisConnection) ;
cm.CommandType = CommandType.Sto redProcedure;
cm.Parameters.A dd("OrderNumber ", SqlDbType.Int). Value = ordno;
SqlDataAdapter da = new SqlDataAdapter( cm);
System.Data.Dat aSet thisDataSet = new System.Data.Dat aSet();
da.Fill(thisDat aSet, "Vivo_Repor t");
ReportDataSourc e datasource = new ReportDataSourc e("DataSet1_Viv o_Report", thisDataSet.Tab les[0]);
ReportViewer1.L ocalReport.Data Sources.Clear() ;
ReportViewer1.L ocalReport.Data Sources.Add(dat asource);
this.ReportView er1.LocalReport .SubreportProce ssing += new SubreportProces singEventHandle r(SubreportProc essingEventHand ler);
ReportViewer1.L ocalReport.Refr esh();
}
thisConnection. Close();
}
protected void Button1_Click(o bject sender, EventArgs e)
{

}

public void SubreportProces singEventHandle r(object sender, SubreportProces singEventArgs e)
{
SqlCommand cm = new SqlCommand("Viv o_Report", thisConnection) ;
cm.CommandType = CommandType.Sto redProcedure;
cm.Parameters.A dd("OrderNumber ", SqlDbType.Int). Value = ordno;
SqlDataAdapter da = new SqlDataAdapter( cm);
System.Data.Dat aSet thisDataSet = new System.Data.Dat aSet();
da.Fill(thisDat aSet, "Vivo_Repor t");
e.DataSources.A dd(new ReportDataSourc e("DataSet1_Viv oReport", thisDataSet.Tab les[0]));
thisConnection. Close();
}
}