For each report, perform the following steps:

  1. In Administration -> Reporting -> Edit Reports, clone the report. Edit the clone.
  2. Scroll down to the list of Standard Sections and click "Customize" on the appropriate section. This will display the Add/Edit section dialog box.
  3. Scroll down to the template section.  Now cut and paste the contents of the 'Template' field into your favorite XML editor and you can modify the report and then save the updated report.
  4. Locate the items that you want to update. 

For the 3-letter months, look for the following section:

<xsl:template name="format-date">
    <xsl:param name="datetime"/>
    <xsl:variable name="date" select="substring-before($datetime, 'T')" />
    <xsl:variable name="year" select="substring-before($date, '-')" />
    <xsl:variable name="month" select="substring-before(substring-after($date, '-'), '-')" />
    <xsl:variable name="day" select="substring-after(substring-after($date, '-'), '-')" />
    <xsl:variable name="time" select="substring-before(substring-after($datetime, 'T'), '.')" />
    <xsl:variable name="monthname">
        <xsl:when test="$month='01'">
          <xsl:value-of select="'Jan'"/>
        <xsl:when test="$month='02'">
          <xsl:value-of select="'Feb'"/>
        <xsl:when test="$month='03'">
          <xsl:value-of select="'Mar'"/>
        <xsl:when test="$month='04'">
          <xsl:value-of select="'Apr'"/>
        <xsl:when test="$month='05'">
          <xsl:value-of select="'May'"/>
        <xsl:when test="$month='06'">
          <xsl:value-of select="'Jun'"/>
        <xsl:when test="$month='07'">
          <xsl:value-of select="'Jul'"/>
        <xsl:when test="$month='08'">
          <xsl:value-of select="'Aug'"/>
        <xsl:when test="$month='09'">
          <xsl:value-of select="'Sep'"/>
        <xsl:when test="$month='10'">
          <xsl:value-of select="'Oct'"/>
        <xsl:when test="$month='11'">
          <xsl:value-of select="'Nov'"/>
        <xsl:when test="$month='12'">
          <xsl:value-of select="'Dec'"/>
          <xsl:value-of select="''" />
    <xsl:value-of select="concat($day, '-' ,$monthname, '-', $year , ' ', $time)" />
  • Make the desired changes and then paste it back into the Spira report editor.