Web Service as Datasource for a Report

[Former Member]

hello.

current situation:

CR2008 (12.3.0.601)

webservice is created.

webservice is bound as datasource in CR.

report creation works fine.

but:

i would like to provide key information for the tables specified in WS-XSD.

something like (marked with '->'):

<xsd:complexType name="someTableRowType">
  <xsd:sequence>
    <xsd:element name="numberColumnInSomeTable" type="xsd:int" minOccurs="1" maxOccurs="1">
->    <xsd:attribute name="key" type="xsd:string" fixed="true"/>
    </xsd:element>
    <xsd:element name="stringColumnInSomeTable" type="xsd:string" minOccurs="1" maxOccurs="1" />
  </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="someTableType">
  <xsd:sequence>
    <xsd:element name="someTableRowType" type="xsd:string" minOccurs="0" maxOccurs="unbound" />
  </xsd:sequence>
</xsd:complexType>

// and then:

<xsd:complexType name="someOtherTableRowType">
  <xsd:sequence>
    <xsd:element name="numberColumnInSomeOtherTable" type="xsd:int" minOccurs="1" maxOccurs="1">
->   <xsd:attribute name="references" type="xsd:string" use="required"/>
    </xsd:element>
    <xsd:element name="stringColumnInSomeOtherTable" type="xsd:string" minOccurs="1" maxOccurs="1" />
  </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="someOtherTableType">
  <xsd:sequence>
    <xsd:element name="someOtherTableRowType" type="xsd:string" minOccurs="0" maxOccurs="unbound" />
  </xsd:sequence>
</xsd:complexType>

i am looking for the keywords for "key" and "references". is there something like that? or an other posibility exist?

[former_member183750 · Accepted solution]

I think you wants to be able to read additional information from the schema at runtime?

There are no CR apis to do this, but System.Data may be able to do this... not in CR though.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

hi Ludek,

i want to provide additional information about the relations between the "tables" i provide. so that CR could be able to link these tables automaticly during the report creation. and i am looking for a possibility to define the primary- and foreignkey in the xsd.

what du you mean with "System.Data"? it seems to me you speak about .NET? i don't deal with .NET.

hi Bhushan,

your suggestion could help me by other problems i have. thank you.

temir

[former_member188030]

Try designing a report using the XSD through the Crystal designer. If the report gets the schema, data can be passed through the code. However I am not sure if the designer takes the XML specifications other than the default one.

For designer issue post a thread at [SAP Crystal Reports Design Forum|;

Bhushan.