Skip to Content
author's profile photo Former Member
Former Member

Basic XML as a crystal data source

Can someone point me at a step by step tutorial for crystal describing how to integrate a raw XML data source? I've stumbled across some things on the web but where is a good starting point?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

11 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 12:41 AM

    Hi Eric,

    Below are the stpes to cretae an XML connection with crystal reports.

    Follow the example given step by step to create a Report off an XML ODBC DSN.

    1. Open the ODBC administrator on a Windows 2000 machine by going to Start>Control Panel>Administrative Tools>Data Sources (ODBC)

    2. Create a System DSN by clicking on the System tab and then clicking Add on the right side as shown below

    3. This will bring up the list of available drivers. Please select the CR ODBC XML Driver 4.20 and click Finish.

    4. Under the general tab in the Data Source Name field please type XML

    5. In the description field type xml lesson.

    6. Now Click the Add button in the u201CLocation Namesu201D section. This will bring up the Configure Location window of the DSN.

    7. Now type C drive in the Location Name field.

    8. In the Location Type section, please choose XML Folder.

    9. In the Location field, browse to the C:\XML folder on your machine and double click the northwindorders.xml file.

    10. In the Configure Location window click Apply and then Click Close; this has saved the setting in this section.

    11. In the ODBC XML Driver Setup window click Apply, and then click Close.

    12. The DSN is ready!

    13. Open Crystal Reports 10 either from the shortcut on your desktop or by going to Start and scrolling up the list of programs and clicking the Crystal Reports Icon

    14. Choose a new report.

    15. Select u201CUsing the report Wizardu201D and then choose the Standard Wizard.

    16. In the Standard Report Wizard window expand Create New connection

    17. Expand ODBC and scroll down to connect to your XML DSN. (They are listed alphabetically).

    18. Select the DSN and click Finish.

    19. Now expand the DSN and the list of tables.

    Just try to select the fields required and try to create report.

    Let me know if you have any queries.

    Regards,

    Naveen.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 01:30 AM

    Naveen

    Thanks for the very complete instructions. The problem I have is I don't see any CR drivers in the list. I downloaded the latest crystal reports as an eval. I then installed a vanilla installation. Is there a separate place I have to go to install these drivers? Something special I need to do in Crystal? I googled around with no luck.

    Regards

    Eric

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 02:04 AM

    Hi Eric

    The possible workaround is to use the ODBC drivers.

    Create a DSN and use it in Crystal Reports.

    Regards

    Nikhil Sabnis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 02:19 PM

    Thanks for the reply. However, can you give more detail around "Create a DSN and use it in Crystal Reports" as it relates to the ODBC administrator?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 08:09 PM

    Hi Eric

    I apologize that I missed out the information about the Data Direct drivers for Crystal Reports in my last post.

    You can download the data direct drivers by clicking "Windows Data Direct Drivers - all languages" from the [this |http://www.businessobjects.com/products/downloadcenter/cepremium.asp#Data_Drivers] link.

    Install the drivers and Use the

    "XML driver" option in the ODBC Administrator to create a DSN data Source.

    Once you have the drivers you can follow Navin's instructions.

    Let me know if it helps.

    Regards

    Nikhil Sabnis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 10:08 PM

    Nikhil

    Once again, much thanks for your continued replies. However, I downloaded the link you gave, but when I install, I quickly get a Severe error message stating:

    "Unable to find the registered directory for this Crystal Decisions product. Please reinstall the original product before applying this install. - 102"

    I called the good folks at SAP and they couldn't help. I googled and found one hit, from 2004, but it wasn't clear what was done or whether it was still relevant.

    [http://community.acresso.com/archive/index.php?t-137150.html]

    Ideas?

    Thanks

    Eric

    Edited by: Eric Kaplan on Jan 8, 2009 11:09 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 10:14 PM

    Hi Eric

    Which version of Crystal Reports are you using?

    The error message is probably popping up because its searching for a directory which is non-existent in your version of Crystal Reports.

    Regards

    Nikhil Sabnis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2009 at 10:24 PM

    I just downloaded the 30 day eval the other day. BuildVersion=12.0.0.683.CR_Titan_RTM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2009 at 07:10 AM

    I have CR XI and CR ODBC XML Driver 5.0 when I try to open a connection (data source name is my odbc xml connection) I get the information "Error when logging" (transaltion from german) and then "insufficient connection information available to connect to any underlying providers". My xml file neither the directory is not password protected. Where is the problem?

    Thanks in advance!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2009 at 01:15 PM

    P.S. There is also one another way to connect to xml: [how-to-create-a-report-using-xml-data-source-from-], but I don't have this ADO.NET(XML) at all, even after the described procedure.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.