jakecolman
IS-IT--Management
Using Crystal XI and Oracle 9.
I am reasonably comfortable desiging reports using Oracle tables. The plan now for this new requirement is to give me an XML data file to be used as the input to a report. I have done some reading on Crystal and XML data files and I have some questions:
1) Can I simply view an XML input file as any other ODBC input source? In other words, does the XML file represent a table and the tags represent column names? If so, once I set up the linkage to the XML input source, can I just query the dataset as if it was a table and conceptually deal with it in that way?
2) Can an XML input file contain data for more than one table? Or does each table need its own XML file?
3) Can XML input files be joined so that you have a joined query? I guess the answer to this is at least partially dependant upon the answe to #2.
4) Can someone point me to a resource that explains how to use XML with Crystal? I already read the Crystal Decisions document "Using XML Data with Crystal Report". Is there anything else useful to read?
Thanks for your help!
...Jake
I am reasonably comfortable desiging reports using Oracle tables. The plan now for this new requirement is to give me an XML data file to be used as the input to a report. I have done some reading on Crystal and XML data files and I have some questions:
1) Can I simply view an XML input file as any other ODBC input source? In other words, does the XML file represent a table and the tags represent column names? If so, once I set up the linkage to the XML input source, can I just query the dataset as if it was a table and conceptually deal with it in that way?
2) Can an XML input file contain data for more than one table? Or does each table need its own XML file?
3) Can XML input files be joined so that you have a joined query? I guess the answer to this is at least partially dependant upon the answe to #2.
4) Can someone point me to a resource that explains how to use XML with Crystal? I already read the Crystal Decisions document "Using XML Data with Crystal Report". Is there anything else useful to read?
Thanks for your help!
...Jake