FormatTrigger on line is not working in Oracle Reports

Advertisement

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 in section c but section a and b have data, then line should not appear after section a, but after section b
3) If all sections are having data , then line should appear after section c.
Format trigger for after section A
function B_2FormatTrigger return boolean is
begin
declare
ret_val boolean;
begin
ret_val := false;
if :CS_MATERIAL_TERMS = 0 and :cf_mh_count = 0 then
   ret_val := true;
end if;
return ret_val;
end;
end;
format trigger after section B
function B_4FormatTrigger return boolean is
begin
declare
ret_val boolean;
begin
ret_val := false;
if :CS_MATERIAL_TERMS = 0  and :cf_mh_count <> 0 then
   ret_val := true;
end if;
return ret_val;
end;
end;
format trigger after section C
function B_9FormatTrigger return boolean is
begin
  return (TRUE);
end;
:CS_MATERIAL_TERMS = is the summary column which defines data in section C
:cf_mh_count= is the formula column which defines the data in section B
current issue is that.. in some cases the line is appearing after section A, though section B has data
Please help...
Thanks.

Advertisement

Hi Hari,
hope all deadline related work is present in QA, say if you using Factory calendar, is the factory calendar present in QA also.
try refreshing buffer using SWU_OBUF.
Hope it helps.
Aditya

October 11, 2015

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

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

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

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

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

PreparedStatement not working with Oracle

Hi All, I am using preparedStatement in my JDBC code to fetch/insert values from oracle9i database. I am checking condition like if a given record does not exist then insert it else update it. First time it works when there is no row in database, how

Line-in not working with Xfi extreme audio pci-e

Hi, im trying to play my xbox360 on my computer, the video with my winfast dtv000T is ok, but whenI try to get the sound by connecting the xbox360 sound in one of the two mic/line-in I get nothing (tried in K!TV, Winfast PVR, DScaler). Im running XP

Ctrl+Z fuctianlity is not working in oracle 10g Form

Hi I am using oracle 10g form and using Edit_TextItem to invoke Text Editor When i using CTRL+Z to undo things in editor it is not working but it works when i used Form6i. Please help me to solve this issue. i need to this functinality to be work. BR

Urgent:output for line item not working

hi we are trying to get the output at item level in the sales order.we click on the line item and give a print out..but it is showing details of other line items as well. is there a ways we can get a printout for only the selected line items. what we

Sound input (line-in) not working after upgrade to Leopard

I have upgraded my iMac Intel Core 2 Duo (white plastic frame version) to Leopard on Friday when it released. The upgrade process went very well with one MAJOR exception: Audio input through "Line-in" connection does not work anymore. I have tri

PUSH_PRED  hint is not working in Oracle 9

1) PUSH_PRED hint is not working. 2) Do we need to set any parameters of the optimizer to make it to work. Can you please guide ?Shouldn't need to set any parameters.. can you provide more information? And here's an article from Jonathan, maybe it'll

Line In Not working with skype mic anymore

Sorry here is another question. I was using a headset mic with skype. It was working just fine until I did an update now the line in is no longer working. I am a professional sound guy and I understand the difference between line in and mic in and I

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

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

Audio Line-In Not Working

I was trying to record through my line-in and nothing was happening. I selected line-in under system preferences and in Garageband's preferences and nothing. The built in iMic works, however it sounds like crap, as i'm sure you all know. I thought it

Client_ole not working on oracle forms 11g

hello,,, I have configured webutil in forms 11g ( Doc ID : 1093985.1) step by step and finally i installed webutil demo from ( Doc ID : 1272222.1) When I test it works fine , everything works fine except OLE --> write to MS Word , when i enter some t

Line in not working on Zen V P

Hi I have a 4gb Zen V Plus, which has been working fine, but for the first time today I tried using line-in to record sound from the PC. Analogue, nothing fancy (don't have a proper sound card, just "on-board sound"). I can hear sound from the P

DDE.initiate is not working in oracle forms 10g

Previously i have used DDE for uploading the data from excel to DB in oracle forms 10g.now it is throwing non-oracle exception at DDE.intiate. could you please help me to solve this issue. i use the below code APPLICATION := OLE2.CREATE_OBJ('EXCEL.AP

Why have all 3 airport express base stations stopped working, BT have checked and improved line still not working?

Why have all 3 airport express base stations stopped working, other users are on ipads and BT have checked and improved line but I still have an intermittent/no connection?You must tell us the whole setup.. what is the main router?? How are the expre