Home » Developer & Programmer » Reports & Discoverer » group by not working properly (Oracle reports 6i,orcle 10g)
group by not working properly [message #399400] Wed, 22 April 2009 01:42 Go to next message
ramoradba
Messages: 2454
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
Re: group by not working properly [message #399530 is a reply to message #399400] Wed, 22 April 2009 15:10 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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).
Re: group by not working properly [message #399931 is a reply to message #399530] Fri, 24 April 2009 10:07 Go to previous message
ramoradba
Messages: 2454
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.
Previous Topic: where is the problem?
Next Topic: Font size change during printing
Goto Forum:
  


Current Time: Wed Dec 07 16:43:07 CST 2016

Total time taken to generate the page: 0.08880 seconds