Posted By: Radhika M — 5 Feb 2016 at 1:54am
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?
Posted By: niha — 12 Feb 2016 at 12:53am
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());