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
ret_val := false;
if :CS_MATERIAL_TERMS = 0 and :cf_mh_count = 0 then
ret_val := true;
format trigger after section B
function B_4FormatTrigger return boolean is
if :CS_MATERIAL_TERMS = 0 and :cf_mh_count <> 0 then
format trigger after section C
function B_9FormatTrigger return boolean is
: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