Home » Developer & Programmer » Reports & Discoverer » reports--order by not working in group level 2
reports--order by not working in group level 2 [message #88842] Tue, 29 April 2003 10:50 Go to next message
Messages: 63
Registered: January 2001
hi all!!!
i have create a report which is a group above---
three groups i have made
(1) first group have-->
(2) second group have -->
sales person name
(3) third group have
visit date
out come

i want that user select the order in which data displayed by company name or sales person name or by visit date wise
for this i pass the parameter through parameter form

by writing query
order by :p_order

but data displayed in order of company name only might be because of company group is higher(group level 1) and all other at group level2 and 3...
plz suggest me how can i got the result desired order...

Re: reports--order by not working in group level 2 [message #88862 is a reply to message #88842] Tue, 20 May 2003 05:49 Go to previous message
Messages: 324
Registered: January 2003
Senior Member
dont use groups since you want to decide the order by.
put the whole code in one group with a dynamic order by
you might create your own breaking groups in the layout editor but the main sql stays in 1 group.
Previous Topic: Urgently Required Help Depandable Parameters
Next Topic: please print... please ;-( hellllllp brothers
Goto Forum:

Current Time: Tue Sep 26 19:55:47 CDT 2023