It's all about the answers!

Ask a question

Exporting Report to excel is not showing graphic


Lorena Almela (1811517) | asked Jan 20 '14, 5:34 p.m.

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


permanent link
Rafik Jaouani (5.0k16) | answered Jan 20 '14, 5:39 p.m.
JAZZ DEVELOPER
The BIRT reporting engine only exports tables and text when exporting to Excel. Graphics are not exported. This is a limitation in the BIRT engine that RTC uses. You can always export in PDF format.
Lorena Almela selected this answer as the correct answer

One other answer



permanent link
Rick Bale (11) | answered Dec 21 '20, 7:39 a.m.

Symptom

The Microsoft Excel export file is created but contains no chart or image.

Cause
This is a known limitation in BIRT referenced in bugzilla as 198623: excel is not display images and charts

Resolving The Problem
The problem will remain until BIRT defect is fixed (and Rational Team Concert integrates this fix).

To work around this issue, manually copy and paste the chart and images from the source report to the Excel target export file.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.