I am using Crystal Report 9.0 (Can't upgrade due to some constraints) My application is in classic ASP using ADO
My application will retrieve XML data from a Web Service exposed by a service provider and i need to generate a Report using this XML data.
Is there any way to do so? Thx in Advance
Hi, i think it is possible because crystal reports expects dataSet as datasource for report just transform you xml data in such a way that you can load it in dataset you are ready Best Regards, Iordan
You should be able to have the Crystal Report read the xml file directly. When you create the report, use the choose XML from the available datasource connections and proved the information relating to the web service in the XML connect setup. I believe that you should be able to point it directly to your webservice if you choose "Use Web Service Data Source" and pass in the necessary information. I'm am looking at this using Crystal 11, but I believe that this was available in Crystal 9. If not I am pretty sure that there is another XML datasource connection that you can use. You may have to create the report using a local xml file similar to what you would expect back from your webservice and then set the datasource of the report at runtime to the xml from the webservice, but I am pretty sure you should be able to get this working. Hope this has been somewhat helpful.