ERPstuff - Oracle EBS Community

Hi master
Hi master
Sir I have many column I need landscape layout with A3 paper

I set orientation = landscape from system parameter and A3 from page setup but not give me at design time and give me landscape on printer or paper

Please give me idea I set all column in my report

Thanks
aamir

this is my query

SELECT TO_CHAR(STUJOURNAL.stujdate, 'YYYY') AS YEAR,DEPARTMENT.NAME,
COUNT(DISTINCT DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',STUSECMTAMT.STDCODE)) FALLs,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',STUSECMTAMT.totdebit)) FALLtotaldebit,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',STUSECMTAMT.totalcr)) FALLc,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',STUJOURNAL.cre_bal)) FALLcrebal,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',ROUND(NVL(STUJOURNAL.cre_bal/DECODE(STUSECMTAMT.totdebit/STUSECMTAMT.totalcr,0,NUL L,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) FALLreccrham,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))) FALLbalance,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'FALL',ROUND(NVL((NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))/DECODE(STUSECMTA MT.totdebit/STUSECMTAMT.totalcr,0,NULL,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) FALLbalcrham,
COUNT(DISTINCT DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',STUSECMTAMT.STDCODE)) SPRIs,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',STUSECMTAMT.totdebit)) SPRItotaldebit,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',STUSECMTAMT.totalcr)) SPRIc,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',STUJOURNAL.cre_bal)) SPRIcrebal,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',ROUND(NVL(STUJOURNAL.cre_bal/DECODE(STUSECMTAMT.totdebit/STUSECMTAMT.totalcr,0,NUL L,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) SPRIreccrham,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))) SPRIbalance,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SPRI',ROUND(NVL((NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))/DECODE(STUSECMTA MT.totdebit/STUSECMTAMT.totalcr,0,NULL,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) SPRIbalcrham,
COUNT(DISTINCT DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',STUSECMTAMT.STDCODE)) SUMMs,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',STUSECMTAMT.totdebit)) SUMMtotaldebit,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',STUSECMTAMT.totalcr)) SUMMc,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',STUJOURNAL.cre_bal)) SUMMcrebal,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',ROUND(NVL(STUJOURNAL.cre_bal/DECODE(STUSECMTAMT.totdebit/STUSECMTAMT.totalcr,0,NUL L,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) SUMMreccrham,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))) SUMMbalance,
SUM(DECODE(SUBSTR(STUSECMTAMT.sem_code,5,4),'SUMM',ROUND(NVL((NVL(STUSECMTAMT.totdebit,0)-NVL(STUJOURNAL.cre_bal,0))/DECODE(STUSECMTA MT.totdebit/STUSECMTAMT.totalcr,0,NULL,STUSECMTAMT.totdebit/STUSECMTAMT.totalcr),0),2))) SUMMbalcrham
FROM STUSECMTAMT,STUDEG,STUJOURNAL,DEPARTMENT,DEGREES
WHERE STUSECMTAMT.vhno=STUJOURNAL.ref_no
and STUSECMTAMT.studegid=STUDEG.studegid
AND DEGREES.degree_code=STUDEG.degree_code
AND DEPARTMENT.DEPTNO=DEGREES.DEPTNO
AND degrees.DEGREE_CODE NOT IN('SFC')
AND SUBSTR(STUJOURNAL.stdjid,1,3)='SPY'
GROUP BY TO_CHAR(STUJOURNAL.stujdate, 'YYYY'),DEPARTMENT.NAME

Dear Aamir

Dear Why u are repeating ur a single question in multiple Posts.

as i post the answer of ur above problem.
if u still not understand my reply then send me ur report i will solve ur problem and also tell u that what u was missing.


OK and please dont repeat ur question again.

Thanks

Muhamamd Kashif
kashifsbr@hotmail.com

Thanks Kashif.