Try to connect to XML using Crystal

[davidmckee]

Good morning everyone, I am hoping someone can help. I am trying to create a crystal report to present weather based on the Weatheroffice database. They provided me with an email and link but I don't know how to set up Crystal to report on this. I want to bring in the Forecast weather for Toronto which I figured out is the following file

http://dd.weatheroffice.gc.ca/citypage_weather/xml/ON/s0000458_e.xml

However it has schemas and when I go through the crystal wizard it always gives me an error

Any help would be appreciated



Email from Weather Office Canada

Hello,

Thank you for sending your message to Environment Canada. I have a suggestions for you:

We also offer the data in XML format:

http://dd.weatheroffice.gc.ca/citypage_weather/

You should find all the information you need to use the XML feed in the doc and schema folders.

Best regards,


National Inquiry Response Team
Meteorological Service of Canada
Environment Canada

 

[LinPro]

Hi

Can you load that xml file to your computer?

If you go to Set Datasource Location and go to Create new datasource, you should select ADO.Net (XML).

Then select the XML file to retrieve the data.

Lin

 

[kenhamady]

I recently struggled with reports using XML Files and ended up writing two short articles that might help you:

http://kenhamady.com/cru/archives/1243

http://kenhamady.com/cru/archives/1111

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[LinPro]

Yeah it is a pain using XML.I am glad I dont have to use it now