Link in report breaks when I save as Excel in WebI

I have links in a column in my report that appear correctly when viewed in Full Client and WebI. I see the Item ID underlined in blue (violet after clicked).

="<!begin><A HREF="&amp;Char(34)&amp;"http://erbi.tdc.cingular.net/bi/CDC_Order_Visibility_Details_For_WebI.jsp?ItemId="&amp;<ITEM_ID(count backordered qty by item)>&amp;Char(34)&amp;">"&amp;<ITEM_ID(count backordered qty by item)>&amp;"</A><end>" 

When I save the report as Excel in Webi the links expand to the full HTML code in the column in Excel.

Is there a way to nudge Excel into displaying the link “normally” without breaking it in Full Client/WebI?


zing (BOB member since 2002-11-01)

This is a bug with enterprise-6, 6.1.a.

It has been resolved in 6.1.b (You need to define the cell type as “Hyperlink”)


i_amit123 :india: (BOB member since 2002-10-09)