Hi all,

I have a Main Report in which i have more than 4 subreports,
I m getting an error "Missing Parameter"
i m setting main report parameter through this code
myReportDocument.SetParameterValue("param1",obj1)
I dont know how to pass parameter for sub report.
can any one help i will be greatfull for him.

There is one more argurment you can pass
myReportDocument.SetParameterValue("param1",obj1,s ubreportname)

Another method is you can right click on subreport object on main report you will find option "link",
then you have to map parameter passed to mainreport to subreport parameter.



urt

Dim myCon As New SqlClient.SqlConnection()
myCon.ConnectionString = ConfigurationManager.ConnectionStrings("MyCon").Co nnectionString
Dim mycmd As New SqlClient.SqlCommand()
Dim mycmd1 As New SqlClient.SqlCommand
mycmd.Connection = myCon
mycmd1.Connection = myCon
' For Stored Procedure
mycmd.CommandType = CommandType.StoredProcedure
mycmd.CommandText = "Depo_InvoicePrint"
mycmd.Parameters.Add("@InvNo", SqlDbType.VarChar)
mycmd.Parameters("@InvNo").Value = Session("InvoiceNo")

mycmd1.CommandType = CommandType.StoredProcedure
mycmd1.CommandText = "Depo_InvoicePrintSubreport"
mycmd1.Parameters.Add("@InvNo", SqlDbType.VarChar)
mycmd1.Parameters("@InvNo").Value = Session("InvNo")

Dim myda As New SqlClient.SqlDataAdapter()
myda.SelectCommand = mycmd
Dim myDs As New DataSet()
myda.Fill(myDs, "InvoicePrint") ' name of the Stored Proc for main report

Dim myda1 As New SqlClient.SqlDataAdapter()
myda1.SelectCommand = mycmd1
Dim myDs1 As New DataSet()
myda1.Fill(myDs1, "InvoicePrintSubreport") ' name of the Stored Proc for subreport

mycmd.Dispose()
mycmd1.Dispose()
myCon.Close()

oRpt.Load(Server.MapPath(c:/rptInvoicePrint.rpt"))
oRpt.FileName = Server.MapPath(c:/rptInvoicePrint.rpt")
oRpt.SetDataSource(myDs)
oRpt.OpenSubreport("rptInvoicePrintSub").SetDataSo urce(myDs1)

oRpt.SetParameterValue("@InvNo", Session("InvoiceNo")) 'parameter for main report
oRpt.SetDatabaseLogon(Session("dbuser"), Session("dbpass"))

oRpt.SetParameterValue("@InvNo", Session("InvoiceNo"), "rptInvoicePrintSub") ' parameter for subreport

myCon.Close()


[/quote]