• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1428
  • Last Modified:

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?
0
skielark
Asked:
skielark
  • 3
  • 2
1 Solution
 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now