Urgent Help Me:(SQL SERVER REPORT)

Hi,



I created sql server Main & sub reports ...But i didnt get supreport in window application

Its Shows only Main report.



The Error Shown: Could Not Be Shown Subreport



How to call subreport in windows application...any coding is their.. its working backend (Main & Subreport reports)but its not working windows application. its shows only main report . I Mentioned my coding part below:



public partial class Form1 : Form

{

private string str = @"Uid=sa;pwd=systems;Data Source=Spring;Initial Catalog=VPMS";

private SqlConnection con;

private DataSet ds = new DataSet();

private SqlDataAdapter da;

private DataTable orderDetailsData = null;



private DataTable LoadOrdersData()

{

this.con = new SqlConnection(this.str);

this.ds = new DataSet();

this.da = new SqlDataAdapter("exec STP_RP_AR_ENCOUNTER", this.con);

this.da.Fill(ds, "OrderData");

return ds.Tables[0];



}



private DataTable LoadOrderDetailsData()

{

this.con = new SqlConnection(this.str);

this.ds = new DataSet();

this.da = new SqlDataAdapter("select * from VW_RP_SHR_Superbill where 1=1", this.con);

this.da.Fill(ds, "OrderDetailsData");

return ds.Tables[0];



}



private void SubreportProcessingEventHandler(Object sender, SubreportProcessingEventArgs e)

{

if (orderDetailsData == null)

orderDetailsData = LoadOrderDetailsData();

e.DataSources.Add(new ReportDataSource("Ds1", orderDetailsData));

}



public Form1()

{

try

{

this.Text = "Report Control Demo";

this.ClientSize = new System.Drawing.Size(700, 600);

ReportViewer reportViewer = new ReportViewer();



reportViewer.ProcessingMode = ProcessingMode.Local;



reportViewer.LocalReport.ReportPath = "RP_SHR_SuperBillPrint.rdl";



reportViewer.LocalReport.SubreportProcessing +=

new SubreportProcessingEventHandler(SubreportProcessingEventHandler);



reportViewer.LocalReport.DataSources.Add(

new ReportDataSource("Ds1", LoadOrdersData()));



reportViewer.Dock = DockStyle.Fill;

this.Controls.Add(reportViewer);



reportViewer.RefreshReport();


}

catch (Exception ex)

{

MessageBox.Show(ex.ToString());

}



}

private void Form1_Load(object sender, EventArgs e)

{

this.reportViewer1.RefreshReport();

this.con = new SqlConnection(this.str);

this.ds = new DataSet();

}


}

}



Please Help me Very Urgent:





Does anyone have any suggestions? Thanks.