Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR10 and XML Connection

Status
Not open for further replies.

luxvivens

Technical User
May 20, 2010
27
CA
A Vendor system that we use permits me to export my database to an XML file.
I am not XML savvy, but I am able to then open this XML file using Excel and drag in certain fields to create some basic reports/listings.

To perhaps be a bit more efficient, is there a way I might be able to connect directly to my XML file from Crystal Reports (I am using CR10).

I first tried to connect using ADO.NET (XML). I received an error message "a nested table with the same name already belongs to this data table". I am not sure what this means but in my XML file, yes, there are data field names with the same names.

There are some options when I try to use ADO.NET (XML) such as "classes from project" and "use dataset from class" and I will do some research on that.

Should I use another CR data connection for an XML file? Do I need to amend my XML file before connecting? Is this type of connection something that can be done but needs a little tweaking for it to work?

Just looking for some general guidance here. Thanks in advance.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top