I have a design studio cross tab report and I have a button for export to excel.
I have field which is numeric in data type in database and when in universe made as numeric displays fine in design studio cross tab. But when exported to excel shows as 0.0000.
I made a copy of the object and made it string and it displays fine in design studio cross tab but in format x.0 and when exported exports to excel as right number but as a string with x.0 format.
I just want it to display it as x format?
has anyone had this issue.
Attached screen shot of the details.
Please advise???
Thanks!!
hourigan (BOB member since 2007-04-06)