Removing an element

izbor · May 5th, 2006, 08:28 PM

Hi,

Firstly - sincere apologies for not posting this separately in the first place.

I'd like to transform from Reporting Services XML to eliminate a tag.

The original XML is:

<?xml version="1.0"?>
<Report xmlns="UC203_x0020_Export_x0020_Returning_x0020_Of ficer_x0020_Details_x0020_for_x0020_Advertising" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="UC203_x0020_Export_x0020_Retur ning_x0020_Officer_x0020_Details_x0020_for_x0020_A dvertising http://localhost/reportserver/folder?%2fUC203+Export+Returning+Officer+Details+f or+Advertising&ElectionEventID=dee73101-8b80-4cae-8c15-e6fed571dfa2&ElectorateTypeID=00000001-0001-0001-0001-000000000006&rs%3aFormat=XML&rs%3aShowHide Toggle%3aisnull=True&rc%3aSchema=True" Name="UC203 Export Returning Officer Details for Advertising">
    <ReturningOfficers>
        <ReturningOfficerDetails_Collection>
            <ReturningOfficerDetails>
                <Electorate>Ballajura</Electorate>
                <RO>Tom Jones</RO>
                <Tel>92913336</Tel>
                <Mob> </Mob>
                <Venue>Ballajura Community College</Venue>
                <Address1>Illawarra Crescent South</Address1>
                <Address2> </Address2>
                <Suburb>BALLAJURA</Suburb>
            </ReturningOfficerDetails>
        </ReturningOfficerDetails_Collection>
    </ReturningOfficers>
</Report>

The ReturningOfficerDetails_Collection and Report tags are to be removed so that the output then becomes:

<?xml version="1.0"?>
<ReturningOfficers>
   <ReturningOfficerDetails>
    <Electorate>Ballajura</Electorate>
    <RO>Tom Jones</RO>
    <Tel>92913336</Tel>
    <Mob> </Mob>
    <Venue>Ballajura Community College</Venue>
    <Address1>Illawarra Crescent South</Address1>
    <Address2> </Address2>
    <Suburb>BALLAJURA</Suburb>
   </ReturningOfficerDetails>
</ReturningOfficers>

Thanks

joefawcett · May 6th, 2006, 02:34 AM

You didn't specify whether you wanted to keep the namespaces or not, this stylesheet doesn't.

Code:

<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                exclude-result-prefixes="report"
                xmlns:report="UC203_x0020_Export_x0020_Returning_x0020_Officer_x0020_Details_x0020_for_x0020_Advertising">

  <xsl:template match="/">
    <ReturningOfficers>
      <xsl:apply-templates select="report:Report/report:ReturningOfficers/report:ReturningOfficerDetails_Collection/report:ReturningOfficerDetails"/>
    </ReturningOfficers>
  </xsl:template>

  <xsl:template match="report:ReturningOfficerDetails_Collection//*">
    <xsl:element name="{local-name()}">
      <xsl:apply-templates/>
    </xsl:element>

  </xsl:template>
</xsl:stylesheet>

Not the most elegant solution but I believe it works.

--

Joe (Microsoft MVP - XML)

mhkay · May 6th, 2006, 03:52 AM

Write a default template rule that copies elements unchanged:

<xsl:template match="*">
<xsl:copy><xsl:copy-of select="@*"/><xsl:apply-templates/></xsl:copy>
</xsl:template>

Then supplement it with a rule for selected elements that copies the contents but not the element itself:

<xsl:template match="Report|ReturningOfficeDetails_Collection">
<xsl:apply-templates/>
</xsl:template>

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

izbor · May 8th, 2006, 11:00 PM

Thanks for that - works very nicely