Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Can we have web service response in subreports Post Reply Post New Topic
Author Message
Radhika M
Newbie
Newbie


Joined: 05 Nov 2015
Online Status: Offline
Posts: 7
Quote Radhika M Replybullet Topic: Can we have web service response in subreports
    Posted: 05 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?
IP IP Logged
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Posted: 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());

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.