Skip to Content
0
Former Member
Jan 17, 2011 at 09:01 PM

Visual Linking Expert doesn't work with XSD file.

28 Views

When I try to link to tables nothing happens, dropping the PK field from table Part4A over the field ParentFK in table Part4B doesn't create the link. The datasource for the report is a XSD file wich I created from a typed dataset in .Net Here is the schema:

<?xml version="1.0" standalone="yes"?>

http://tempuri.org/CustomerStatementPart4BO.xsd" xmlns:mstns=" http://tempuri.org/CustomerStatementPart4BO.xsd" xmlns=" http://tempuri.org/CustomerStatementPart4BO.xsd" xmlns:xs=" http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">

<xs:element name="CustomerStatementPart4BO" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="Part4A">

<xs:complexType>

<xs:sequence>

<xs:element name="CompanyMnemonic" type="xs:string" />

<xs:element name="DocCreatedOn" type="xs:dateTime" />

<xs:element name="DocMnemonic" type="xs:string" />

<xs:element name="DocIdNumber" type="xs:string" />

<xs:element name="DocComments" type="xs:string" />

<xs:element name="OriginalAmountColones" type="xs:decimal" />

<xs:element name="OriginalAmountDollars" type="xs:decimal" />

<xs:element name="BalanceOnDate" type="xs:decimal" />

<xs:element name="PayDifference" type="xs:decimal" />

<xs:element name="PayDifferenceManagementEnum" type="xs:unsignedByte" />

<xs:element name="DocState" type="xs:string" />

<xs:element name="CustomerId" type="xs:int" />

<xs:element name="FullName" type="xs:string" />

<xs:element name="DocStateEnum" type="xs:unsignedByte" />

<xs:element name="DocTypeEnum" type="xs:unsignedByte" />

<xs:element name="CompanyFK" type="xs:int" />

<xs:element name="AffectedCurrencyFK" type="xs:unsignedByte" />

<xs:element name="CustomerFK" type="xs:int" />

<xs:element name="PK" type="xs:int" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="Part4B">

<xs:complexType>

<xs:sequence>

<xs:element name="CompanyMnemonic" type="xs:string" />

<xs:element name="DocCreatedOn" type="xs:dateTime" />

<xs:element name="DocMnemonic" type="xs:string" />

<xs:element name="DocIdNumber" type="xs:string" />

<xs:element name="DocComments" type="xs:string" />

<xs:element name="OriginalAmount" type="xs:decimal" />

<xs:element name="OldBalance" type="xs:decimal" />

<xs:element name="AffectedAmount" type="xs:decimal" />

<xs:element name="IncomeTax" type="xs:decimal" />

<xs:element name="NewBalance" type="xs:decimal" />

<xs:element name="AffectingAmount" type="xs:decimal" />

<xs:element name="DocTypeEnum" type="xs:unsignedByte" />

<xs:element name="CompanyFK" type="xs:int" />

<xs:element name="AffectedCurrencyFK" type="xs:unsignedByte" />

<xs:element name="AffectingCurrencyFK" type="xs:unsignedByte" />

<xs:element name="ParentFK" type="xs:int" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

<xs:annotation>

<xs:appinfo>

<msdata:Relationship name="Part4A_Part4B" msdata:parent="Part4A" msdata:child="Part4B" msdata:parentkey="PK" msdata:childkey="ParentFK" />

</xs:appinfo>

</xs:annotation>

</xs:schema>