Can we have web service response in subreports

Printed From: Crystal Reports Book — Forum Name: Technical Questions

We have a requirement wherein we are getting data in subreport from webservice response. After implementing the report, I am getting exception while generating it. Can anyone help me in understanding whether we can have web service response as datasource in subreports in crystal reports 2008?
Following code may help you.i used it for report and its sub report don't know how you will get data from web service. that R&D still you have to do.


ReportFileName =GetPathOfDocument(@"reportname.rpt");
ProcName = "sqlprocname";
sp = new SqlParameter[2];
sp[0] = new SqlParameter("@parmeter", getValueFromURL("parmetername"));
sp[1] = new SqlParameter("@parmeter", getValueFromURL("parmetername"));
Ds = ExecuteProcedure(ProcName, sp);//have own code
ProcName = "procdeuree";//sub rpt
sp = new SqlParameter[1];
sp[0] = new SqlParameter("@parmeter", getValueFromURL("parmetername"));
Dt = ExecuteProcedure(ProcName, sp).Tables[0];
Dt.TableName = "Tablename";/random name
Ds.Tables.Add(Dt.Copy());