OraFAQ Forum: Reports & Discoverer » Oracle report oped by Excel cannot sum on number columns

Home » Developer & Programmer » Reports & Discoverer » Oracle report oped by Excel cannot sum on number columns (EBS 12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle report oped by Excel cannot sum on number columns [message #668265]

Thu, 15 February 2018 11:21

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!

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Problem to generate report of multiple pages in single PDF
Next Topic:	Unicode (Bangla )Font Broken After Generate to PDF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:11:55 CST 2025