Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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,

0 votes


Accepted answer

Permanent link
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

2 votes


One other answer

Permanent link

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.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 230

Question asked: Jan 20 '14, 5:34 p.m.

Question was seen: 6,158 times

Last updated: Dec 21 '20, 7:39 a.m.

Confirmation Cancel Confirm