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.
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.