skielark
asked on
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?
ASKER
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
Open Crystal
Create a new report with the wizard
Create a NEW CONNECTION
Select ADO.NET (XML)
Navigate to the XML file
mlmcc
Create a new report with the wizard
Create a NEW CONNECTION
Select ADO.NET (XML)
Navigate to the XML file
mlmcc
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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