Home » Developer & Programmer » Reports & Discoverer » Oracle report oped by Excel cannot sum on number columns (EBS 12)
Oracle report oped by Excel cannot sum on number columns [message #668265] Thu, 15 February 2018 11:21 Go to next message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
I have an Oracle rdf/xml/rtf report, and the user wants to open it with Excel. Everything looks good except the number columns can not be summed up.
Experts please help!
Re: Oracle report oped by Excel cannot sum on number columns [message #668266 is a reply to message #668265] Thu, 15 February 2018 12:22 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
jwang02 wrote on Thu, 15 February 2018 09:21
I have an Oracle rdf/xml/rtf report, and the user wants to open it with Excel. Everything looks good except the number columns can not be summed up.
Experts please help!
Why are you posting about a problem you have with Excel in this Oracle forum?

I suspect that more characters than just numeric digits exist within Excel cell.
Re: Oracle report oped by Excel cannot sum on number columns [message #668267 is a reply to message #668265] Thu, 15 February 2018 12:23 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Reported message:
Quote:
I need this issue resolved this week.
So hire a consultant, no one here owes you anything, you have not to command us to give you solution.

Re: Oracle report oped by Excel cannot sum on number columns [message #668364 is a reply to message #668266] Mon, 19 February 2018 15:44 Go to previous messageGo to next message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
This is something related to Oracle report that originally is read-only EBS report. It does not care to return text or number. After converted some functions from text to number, those columns can be summed up. Bu the formats are still not good enough.
Re: Oracle report oped by Excel cannot sum on number columns [message #668365 is a reply to message #668267] Mon, 19 February 2018 15:56 Go to previous message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
Michel Cadot wrote on Thu, 15 February 2018 12:23

Reported message:
Quote:
I need this issue resolved this week.
So hire a consultant, no one here owes you anything, you have not to command us to give you solution.

You don't have to do that.
Previous Topic: Problem to generate report of multiple pages in single PDF
Next Topic: Unicode (Bangla )Font Broken After Generate to PDF
Goto Forum:
  


Current Time: Mon Sep 21 15:04:58 CDT 2020