Visible and Unvisible when Needed

[najm]

I have a Report and In the header of a report the data is like this (1st)

Program:MBA
Major:MIS
Start Date:1-Jan-2003
End Date:1Dec-2005

another format of a data is this (2nd)
Program:B.Com
Major:
Start Date:1-Jan-2003
End Date:1Dec-2005

as we saw there is no major in the 2nd data where as there is a major in the 1st data if you think it is not looking good.

my requirement is that i want if there is no major then the start date moves with head to the major location and End Date moves to the Start Date Location. and the Data shows like this of a 2nd is

Program:B.Com
Start Date:1-Jan-2003
End Date:1Dec-2005

It's Look Better
Please Can any one resolve my this issue

Thanks

Cheers

[admin]

Use conditional formatting hope would be useful. thanks

[ahmadbilal]

select 'Major:'||major as major,'Program:'||programe as programe from tablename

and then apply condational formating on major,programe field to hide this when return null in major

if anybody have another idea then please post

[najm]

I use the following Formula Column for replace Major to Start Date

function CF_5Formula return Char is
PTITLE2 varchar2(60);
begin
select PR.PTITLE
into PTITLE2
FROM STPROGRAMDET P, TRANSCRIPT TR, PROGRAM PR
WHERE TR.SNO = P.SNO
AND PR.PCODE = P.PCODE
AND TR.PCODE = PR.PCODE
AND P.SNO = _SNO
AND P.PCODE = _PCODE
AND TR.SR =:P_SR;
return PTITLE2;
exception
<i><b>when others then return :Start_Date </b> </i> ;
end;

but on Start Date i am unable to get End Date and unable to do End Date Null.

If do not understand please let me know.

[rtoogee]

If the output of report is text, you can use format trigger to visible or invisible.

If the output is rtf template, you can use conditional formatting