Home » Developer & Programmer » Reports & Discoverer » Report Header
Report Header [message #179868] Thu, 29 June 2006 02:31 Go to next message
yram
Messages: 75
Registered: February 2001
Member
Hi

I am generating a report based on the sex using the dept1, emp1

table dept1
column
deptno, dname,lco

table emp1
deptno,empno,ename,sex

the input parameters sex is 'M' or 'F'

i wanted to display the report HEADER like this

Number of MALE emplyoee's

the MALE and FEMALE should vary depending upon by parameter values 'F','M'

Regards
Yram




Re: Report Header [message #180259 is a reply to message #179868] Sun, 02 July 2006 06:45 Go to previous message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member
I think you are new in oracle Reports,
ok i will tell you,
on the behalf of your parameter "sex" make a summary column
at report level and Count emp_code/emp_name whatever you want,
and display it on the header section.
Razz
Previous Topic: Reports.log
Next Topic: Microsoft Excel
Goto Forum:
  


Current Time: Sun Jun 30 11:06:51 CDT 2024