BI Publisher (MOSC)

MOSC Banner

BI Excel Report - Character text is being converted to Date in excel

edited Dec 6, 2010 12:11AM in BI Publisher (MOSC) 5 commentsAnswered
 Hi,
I am creating a BI excel report where the xml data comes from the rdf report. The excel report contains a column of Inventory Item number which is a character field. When I open the report in excel, the field is being converted to date in excel report. For example, the sample item number is 11-01 and in the excel report it's being converted as Nov-01 . I have used <?xdofx:to_char(INVENTORY_ITEM)?>, but it's not working.

Any suggestion would be very helpful.


Thanks,
Sudheer

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center