passing parameters to subreport (C#)
I am passing parameters to both the main report and sub-report. I tried to pass the parameters to the main report like this,
ReportDocument oRpt = new ReportDocument();
ParameterFieldDefinition paramField;
ParameterDiscreteValue mainValue = new ParameterDiscreteValue();
ParameterValues currentValues;
oRpt.Load(Server.MapPath("./Statement_top.rpt"));
oRpt.SetDatabaseLogon(USERID, PWD, SERVER, DB);
paramField = oRpt.DataDefinition.ParameterFields["accountID"];
currentValues = paramField.CurrentValues;
mainValue.Value = accountID;
currentValues.Add(mainValue);
paramField.ApplyCurrentValues(currentValues);
paramField = oRpt.DataDefinition.ParameterFields["fromDate"];
mainValue = new ParameterDiscreteValue();
mainValue.Value = fromDate;
currentValues.Clear();
currentValues.Add(mainValue);
paramField.ApplyCurrentValues(currentValues);
paramField = oRpt.DataDefinition.ParameterFields["toDate"];
mainValue = new ParameterDiscreteValue();
mainValue.Value = toDate;
currentValues.Clear();
currentValues.Add(mainValue);
paramField.ApplyCurrentValues(currentValues);
and then, I tried this,
rOpt.OpenSubreport("Statement_details.rpt");
paramField = oRpt.DataDefinition.ParameterFields["accountID1", "Statement_details.rpt"];
currentValues = paramField.CurrentValues;
mainValue.Value = accountID;
currentValues.Add(mainValue);
paramField.ApplyCurrentValues(currentValues);
it, however, seems the programme tried to pass the parameter to the main report, but not subreport.. Am I do it a wrong way? How can I pass the parameters to subreport in this case?? Thanks mate..
|
