OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » count student

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

count student [message #689914]

Sat, 27 July 2024 03:26

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

please see the attached file. i want to count student from aging column as:

Aging Month    No of student
1              6
2              10
3              7
4              2
5              2
and so on

.please advise me the query.
/forum/fa/14803/0/

Attachment: 1.jpg
(Size: 195.43KB, Downloaded 722 times)

Report message to a moderator

Re: count student [message #689920 is a reply to message #689914]

Sun, 28 July 2024 11:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which rules have to be applied to source data (image you posted) to get result you want? At the first glance, I (wrongly, it seems) though that it is an ordinary counting grouped by aging month, but - sample data doesn't support my thoughts. Therefore: rules, please.

Report message to a moderator

Re: count student [message #689922 is a reply to message #689920]

Mon, 29 July 2024 23:58

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

the aging month is the no of month which is unpaid/pending by student. i want to count student which is pending by month.
please see the attached file.it mean how many student is pending in 1-month. how manyu studet is pending in 2-months.and so on.
/forum/fa/14804/0/

Attachment: 212.jpg
(Size: 19.07KB, Downloaded 654 times)

Report message to a moderator

Re: count student [message #689932 is a reply to message #689922]

Fri, 02 August 2024 01:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I still don't understand it. How does 212.jpg support what we see on 1.jpg?

As I said, at first glance it looks like

select aging_month, count(*)
from that_table
group by aging_month

Is that what you're looking for? If not, do post test case (CREATE TABLE and INSERT INTO statements) and result you expect based on sample data you posted.

Report message to a moderator

Previous Topic:	frm-41214: unable to run report
Next Topic:	IMAGE IN REPORT (3 merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 07:47:25 CST 2025