OraFAQ Forum: Reports & Discoverer » Getting Sum of Student gender wise...

Home » Developer & Programmer » Reports & Discoverer » Getting Sum of Student gender wise...

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

Getting Sum of Student gender wise... [message #602300]

Mon, 02 December 2013 21:43

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

Senior Member

Main Query:
SELECT count(STUDENT.STUID), STUDENT.CLASS, STUDENT.GENDER
FROM STUDENT
where student.status='PRESENT'
group by gender,class
..................................................................
/forum/fa/11342/0/

In this picture male has two groups.i want to merge into one male group. report type is matrix.. please advised..

Attachment: 123.JPG
(Size: 37.85KB, Downloaded 3219 times)

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602311 is a reply to message #602300]

Tue, 03 December 2013 01:03

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

Senior Member
Account Moderator

Why do you have two MALEs? What does your query return while executed in SQL*Plus? Two MALEs as well? Maybe one of them isn't really "MALE" but "MALE_" (_ representing a space character) (or similar). Fix that, and report will look allright.

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602317 is a reply to message #602311]

Tue, 03 December 2013 03:06

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

Senior Member

please advised..
how i can remove this thing as shown in figure. i have useed replace function but it could do anything..
/forum/fa/11348/0/

Attachment: untitled.JPG
(Size: 37.70KB, Downloaded 3022 times)

[Updated on: Tue, 03 December 2013 03:32]

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602332 is a reply to message #602317]

Tue, 03 December 2013 04:23

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

Senior Member
Account Moderator

Find out which character it is (with the DUMP function); then RTRIM it off.

SQL> with test as
  2    (select 'malex' gender from dual)
  3  select dump(gender),
  4         rtrim(gender, chr(120)) result
  5  from test;

DUMP(GENDER)                     RESU
-------------------------------- ----
Typ=96 Len=5: 109,97,108,101,120 male

SQL>

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602342 is a reply to message #602332]

Tue, 03 December 2013 04:35

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

Senior Member

this query work fine in SQL * Plus but not in reports...i have used it but how i can commit this change. when i type commit command it gives 0 row updated.

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602344 is a reply to message #602342]

Tue, 03 December 2013 04:39

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

Senior Member
Account Moderator

I don't know which query is "this query".

Besides, consider creating a check constraint on the GENDER column so that only MALE and FEMALE (or any other sex you want to allow) can be entered into that column.

Report message to a moderator

Re: Getting Sum of Student gender wise... [message #602345 is a reply to message #602342]

Tue, 03 December 2013 04:39

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

Senior Member

thx Littlefoot i have got the soultion upon your guidence.

Report message to a moderator

Previous Topic:	Serial Number Field
Next Topic:	Displaying 0 in cells with no values in a matrix report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 17:28:56 CST 2025