Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Exporting report formating error.
zac
Hello,
I've created a report with BIRT 2.5.2. I can view the report fine and export it to CSV, however when I want to display the file in Excel it comes back with an error. It mentions a log file under "Local Settings" but I can't find the log file.
How can I debug such an error?
Also when I tried to export to word or pdf, the format layout is not respected. I'm using an "Auto Layout" in BIRT but Word or Adobe display in portrait mode by default cutting off most of the report. Is there a way to adjust the report width for Word/PDF?
Thank you in advance for your help.
Find more posts tagged with
Comments
mwilliams
If you're designing the report for a fixed page output, like word and pdf, you should probably use the fixed layout.
As for the CSV export, I just tried exporting to CSV with 2.5.2 and had no issues. Can you reproduce the issue, in a report that I can run, and attach it in here? Thanks!
zac
Thank you very for your reply and help. <br />
I tried to attach the xml file but I got an upload error please find it below. It cannot be opened with Excel 2003 or higher.<br />
Thanks again for your time.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><?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/>
<Subject/>
</DocumentProperties>
<Styles>
<Style ss:ID="HyperlinkId" ss:Name="Hyperlink">
<Font ss:Color="#0000ff"/>
</Style>
<Style ss:ID="58">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="56">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<NumberFormat/>
</Style>
<Style ss:ID="33">
<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="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#ffffff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="48">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</Style>
<Style ss:ID="46">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
<NumberFormat/>
</Style>
<Style ss:ID="37">
<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="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#0000ff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="42">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Underline="Single" ss:Color="#0000ff"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="27">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="22">
<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="10" ss:Color="#666666"/>
</Style>
<Style ss:ID="31">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="10" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#c0c0c0" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="40">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="52">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</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="10" ss:Color="#666666"/>
</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="12" ss:Bold="1" ss:Color="#666666"/>
</Style>
<Style ss:ID="36">
<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="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#0000ff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="54">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</Style>
<Style ss:ID="49" ss:Parent="HyperlinkId">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Underline="Single" ss:Color="#0000ff"/>
</Style>
<Style ss:ID="44">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="61">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
<NumberFormat ss:Format="[$-409]MMM d, yyyy"/>
</Style>
<Style ss:ID="60">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
<NumberFormat ss:Format="[$-409]MMM d, yyyy"/>
</Style>
<Style ss:ID="26">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="53">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</Style>
<Style ss:ID="50">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Underline="Single" ss:Color="#0000ff"/>
</Style>
<Style ss:ID="51">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</Style>
<Style ss:ID="55">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<NumberFormat/>
</Style>
<Style ss:ID="47">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
</Style>
<Style ss:ID="30">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="10" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#c0c0c0" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="41" ss:Parent="HyperlinkId">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Underline="Single" ss:Color="#0000ff"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="43">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="39">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="23">
<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="10" ss:Bold="1" ss:Color="#666666"/>
</Style>
<Style ss:ID="45">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
<NumberFormat/>
</Style>
<Style ss:ID="57">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="28">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="10" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="1">
<NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM"/>
</Style>
<Style ss:ID="35">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#0000ff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="38">
<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" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#0000ff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="59">
<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="10" ss:Color="#000000"/>
</Style>
<Style ss:ID="62">
<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="10" ss:Color="#000000"/>
</Style>
<Style ss:ID="29">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="10" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="25">
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="10" ss:Bold="1" ss:Color="#000000"/>
<Interior ss:Color="#f3f3f3" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="32">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom"/>
<Border ss:Position="Top"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#ffffff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="34">
<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" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="DiagonalLeft"/>
</Borders>
<Font ss:FontName="sans-serif" ss:Size="8" ss:Bold="1" ss:Color="#ffffff"/>
<Interior ss:Color="#ffffff" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="24">
<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="10" ss:Bold="1" ss:Underline="Single" ss:Color="#666666"/>
</Style>
</Styles>
<Worksheet ss:Name="Report">
<ss:Table>
<ss:Column ss:Width="36" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="103" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="29" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="56" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="28" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="34" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="31" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="38" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="40" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="43" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="47" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="63" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="21" ss:AutoFitWidth="0"/>
<ss:Column ss:Width="0" ss:AutoFitWidth="0"/>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="12">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String">Report Generated Aug 27, 2012 5:54:19 PM</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String">List of prioritized Workstreams grouped by execution teams and sorted by Workstream's priority. Epics, Stories and Tasks are displayed as a tree of parent-child relationships.</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="12">
<Data ss:Type="String">Workstreams' state(s):</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String"> 'Execution','In-Take','Not Started','Requirements','Testing','Validate Completion'</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="12">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String"> Product Backlog, Batch Replication - Product Backlog, Illustrations - Product Backlog, eApplication - Product Backlog, Dashboard & Reports - Product Backlog</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="12">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="12">
<Data ss:Type="String"> You may change the report parameters such as iteration and execution teams by selecting the pencil icon located on the top right toolbar icons.</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="12">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="27">
<Data ss:Type="String">Number of Items found: 17</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="28">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="29">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="31">
<Data ss:Type="String">Priority</Data>
</Cell>
<Cell ss:Index="2" ss:StyleID="31">
<Data ss:Type="String">Workstream/Item Description</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="31">
<Data ss:Type="String">Type</Data>
</Cell>
<Cell ss:Index="4" ss:StyleID="31">
<Data ss:Type="String">Story Points</Data>
</Cell>
<Cell ss:Index="5" ss:StyleID="31">
<Data ss:Type="String">Status</Data>
</Cell>
<Cell ss:Index="6" ss:StyleID="31">
<Data ss:Type="String">Tentative Delivery Date</Data>
</Cell>
<Cell ss:Index="7" ss:StyleID="31">
<Data ss:Type="String">Funding Program</Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="31">
<Data ss:Type="String">Alignment Area</Data>
</Cell>
<Cell ss:Index="9" ss:StyleID="31">
<Data ss:Type="String">Tech Lead</Data>
</Cell>
<Cell ss:Index="10" ss:StyleID="31">
<Data ss:Type="String">Business Analyst</Data>
</Cell>
<Cell ss:Index="11" ss:StyleID="31">
<Data ss:Type="String">Project Manager</Data>
</Cell>
<Cell ss:Index="12" ss:StyleID="31">
<Data ss:Type="String">Notes</Data>
</Cell>
<Cell ss:Index="13" ss:StyleID="31">
<Data ss:Type="String">Rank</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="32">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="3" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="34">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="35">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="36">
<Data ss:Type="String">Exe Team: Batch-Replication</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="36">
<Data ss:Type="String">Total Story Points: 100 pts</Data>
</Cell>
<Cell ss:Index="5" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="38">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="40">
<Data ss:Type="String">High</Data>
</Cell>
<Cell ss:Index="2" ss:StyleID="42" ss:HRef="#auto_generated_bookmark_0">
<Data ss:Type="String">5318 - Workstream #1 - M Financial</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="40">
<Data ss:Type="String">Workstream</Data>
</Cell>
<Cell ss:Index="4" ss:StyleID="40">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="40">
<Data ss:Type="String">In-Take</Data>
</Cell>
<Cell ss:Index="6" ss:StyleID="40">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="40">
<Data ss:Type="String">M Financial</Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="40">
<Data ss:Type="String">Strategic Platform</Data>
</Cell>
<Cell ss:Index="9" ss:StyleID="40">
<Data ss:Type="String">Sukumar, Saravanan</Data>
</Cell>
<Cell ss:Index="10" ss:StyleID="40">
<Data ss:Type="String">MacKay, Grant</Data>
</Cell>
<Cell ss:Index="11" ss:StyleID="40">
<Data ss:Type="String">Lefeber, John</Data>
</Cell>
<Cell ss:Index="12" ss:StyleID="44">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="46">
<Data ss:Type="Number">1</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="48">
<Data ss:Type="String">High</Data>
</Cell>
<Cell ss:Index="2" ss:StyleID="50" ss:HRef="#auto_generated_bookmark_1">
<Data ss:Type="String">5440 - Epic #2</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="48">
<Data ss:Type="String">Epic</Data>
</Cell>
<Cell ss:Index="4" ss:StyleID="48">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="48">
<Data ss:Type="String">New</Data>
</Cell>
<Cell ss:Index="6" ss:StyleID="48">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="48">
<Data ss:Type="String">Inforce Conversion</Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="48">
<Data ss:Type="String">Legacy Platform</Data>
</Cell>
<Cell ss:Index="9" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="54">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="56">
<Data ss:Type="Number">2</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="40">
<Data ss:Type="String">Medium</Data>
</Cell>
<Cell ss:Index="2" ss:StyleID="42" ss:HRef="#auto_generated_bookmark_2">
<Data ss:Type="String">5798 - Story #5798</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="40">
<Data ss:Type="String">Story</Data>
</Cell>
<Cell ss:Index="4" ss:StyleID="40">
<Data ss:Type="String">100</Data>
</Cell>
<Cell ss:Index="5" ss:StyleID="40">
<Data ss:Type="String">New</Data>
</Cell>
<Cell ss:Index="6" ss:StyleID="40">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="40">
<Data ss:Type="String">Inforce Conversion</Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="40">
<Data ss:Type="String">Legacy Platform</Data>
</Cell>
<Cell ss:Index="9" ss:StyleID="58">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="58">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="58">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="44">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="46">
<Data ss:Type="Number">3</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="3" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="32">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="3" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="34">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="35">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="36">
<Data ss:Type="String">Exe Team: Dashboard & Reports</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="36">
<Data ss:Type="String">Total Story Points: NA</Data>
</Cell>
<Cell ss:Index="5" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="37">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="38">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="48">
<Data ss:Type="String">Medium</Data>
</Cell>
<Cell ss:Index="2" ss:StyleID="50" ss:HRef="#auto_generated_bookmark_3">
<Data ss:Type="String">6122 - New Dashboard requirements</Data>
</Cell>
<Cell ss:Index="3" ss:StyleID="48">
<Data ss:Type="String">Workstream</Data>
</Cell>
<Cell ss:Index="4" ss:StyleID="48">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="48">
<Data ss:Type="String">In-Take</Data>
</Cell>
<Cell ss:Index="6" ss:StyleID="48">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="48">
<Data ss:Type="String">M Financial</Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="48">
<Data ss:Type="String">Operations</Data>
</Cell>
<Cell ss:Index="9" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="52">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="54">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="56">
<Data ss:Type="Number">4</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="3" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="11" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="12" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="13" ss:StyleID="59">
<Data ss:Type="String"/>
</Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="15.0">
<Cell ss:Index="1" ss:StyleID="32">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="2" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="3" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="4" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="5" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="6" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="7" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="8" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="9" ss:StyleID="33">
<Data ss:Type="String"/>
</Cell>
<Cell ss:Index="10" ss:StyleID="33">
<Data ss:T
mwilliams
This is an XLS file. Is your issue with XLS or with CSV? When I save as XLS and open, I get an error with a message to check a log file. When I check the log file, here is what it says:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 2
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 3
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 4
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 5
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 6
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 7
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 8
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 9
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 10
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 11
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 12
XML ERROR in Table
REASON: Bad Value
FILE: C:\filePath\CSVIssue.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 13
</pre>
<br />
Can you reproduce this issue with the sample database or with a flat file source, so I can run the report?
zac
Thanks for following up on this. I got very busy and I'm planning to look into this by next week.
I generated this file by selecting Excel as an output. I'll let you know how it goes.
mwilliams
Sounds good! Just keep me up to date.
zac
fyi - I can now export to Excel without problems. I had some HTML statements that caused problems while exporting to Excel, even though the HTML statements were valid HTML (I was styling a TABLE)
mwilliams
Interesting. Glad you got it going! Let us know whenever you have questions!