P
Phil Barber
I have a report based on a dataset and A Stored Proc.
I want to place a Sub-report in the main report witch is also based another
Stored Proc
there are to ID's that would link the reports. I added a subreport to the
main report, but when it runs it tells me login failed. I use this code to
run the main report which I have verified works.
private void Page_Load(object sender, System.EventArgs e)
{
WebUser=(TWebUser)Session["WU"];
SQLCash.Open();
QWebRpt.SelectCommand.Parameters[1].Value = WebUser.ExpID; //Sp
QWebRpt.Fill (tdsWebRpt1);
ERpt.SetDataSource (tdsWebRpt1); //report var
CRVExpenseRpt.ReportSource = ERpt; //viewer
}
Thanks for any help.
I want to place a Sub-report in the main report witch is also based another
Stored Proc
there are to ID's that would link the reports. I added a subreport to the
main report, but when it runs it tells me login failed. I use this code to
run the main report which I have verified works.
private void Page_Load(object sender, System.EventArgs e)
{
WebUser=(TWebUser)Session["WU"];
SQLCash.Open();
QWebRpt.SelectCommand.Parameters[1].Value = WebUser.ExpID; //Sp
QWebRpt.Fill (tdsWebRpt1);
ERpt.SetDataSource (tdsWebRpt1); //report var
CRVExpenseRpt.ReportSource = ERpt; //viewer
}
Thanks for any help.