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
|