Print Page | Close Window

Crystal Report using XML file

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12876
Printed Date: 05 May 2025 at 8:16am


Topic: Crystal Report using XML file
Posted By: kamrocks12
Subject: Crystal Report using XML file
Date Posted: 11 Apr 2011 at 5:55am
Hi,

I want to create dynamic crystal report using below mention xml file.

Example:--

<?xml version="1.0" encoding="utf-8"?>
<root xmlns:inl="http://inline">
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://inline" xmlns="http://inline" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="Person">
<xs:complexType>
<xs:sequence>
<xs:element name="First_Name" type="xs:string"/>
<xs:element name="Last_Name" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
<inl:Person>
<inl:First_Name>Anna</inl:First_Name>
<inl:Last_Name>Ant</inl:Last_Name>
</inl:Person>
<inl:Person>
<inl:First_Name>Betty</inl:First_Name>
<inl:Last_Name>Boop</inl:Last_Name>
</inl:Person>
</root>

Crystal report column will be generated using this xml file.
my report look like--

First Name Last Name
Anna Ant
Betty Boop





-------------
praveen


Replies:
Posted By: lockwelle
Date Posted: 18 Apr 2011 at 3:25am
as far as i know, crystal uses xml files for datasources.  if the report has been built to use the xml datasource, then life is fine(done this for years). changing the datasource schema, usually means refreshing the database schema via Verify Database. 
 
If you are going to throw a random schema at the report and expect it to work, from prior posts, this tends to not be overly successful...perhaps they were just the ones who did not fully understand how to do it, or perhaps I misunderstand your question.


Print Page | Close Window