Home » Developer & Programmer » Reports & Discoverer » Count no of record
Count no of record [message #615662] Fri, 06 June 2014 10:00 Go to next message
shahzad-ul-hasan
Messages: 340
Registered: August 2002
Senior Member
i want to count no of records as per shown in the figure.
./fa/11921/0/
please see the attached file also.

[Updated on: Fri, 06 June 2014 10:01]

Report message to a moderator

Re: Count no of record [message #615663 is a reply to message #615662] Fri, 06 June 2014 10:02 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 340
Registered: August 2002
Senior Member
./fa/11923/0/
Re: Count no of record [message #615678 is a reply to message #615663] Fri, 06 June 2014 15:52 Go to previous messageGo to next message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
select 
  grade, 
  decode(grade, 'E', '33-39',
                'D', '40-49',
		'C', '50-59',
		'B', '60-69',
		'A', '70-79',
		'A+','80% and above'
        ) pct,
  count(*) no_of_students
from your_table
group by   
  grade, 
  decode(grade, 'E', '33-39',
                'D', '40-49',
		'C', '50-59',
		'B', '60-69',
		'A', '70-79',
		'A+','80% and above'
        );
Re: Count no of record [message #615682 is a reply to message #615678] Fri, 06 June 2014 22:01 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 340
Registered: August 2002
Senior Member
please advised how i can apply this into reports 6i.
Re: Count no of record [message #615713 is a reply to message #615682] Sat, 07 June 2014 15:10 Go to previous messageGo to next message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Exactly as it is written.
Re: Count no of record [message #615750 is a reply to message #615713] Sun, 08 June 2014 21:38 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 340
Registered: August 2002
Senior Member
in formula column.please advised.at SQl it WORKS FINE...
Re: Count no of record [message #615757 is a reply to message #615750] Mon, 09 June 2014 01:28 Go to previous message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you need a formula column? I prefer putting everything into a query itself, and use formula columns only when necessary.

Anyway: formula column returns a single value, depending on certain parameters it accepts. I don't know which values you want to pass to it (and use them in a WHERE clause), but you might.
Previous Topic: Arabic Language not show in oracle reports 11G
Next Topic: shift an object
Goto Forum:
  


Current Time: Fri Oct 31 18:53:17 CDT 2014

Total time taken to generate the page: 0.12328 seconds