Sum function do not work in oracle reports enhanced spreadsheet format

Advertisement

we are using oracle reports 10.1.2.3 in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel.First we thought that it may be because of the comma in the number filed.we removed that comma from the filed but t still gives the error "Error in value"

Advertisement

Hi,
I hope you already solved this problem, I had the same issue after spending an hour I found the workaround, this is just for the guys who experience the same issue. Try to format your number columns either at database level(not via Report builder property palette) with TO_CHAR(...) OR use this Format Mask at Report level to format your numbers -NNNGNNNGNN0D000(negative sign must be there to avoid space in output Excel).
Hope it helps,
Regards,
Syed Khawar

October 11, 2015

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports 10.1.2.3 in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

FormatTrigger on line is not working in Oracle Reports

Hi there, I am using Oracle Reports 6i and trying to format code as follows : I have three sections of data say a,b,c. 1) If there is no data returned in Section b and c, then I need to print a line just after section a ends. 2) If there is no data i

Crystal Report for VS2010 - The Go To Page function does not work

When running a report into Crystal(VS2010), the Go To Page function does not work.  Typing in a page number and pressing Enter does not take you to that page.  The report remains on the current page. I'm not sure if there is suppose to be a button li

Triggers not working in Oracle 9iAS

The form triggers are not working in oracle 9i AS. My Application server has Linux operating system with oracle form/report server installed. I am able to upload the form in the client machine (using Internet Explorer Win98 OS). Also i can feed in th

Function Module not working for old Role

Dears Function Module not working for old Role Function Module: /VIRSA/BAPI_AE_USERS_FOR_ROLES Before EHP4 upgrade this functional module working fine, but after updated users are not visible. We have chekced if the users are assigned directly users

Autofill function is not working, 'window' sticks through it not functional!

autofill function is not working, 'window' sticks through it not functional!Back up all data, then test after each of the following steps that you haven't already tried. Stop when the problem is resolved. 1. Quit and relaunch Safari. 2. Select your c

Select * from tab is not working in oracle 10g

select * from tab is not working in oracle 10g. But at the same time, select * from <<table>> is working. Please advise me.This works for me in 10.2.0.2 Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

After upgraded ios6 i got problem with whatapp. "last seen" function is not working

HI eveyone after upgraded ios6 i got problem with whatapp. "last seen" function is not working .. it's doest show last seen who enter the chat . is anyone have the same problem .. i even restore and reinstall to my ph but it's  not work .. if so

Radio button and associated functionality is not working!

Hi Pros, I am facing the following problem: 1.I have an interactive PDF created in Acrobat 9 Pro. 2.PDF have few radio buttons, each radio buttons ahave assigned valus(eg: 1,2,3 etc) 3.I have a text box in which the value of selected radio button is

The auto lock function is not working on the iphone 3gs running ios 6...what should i do?

the auto lock function is not working on the iphone 3gs running ios 6...what should i do?Temporary fix - turn off assistive touch if you happen to have it on.Read other 2 answers

My search function does not work. How can I fix it?

Hello I need help I just bough a macbook 13 inch, with snow leopard and the search function does not work. The window opens but when I write the name i searh it gives me no results. How can i fix it? Do i need really to re install all snow leopard? t

HT201335 when using apple tv with my ipad, the mirroring function does not work, screen goes black, what is the issue?

when using apple tv with my ipad, the mirroring function does not work, screen goes black, what is the issue?  My son's Ipad(same as kind as mine) works ok with the apple tv but mine does not.  Any suggestions?Hello Nina Izurin, While written for the

Push function is not working

Hi The Mail push function is not working properly. Sometimes it works for a couple of day, sometimes it is not working anymore. Do anybody know a solution for this? Thanks,Make sure you have ticked the Tap to Click option under Trackpad in your Syste

Runtime.exec()  in Java not working in Oracle 10 Application Server

Hi , I am trying to call a .exe file which is in the Web Application folder . I am Using Process p = Runtime.exec("path to .exe file ") This code is working fine when used with JBOSS , but not working with Oracle Application server . Please tell

Oracle Report in PDF format

Hi, After upgrading from 11.5.7 to 11.5.10 Oracle Report in PDF format is not working(it was working fine in 11.5.7). When change output format to TEXT it working fine. Please advise? Thanks DaveHi, Perhaps it is not clear about what are the invalid

Highligh current row not working for classic report in 4.1

Hello experts, One of our customers is migrating applications from APEX 3.0 to 4.1. All their applications use classic reports because interactive reports didn't exist in 3.0. The end users of the applications like the row color changing when they ho

CASE function is not working

Hi, I want to use the CASE function in a sql statement used at form level but it's not working. I can't compile the form. I am using developer 6i at font end and Oracle 10g database at back end. Is it possible to use case function at form level sql s

Drill down report not working in 1og report

hi all, Drill down report not working in 1og. in 6i it working good but 10g not working . plz help any one. thanksHello, For detailled instructions about hyperlinks : Oracle® Reports Building Reports 10g Release 2 (10.1.2) B13895-01 3.6.10.1.8 Creati

"Execute" is not working in web reports

Friends, " Execute" link is not working in web my report. And also the selection screen is blank for style sheets. Do you have any idea about the cause? JoeAlso check this https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/webcontent/uuid/43

Greater function(Arithmetic) not working in graphical mapping

Hi SapAll. in an Idoc To File Interface i have got a requirement where i need to compare occurance of two child segments  G02,G02 Under parent Segment G01 and then determine the occurance of target Record Structure. the IDOC structure is   G01