Crystal Reports reading data from XML

Posted on 2007-10-04
Last Modified: 2012-08-13
1. in CR, I am using xml as data source.
2. xml is exported using access' Application.ExportXML
3. with the export xml files has exportet all columns containing data.
4. sometimes the coulmn exported are more or less, meaning a column will be missing later on.
5. in CR again, I have formulas on some fields that are no longer on the xml file, because they don't contain data and thus not being exported at #2.

Besides writting the xml export function manually instead of using MS' .ExportXML is it possible in Crystal reports to simply:
 a. does this field name exist?
 - yes = use it
 - no = ignore it (gives me "This field is not known" error at the moment.

Question by:Berhan Karagoez
    LVL 42

    Accepted Solution

    Sorry BK, this isn't possible.  Crystal expects that the fields will always exist and will throw an error if an expected field isn't there.

    You can certainly write formulas to handle the case where a field contains a null value (isNull function in Crystal) but the field must still exist in the dataset.


    Author Comment

    by:Berhan Karagoez
    right, thanks for the info.
    Easy still wel deserved points! ;)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now