OraFAQ Forum: Reports & Discoverer » group by not working properly

Home » Developer & Programmer » Reports & Discoverer » group by not working properly (Oracle reports 6i,orcle 10g)

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

group by not working properly [message #399400]

Wed, 22 April 2009 01:42

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Hi all,
as we have a requirement to display
all the members & guests registration

we are grouping the column at the layout model not at the sql command level.

If i am grouping the attendee_names(guests)with member_names

its displaying only the member_name along with their guest names but not the guest contents.

My requirent is:

member_name count()
Sriram 1
sekhar 1

But my output is like

member_name count()
Sriram 1
sekhar

bold are member_name and normal are guest names
Please let me know if any required. please tell me if this is not in the form of readable

thank you
Sriram

Report message to a moderator

Re: group by not working properly [message #399530 is a reply to message #399400]

Wed, 22 April 2009 15:10

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

Senior Member
Account Moderator

Your example seems to be (over)simplified. If it is possible, could you provide a small test case (CREATE TABLE and INSERT INTO several sample records), as well as the RDF file based on that sample so that we could see what you've done?

Because, current problem description isn't clear enough (to me, that is).

Report message to a moderator

Re: group by not working properly [message #399931 is a reply to message #399530]

Fri, 24 April 2009 10:07

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

@ Littlefoot ,
Thank for your reply.i solved my problem.
Actually the problem is with the layout model not because of the query.One more repeting frame( which is not required) is there.

Thanks & regards
Sriram.

Report message to a moderator

Previous Topic:	where is the problem?
Next Topic:	Font size change during printing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:54:15 CDT 2024