Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR XML V3.6 TABLE AND ROW HINTS

Status
Not open for further replies.

itprsn

MIS
Jan 6, 2004
40
US
I'm using Crystal 8.5, having difficulty pulling XML data in. How can I tell what the table and row hints should be to pull the data in (assuming that's the problem)? I'm connecting and getting the following fields but no other: <lastauthor>, <created> and <version>. I get no other fields and I'm not sure why... Need Account, Name, etc. The XML code is as follows:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel"
xmlns:ss="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:html=" <DocumentProperties xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">
<LastAuthor>063857</LastAuthor>
<Created>2008-08-15T13:46:09Z</Created>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<WindowHeight>4875</WindowHeight>
<WindowWidth>7275</WindowWidth>
<WindowTopX>600</WindowTopX>
<WindowTopY>345</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="08142008test">
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1">
<Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="99"/>
<Column ss:AutoFitWidth="0" ss:Width="156"/>
<Row>
<Cell><Data ss:Type="String">account</Data></Cell>
<Cell><Data ss:Type="String">name</Data></Cell>
<Cell><Data ss:Type="String">street_address_line</Data></Cell>
<Cell><Data ss:Type="String">city_name</Data></Cell>
<Cell><Data ss:Type="String">state</Data></Cell>
<Cell><Data ss:Type="String">zip</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">53509792</Data></Cell>
<Cell><Data ss:Type="String">APRIL SMITH</Data></Cell>
<Cell><Data ss:Type="String">1010 CITY BLOCK</Data></Cell>
<Cell><Data ss:Type="String">DALLAS</Data></Cell>
<Cell><Data ss:Type="String">TX</Data></Cell>
<Cell><Data ss:Type="Number">75075</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top