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
Visible and Unvisible when Needed
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest