C# set xml data source

huayuz — Wed, 31 Aug 2022 15:00:32 GMT

Hi,

I use XSD file to design a report and want to read another xml(share the same schema ) to set report's data source. However, the exported pdf has no data.

FYI, I use cryastal report 2020 and here are my xsd file code

<?xml version="1.0" standalone="yes"?>
<xs:schema id="data" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="data" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="docid">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RptDate" type="xs:string" minOccurs="0" msdata:Ordinal="0" />
              <xs:element name="PolNo" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
              <xs:element name="PolicyName" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
              <xs:element name="NextAnni" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
              <xs:element name="Address1" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
              <xs:element name="Address2" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
              <xs:element name="Address3" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
              <xs:element name="Address4" type="xs:string" minOccurs="0" msdata:Ordinal="7" />
              <xs:element name="State" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
              <xs:element name="CONTPERSON" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
              <xs:element name="AgentName" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
              <xs:element name="AGYNAME" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
              <xs:element name="CommDisclsInd" type="xs:string" minOccurs="0" msdata:Ordinal="12" />
              <xs:element name="company_code" type="xs:integer" minOccurs="0" msdata:Ordinal="13" />
              <xs:element name="company_short_name_e" type="xs:string" minOccurs="0" msdata:Ordinal="14" />
              <xs:element name="company_short_name_c" type="xs:string" minOccurs="0" msdata:Ordinal="15" />
              <xs:element name="company_full_name_e" type="xs:string" minOccurs="0" msdata:Ordinal="16" />
              <xs:element name="company_full_name_c" type="xs:string" minOccurs="0" msdata:Ordinal="17" />
              <xs:element name="fax_number" type="xs:string" minOccurs="0" msdata:Ordinal="18" />
              <xs:element name="csc_phone" type="xs:string" minOccurs="0" msdata:Ordinal="19" />
              <xs:element name="print_date" type="xs:string" minOccurs="0" msdata:Ordinal="20" />
            </xs:sequence>
            <xs:attribute name="letterdoc">
			  <xs:simpleType>
				<xs:restriction base="xs:string">
				  <xs:pattern value="GRNV005R01|GRNV005R02|GRNV005R03|GRNV005R04"/>
				</xs:restriction>
			  </xs:simpleType>
			</xs:attribute>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema><br>

Re: C# set xml data source

DellSC — Wed, 31 Aug 2022 16:49:15 GMT

What are you doing to set the datasource when you run the report? Are you running this within an application or directly from Crystal?

-Dell

Re: C# set xml data source

former_member11696 — Mon, 12 Sep 2022 16:09:42 GMT

And are you using ADO.NET (XML) or the native CR XML driver?

Re: C# set xml data source

huayuz — Thu, 15 Sep 2022 03:33:54 GMT

yes, I finally get it out by loading schema file and xml. However, There is another issue. That is, Images with graphic location will not display in the exported Pdf when I set data source to report, besides, all fields shows correctly in the pdf. Images shows when I did not set data source to the report.

 void SetXmlDataSource(ReportDocument report)
        {
            if(!Utils.CheckFileExists(_configuration.Schema))
            {
                throw new Exception($"File {_configuration.Schema} does not exist");
            }
            if(!Utils.CheckFileExists(_commandLine))
            {
                throw new Exception($"File {_commandLine} does not exist");
            }
            var ds = new DataSet();
            ds.ReadXmlSchema(_configuration.Schema);
            ds.ReadXml(_commandLine);
            report.SetDataSource(ds);
        }

Report: Crystal Reports 2020

SDK: SAP Crystal Reports, version for Microsoft Visual studio 13.0.32.4286

Question Re: C# set xml data source in Technology Q&A

C# set xml data source

Re: C# set xml data source

Re: C# set xml data source

Re: C# set xml data source