I have a question regarding web service and crystal report.

 

I have a report with several sub report. I have another web service that can return data for the whole report, but the main report and sub report using the data different part, like the web service return header A and details B, the header A is used by main report, and the details B is used by subreport.

 

Now my question is when I set the datasource for the main report as web service, then the web service return the data, how can I let my sub report use the main report data source?

 

I can set both the main report and sub report datasource as web service, but there will be 2 calls to the web service, it takes longer time.

 

Hope anyone had same issue with me and give me some idea to solve this, thanks.

 

Note: can not seperate the web service as 2 web service, because this part can not be changed.

 

Thanks.

 

 

 

 

 

 

 

I think you can even pass information from main report to sub report.

 

--Webservice should  header and detail in the main report

 

--Using shared variables you can pass the main report data to sub report

 

or

 

whatever data web service is returning in main report, assign this to a variable in a formula and pass the value to your sub report.