Creating Report in CR 2008 with XML as a source

building reports crystal reports
1

Hi Friends,

Could you please tell me how can I create a report with XML file in CR2008. I did the following.
creating a new connection—>I had selected my XML file stored in local machine—>there is one more option like "Use Local Schema "—>When I select this option,I need to select “schema file (XSD)”.
The problem is where do I get this XSD file? or how to create it. Please let me know.

Thanks in advance,
Anil.

anil.ganga1 :us: (BOB member since 2007-07-04)

2

Hi,

Can you let me know how you are generating the XML?

Also, you can use ADO.NET(XML) method connection to connect to XML and generate the report

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)

3

xsd is the schema file that describes the xml data. You can use any text editor to create an xsd file for your xml… check out w3 schools for a quick tutorial, http://www.w3schools.com/schema/default.asp. Also, please note that crystal reports (at least CR XI) does not support recursive xml elements, for example, a ‘folder’ element contained within another ‘folder’ element.

Andrew Jones :canada: (BOB member since 2010-03-10)