Returning a value

Neal · October 12th, 2006, 05:21 AM

Hi,

I need to retreive the 'Formatted Value' and 'Value' from the following xml:

Code:

<FormattedReportObjects>
  <FormattedReportObject xsi:type="CTFormattedField" Type="xsd:string" FieldName="{@INVOICE_NUMBER}">
    <ObjectName>INVOICENUMBER1</ObjectName>
    <FormattedValue>9</FormattedValue>
    <Value>9</Value>
  </FormattedReportObject>
</FormattedReportObjects>

I have tried to populate a variable using the example:

Code:

<xsl:variable name="strInvNo" select=".//*[@FieldName='{@INVOICE_NUMBER}']/FormattedValue"/>

But there is no value returned, please can you assist?

Thanks,

Neal

A Northern Soul

mhkay · October 12th, 2006, 05:36 AM

Given that your XML doesn't contain a namespace declaration for "xsi", I strongly suspect that you haven't shown us the whole of the XML, and my guess is that somewhere in the XML there is a default namespace declaration, which would mean that in your path expression, FormattedValue needs to be prefixed. That's extrapolating from very little evidence, but otherwise, what you've shown us seems correct.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Neal · October 12th, 2006, 06:04 AM

Hi,

Sorry, I am using version 1.0 and the full path is:

Code:

<FormattedReport xmlns="urn:crystal-reports:schemas" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance">
  <FormattedAreaPair Level="0" Type="Report">
    <FormattedArea Type="Header">
      <FormattedSections>
        <FormattedSection SectionNumber="0">
          <FormattedReportObjects>
            <FormattedReportObject xsi:type="CTFormattedField" Type="xsd:string" FieldName="{@INVOICE_NUMBER}">
              <ObjectName>INVOICENUMBER1</ObjectName>
              <FormattedValue>9</FormattedValue>
              <Value>9</Value>

Neal

A Northern Soul

mhkay · October 12th, 2006, 06:10 AM

So I guessed right. The elements are in namespace xmlns="urn:crystal-reports:schemas" so you need to use a prefix on element names in the path expression. If in doubt google for "XSLT default namespace prefix".

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

joefawcett · October 12th, 2006, 06:52 AM

See links at http://p2p.wrox.com/topic.asp?TOPIC_ID=49630

--

Joe (Microsoft MVP - XML)

Neal · October 13th, 2006, 10:04 AM

Hi,

version 1.0

Thanks Mike for your assistance.

I have how managed to retreive data from my XML file. However, whereas the following will produces ALL node values:

Code:

.//*[@FieldName='{INVOICE_NUMBER}']/*

My original code returns no values:

Code:

.//*[@FieldName='{INVOICE_NUMBER}']/FormattedValue

Why is this?

Thanks in advance.

Neal

A Northern Soul

mhkay · October 13th, 2006, 11:41 AM

As explained previously, the FormattedValue element is in a namespace so it needs to be prefixed.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference