Crystal Reports XI
-
I dont think CR knows how to read XML. You need to convert the XML to MDB/DBF/SQL so that your CR template can read those tables not file. Or another way doing it is to use XML to datagrid and datagrid is your datasource.
-
In your Crystal Report you reference the schema by opening the Field Explorer, right clicking Database Fields, selecting Database Expert, expanding the Create New Connection node, and the ADO.NET (XML) node then double clicking Make New Connection. At the ADO.NET (XML) dialog set the File Path to your XSD file by clicking the elipses and navigating to the schema file
-
In your Crystal Report you reference the schema by opening the Field Explorer, right clicking Database Fields, selecting Database Expert, expanding the Create New Connection node, and the ADO.NET (XML) node then double clicking Make New Connection. At the ADO.NET (XML) dialog set the File Path to your XSD file by clicking the elipses and navigating to the schema file
That is what I am trying to do, but I do not see the ADO.NET option at all. All I see are: Access/Excel Database Files ODBC OLE DB Universes More DataSources. I tried to use Database Files option, but as soon as I select the XSD file, I get the error "Failed to load Database Info". I click OK and then I get "Unknown Database connector Error". Thanks for trying to help me. Sudha
-
That is what I am trying to do, but I do not see the ADO.NET option at all. All I see are: Access/Excel Database Files ODBC OLE DB Universes More DataSources. I tried to use Database Files option, but as soon as I select the XSD file, I get the error "Failed to load Database Info". I click OK and then I get "Unknown Database connector Error". Thanks for trying to help me. Sudha
go to Create New Connection go to Databases Files on the drop down Files of Type select XML Files (*.xml;*.xsd) point to your file and click Open.
-
go to Create New Connection go to Databases Files on the drop down Files of Type select XML Files (*.xml;*.xsd) point to your file and click Open.
-
Do you have the Login and Password? Is the file locally stored on your Workstation?
-
Do you have the Login and Password? Is the file locally stored on your Workstation?
-
Do you have the Login and Password? Is the file locally stored on your Workstation?
If your template trying to access the server you need to have ODBC connector from your workstation to the server where the XML/XSD located. Go to Control Panel\Administrative Tools\Data Sources. Make sure the Server\XSD table listed with correct Login and password. Then your template will open using the connector from your Workstation to the server and drills to the server to get the XSD and frame it against your template.
-
If your template trying to access the server you need to have ODBC connector from your workstation to the server where the XML/XSD located. Go to Control Panel\Administrative Tools\Data Sources. Make sure the Server\XSD table listed with correct Login and password. Then your template will open using the connector from your Workstation to the server and drills to the server to get the XSD and frame it against your template.
Sudha. I currently have hundreds of CR rpt files that utilizing DBF, MDB, SQL and experiencing no issues at all. My last attempt is to look at the XSD from your Workstation using Microsoft Access and if the table opens that means you have connections and if the table does not open that means connections from the server is no good. If this does not help I give up.