How to import data from an XML file into Crystal Reports

Posted on 2008-10-13
Last Modified: 2012-05-05
I have a basic XML file that I need to import into Crystal Reports.  I have version 9, 10 and 11 so it doesn't matter which version I use to do it.  I have a pretty good knowledge of Crystal, I have just never attempted to import an XML file.  I tried to do it in version 11 and it asked for a schema or .xsd file and I don't know how to create a schema.  Anyone?
Question by:skielark
  • 3
  • 2
LVL 100

Expert Comment

ID: 22707574
What do you mean by a "basic XML" file?

How are you trying to connect to the file?
I use XML files and have never needed a schema or xsd file.  That may be because the XML files we use have the schema included or it may be the method we use.


Author Comment

ID: 22707582
I mean it is just an XML file.  I don't think the schema is included.  I don't know.  Can you tell me the method you use to pull it into Crystal Reports.  Thanks
LVL 100

Expert Comment

ID: 22707647
Open Crystal
Create a new report with the wizard
Select ADO.NET (XML)
Navigate to the XML file


Author Comment

ID: 22707685
Yay!  That worked.  Now I have another question.  The XML files all have the same name with a date extension.  So, for instance XMLfile090808, XMLfile091008.  Is there a way I can do a wildcard of some sort where it will pull in any of the files or do you have to connect to a specific file?  Thanks
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 22707792
You have to connect to a specific file.  If the files all have the same format then you can use the
DATABASE --> SET DATASOURCE LOCATION optionto change to a different XML file


Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
indexed table vs unindexed table 19 61
Oracle PL/SQL syntax 4 52
SQL Select Query help 3 31
sql calculate averages 18 25
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now