I am unable to change the Data Links on my XML tables. All the links point to the headers of each table name (seeming to indicate the embedded hierarchy of a Local XML data source), but I need to link by Key. I cannot delete, clear or even view the options of my Links.
I created a report using a data source of type Local XML (XML + XSD). Upon trying to put the report in production we found that the data source needs to be ADO.NET (XML) and that we needed to change the Data Links to use the table keys (not the header links).
I successfully switched the report Data Source over to ADO.NET XML. However, I'm still unable to change the Data Links. They still all point to the header of each table - seeming to indicate the embedded hierarchy of the Local XML.
I've done some further testing (with a blank report) to prove that if you import a Local XML file with XSD structure then you can't change Data Links. Even if you subsequently change the Data Source to ADO.NET XML, you still cannot change the Data Links.
However, if you initially set up the Data Source as ADO.NET XML then you are able to change the Data Links.
I'm unsure if this is a Crystal Report limitation or just a bug. I've begun investigations into this online but have not found anything relevant yet. Has anyone encountered this issue?