Hi ...

I have to display the records using the crystal report. The following is the xml:


 <?xml version="1.0" ?>
 <FundOutRptRs xmlns:jsp="http://java.sun.com/JSP/Page">
  <status code="0">success</status>
 <Header>
  <version>1.0</version>
  <operatorID>06</operatorID>
  <languageID>EN</languageID>
  <terminalID>C555</terminalID>
  <hash>00-0D-60-78-76-4F</hash>
  <channelID>C</channelID>
  <dateTimeStamp>2004-08-24 19:49:27</dateTimeStamp>
  <userID>cbtest06</userID>
  <password>1234</password>
  <sessionKey>BrrLxm1LTnmTW67pxjtUrRSxEuXD9fnKFnjdTl LZKpR0FyYYrDOA!-1828760951!1093348107854</sessionKey>
  </Header>
<BetCenter>
  <Center id="AUS" name="Aus location" />
  <Date>2004-08-18</Date>
  <TotalFundIn>599.01</TotalFundIn>
  <FundInTran>1</FundInTran>
  <MonTotalFundIn>599.01</MonTotalFundIn>
  <MonFundInTran>1</MonFundInTran>
  </BetCenter>
<Terminals>
 <Terminal>
  <TerminalID>C555</TerminalID>
  <Time>19:29:22</Time>
  <TransCode>CB0/C555/000001</TransCode>
  <AccountID>06000813</AccountID>
  <Name>First</Name>
  <Amount>599.01</Amount>
  <StaffID>cbtest06</StaffID>
  </Terminal>
  </Terminals>
  </FundOutRptRs>


I created DSN and everything...But when i try to run the report iam getting terminal table doesnt exist...
Pls help me if u guys know..


rgds
khan

Hello Ferozkhan,

Is your XML doc in a file? if not then put into a file and place it ina directory that you will point to with your DSN. The Crystal ODBC driver will then look in the directory and pick up all XML files and you can then choose when you go to the Database source tab.

Cyrstal will parse the XML into a table that you can use in your reports.

Sincerely,

Dr. Wolf

I'm trying to get XML data to display in my Crystal Report without a design time xsd file - i.e., I want to display a database completely on the fly. Is it possible to read and display an XML file without an xsd file?

Thanks.

You need to have a schema for your xml.

CD