Home » Developer & Programmer » Reports & Discoverer » i need landscape view
i need landscape view [message #184568] Thu, 27 July 2006 01:44 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
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
Re: i need landscape view [message #184885 is a reply to message #184568] Fri, 28 July 2006 08:49 Go to previous message
oraanu
Messages: 22
Registered: September 2005
Location: Boston
Junior Member
In Mainsection properties set the properties like

width 11
height 8.5
and orientation landscape

good luck,

Anu
Previous Topic: report builder 6.0
Next Topic: Matrix reports in Dev. 6i
Goto Forum:
  


Current Time: Fri Nov 08 18:38:55 CST 2024