How to import data from an XML file into Crystal Reports

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?
skielarkAsked:
Who is Participating?
 
mlmccCommented:
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

mlmcc
0
 
mlmccCommented:
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.

mlmcc
0
 
skielarkAuthor Commented:
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
0
 
mlmccCommented:
Open Crystal
Create a new report with the wizard
Create a NEW CONNECTION
Select ADO.NET (XML)
Navigate to the XML file

mlmcc
0
 
skielarkAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.