Header Text Not showing up in Export to Excel

27 Views

I modified my template to show some text data but when I run it only my data shows up.

Here is my template:

<bi:QUERY_VIEW_DATA_PROVIDER name="DP_1" >

<bi:INITIAL_STATE type="CHOICE" value="QUERY" >

<bi:QUERY value="" />

</bi:INITIAL_STATE>

</bi:QUERY_VIEW_DATA_PROVIDER>

<bi:TEMPLATE_PARAMETERS name="TEMPLATE_PARAMETERS" >

<bi:WINDOW_MODE value="inplace" />

</bi:TEMPLATE_PARAMETERS>

<bi:GROUP_ITEM name="GROUP_EXPORT" designheight="600" designwidth="676" >

<bi:CHILD_ITEM_REF value="CONTAINER_EXPORT" />

<bi:WIDTH value="676" />

<bi:HEIGHT value="600" />

<bi:GROUP_DESIGN value="SAPCOLOR" />

<bi:WITH_CAPTION type="CHOICE" value="" text="" />

<bi:CONTAINER_ITEM name="CONTAINER_EXPORT" designwidth="600" designheight="600" >

<bi:WIDTH value="600" />

<bi:HEIGHT value="600" />

<bi:TEXT_ITEM name="MY_TEXT" designheight="70" designwidth="400" >

<bi:TEXT_BINDING type="CHOICE" value="TEXT_CONTENT" >

<bi:TEXT_CONTENT value="Mikes Text" />

</bi:TEXT_BINDING>

<bi:TEXT_DESIGN value="HEADER2" />

</bi:TEXT_ITEM>

<bi:ANALYSIS_ITEM name="ANALYSIS" designwidth="400" designheight="200" >

<bi:VISIBILITY value="VISIBLE" />

<bi:DATA_PROVIDER_REF value="DP_1" />

</bi:ANALYSIS_ITEM>

</bi:CONTAINER_ITEM>

</bi:GROUP_ITEM>

So what I'm expecting to see in the spreadsheet is:

Mikes Text

Columns and Rows of data in the spreadsheet

Mike