Exporting Report to excel is not showing graphic
Hi,
we are using RTC 4.0.2 and when trying to export to excel any of the reports that come with RTC (i.e open vs Closed work items) graphics are not showing, instead I'm getting this xml:
<?xml version="1.0" encoding="UTF-8" ?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author />
<Title />
<Description>Licensed Materials - Property of IBM (c) Copyright IBM Corporation 2006, 2007. All Rights Reserved. Note to U.S. Government Users Restricted Rights: Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.</Description>
<Subject />
</DocumentProperties>
<Styles>
<Style ss:ID="HyperlinkId" ss:Name="Hyperlink">
<Font ss:Color="#0000ff" />
</Style>
<Style ss:ID="1">
<NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM" />
</Style>
<Style ss:ID="21">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1" />
<Borders>
<Border ss:Position="Bottom" />
<Border ss:Position="Top" />
<Border ss:Position="Left" />
<Border ss:Position="Right" />
<Border ss:Position="DiagonalLeft" />
</Borders>
<Font ss:FontName="sans-serif" ss:Size="9.0" ss:Color="#666666" />
</Style>
<Style ss:ID="20">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1" />
<Borders>
<Border ss:Position="Bottom" />
<Border ss:Position="Top" />
<Border ss:Position="Left" />
<Border ss:Position="Right" />
<Border ss:Position="DiagonalLeft" />
</Borders>
<Font ss:FontName="sans-serif" ss:Size="12.0" ss:Color="#333333" />
</Style>
</Styles>
<Worksheet ss:Name="Report">
<ss:Table>
<ss:Column ss:Width="432.0" ss:AutoFitWidth="0" />
<ss:Column ss:Width="5.888" ss:AutoFitWidth="0" />
<Row ss:AutoFitHeight="1">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="1">
<Data ss:Type="String">Open work items by type</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="1">
<Data ss:Type="String">About this report</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:Index="1" ss:StyleID="21" ss:MergeAcross="1">
<Data ss:Type="String">Iterations: R&CM Adoption Phase 2, PMP Release 11.5, CTAX Release 1.0, Hub Reports Release 1.0, SMA Release 1.0, Mailers Release 1.0, PMO, R&CM Release X.X Iteration, Nexus Release 1.0, GBS Hub 10.2, GTS Hub 10.2, OOBT FP Release 2.6.3, TMF Iteration, SLIC Release 3.9, CLD Release 3.7.06</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:Index="1" ss:StyleID="21" ss:MergeAcross="1">
<Data ss:Type="String">Report Generated Jan 20, 2014 5:09:28 PM EST</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:Index="1" ss:StyleID="21" ss:MergeAcross="1">
<Data ss:Type="String">Last Data Snapshot: Jan 20, 2014 12:05:39 AM EST</Data>
</Cell>
</Row>
</ss:Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<PageMargins x:Bottom="1.0" x:Left="1.25" x:Right="1.25" x:Top="1.0" />
<Header />
<Footer />
</PageSetup>
<Print>
<PaperSizeIndex>9</PaperSizeIndex>
</Print>
</WorksheetOptions>
</Worksheet>
</Workbook>
Is this the expected behaviour? Isn't it possible to export the reports to excel?
Regards,
Accepted answer
One other answer
Symptom