Converting XML files in Crystal 11 -

srodgers45
srodgers45 used Ask the Experts™
on
Any idea on how to convert an XML to viewable data in a report? I tried the coverter but it does not show the fields??

This is what I am trying to convert:


<?xml version="1.0" encoding="utf-8"?><Header><Column FieldID="101" Caption="Run Number" DataType="System.String">10007058</Column><Column FieldID="0" DataType="System.Int32" Caption="Status" Type="Status" /><Column FieldID="377" Caption="First Name" DataType="System.String" /><Column FieldID="378" Caption="Last Name" DataType="System.String" /><Column FieldID="72" Caption="Address 1" DataType="System.String">Civic Dr / Ygnacio Valley Rd</Column><Column FieldID="382" Caption="DOB" DataType="System.DateTime" /><Column FieldID="61" Caption="Arrived at Hospital" DataType="System.DateTime" DateTimeFormat="1">1900-01-01T08:00:00Z</Column><Column FieldID="0" DataType="System.String" Caption="Crew 1 Name">JASON HENIKA EMTP</Column><Column FieldID="0" DataType="System.String" Caption="Crew 2 Name">DARIN PETERSON EMT</Column><Column FieldID="787" Caption="Workflow Phase" DataType="System.String">Archive</Column><Column FieldID="788" Caption="Workflow Comments" DataType="System.String" /><Column FieldID="2" Caption="PCR ID" DataType="System.Int32">9248</Column></Header>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
WHich tool are you using to produce the report?

I report off XML files all the time.  I simply choose the ADO.Net as the data source and navigate to the XML file.

WHat version of Crystal do you have?

What have you tried?

mlmcc

Author

Commented:
I am using Crystal 11 and the XML converter tool. i am not sure how to convert the fields to show the data i need. this is new to me. Thanks
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What XML convertor tool?

Can you attach a sample XML file that is giving you trouble?

mlmcc

Author

Commented:
The XML Expert in the Report Tab -  the sample is in the original question area above
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
The XML Expert is for exporting your report to XML files.

Here is a report I built using your sample file

mlmcc
Document.xml
DcoumentXML.rpt

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial