How to import data from an XML file into Crystal Reports

Posted on 2008-10-13
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 101

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 101

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 101

Accepted Solution

mlmcc earned 1000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

718 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