p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Sorting in Crystal Reports


Message #1 by "Vimal Bhuptani" <vimal_bhuptani@r...> on 4 Jun 2002 11:29:52 -0000
Dear Friends,

i have created one report which displays the Date, No, Name, Place 
 From adn Place To...
and i want to sort the details with the Date.. and i have grouped 
my report.. with the Date.. but i am unable to get it in desending 
order.. as i have tried grouping by Year, Month, Day.. etc.. but 
stil the report is not setting in order..

is there any specific for Date.. if so pls tell me

waiting for ur reply
Vimal
_________________________________________________________
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs

Message #2 by "Christopher Reed" <CReed@m...> on Tue, 04 Jun 2002 07:56:28 -0500
Vimal,

On the design form, if you right-click in the left margin where your
group is, the menu will contain an item call Change Group...  From this,
you get the dialog box that lets change your group information.  Below
the field selection dropdown is another dropdown that will let you
change the ordering.  This should be what you are looking for.

Hope this helps!


Christopher Reed
Application Analyst
Web Development Coordinator
Information Technology
City of Lubbock
creed@m...
xxx-xxx-xxxx

>>> vimal_bhuptani@r... 6:29:52 AM 6/4/2002 >>>
Dear Friends,

i have created one report which displays the Date, No, Name, Place 
 From adn Place To...
and i want to sort the details with the Date.. and i have grouped 
my report.. with the Date.. but i am unable to get it in desending 
order.. as i have tried grouping by Year, Month, Day.. etc.. but 
stil the report is not setting in order..

is there any specific for Date.. if so pls tell me

waiting for ur reply
Vimal
_________________________________________________________
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs 
Message #3 by "Embrey, Darrell (DL)" <DLEmbrey@d...> on Tue, 4 Jun 2002 08:01:16 -0500
Hi Vimal,

What version of Crystal reports are you using? You state you already have
your report grouped by Date. The default order for grouping is Ascending. To
change the grouping order to Descending in version 8.x, move your cursor
over the group header tab in the design mode and right click the mouse.
Select Change Group... from the list. The Change Group Options modal window
displays the options for grouping. There are two drop-down lists in the top
portion of the window. One is the field the report is grouped on and the
other is for the grouping order. Select "in descending order." and then
click OK. Then save the report and your report should now be grouped by date
in descending order.

________________________________________
Darrell L. Embrey
Information Systems Technologist - Kelly Technical Services
On Assignment at The Dow Chemical Company
Legal Tech & Admin Services
1790 Building
Phone:   xxx-xxx-xxxx
Fax:   xxx-xxx-xxxx
E-mail:  DLEmbrey@d...


-----Original Message-----
From: Vimal Bhuptani [mailto:vimal_bhuptani@r...]
Sent: Tuesday, June 04, 2002 7:30 AM
To: crystal_reports
Subject: [crystal_reports] Sorting in Crystal Reports


Dear Friends,

i have created one report which displays the Date, No, Name, Place 
 From adn Place To...
and i want to sort the details with the Date.. and i have grouped 
my report.. with the Date.. but i am unable to get it in desending 
order.. as i have tried grouping by Year, Month, Day.. etc.. but 
stil the report is not setting in order..

is there any specific for Date.. if so pls tell me

waiting for ur reply
Vimal
_________________________________________________________
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs


Message #4 by "Tung Dang" <tdan@h...> on Tue, 4 Jun 2002 09:09:01 -0400
You can always check the SQL statement to see how crystal report is 
interpreting your query and to see if it's building it correctly.

I usually go to the report menu and select sort records.  There, I can 
specifically select which field(s) to order by.

Tung Dang
Database Admin
Haestad Methods
www.haestad.com

-----Original Message-----
From: Embrey, Darrell (DL) [mailto:DLEmbrey@d...]
Sent: Tuesday, June 04, 2002 9:01 AM
To: crystal_reports
Subject: [crystal_reports] RE: Sorting in Crystal Reports


Hi Vimal,

What version of Crystal reports are you using? You state you already 
have
your report grouped by Date. The default order for grouping is 
Ascending. To
change the grouping order to Descending in version 8.x, move your cursor
over the group header tab in the design mode and right click the mouse.
Select Change Group... from the list. The Change Group Options modal 
window
displays the options for grouping. There are two drop-down lists in the 
top
portion of the window. One is the field the report is grouped on and the
other is for the grouping order. Select "in descending order." and then
click OK. Then save the report and your report should now be grouped by 
date
in descending order.

________________________________________
Darrell L. Embrey
Information Systems Technologist - Kelly Technical Services
On Assignment at The Dow Chemical Company
Legal Tech & Admin Services
1790 Building
Phone:   xxx-xxx-xxxx
Fax:   xxx-xxx-xxxx
E-mail:  DLEmbrey@d...


-----Original Message-----
From: Vimal Bhuptani [mailto:vimal_bhuptani@r...]
Sent: Tuesday, June 04, 2002 7:30 AM
To: crystal_reports
Subject: [crystal_reports] Sorting in Crystal Reports


Dear Friends,

i have created one report which displays the Date, No, Name, Place
 From adn Place To...
and i want to sort the details with the Date.. and i have grouped
my report.. with the Date.. but i am unable to get it in desending
order.. as i have tried grouping by Year, Month, Day.. etc.. but
stil the report is not setting in order..

is there any specific for Date.. if so pls tell me

waiting for ur reply
Vimal
_________________________________________________________
Click below to visit monsterindia.com and review jobs in India or
Abroad
http://monsterindia.rediff.com/jobs



Message #5 by "Vimal Bhuptani" <vimal_bhuptani@r...> on 5 Jun 2002 12:18:42 -0000
Dear Friends,

i am using Crystal Reports 7.. with Visual Basic 6 and my database 
is Oracle.. 8

i have tried changing the Group to Year, Month, Day, Week etc.. 
with ascending as well as descending.. but its not working...

as dont know wht is the problme..

if any onoe knows.. pls let me know at the earliest..

regards

Vimal

On Tue, 04 Jun 2002 Tung Dang wrote :
>You can always check the SQL statement to see how crystal report 
>is interpreting your query and to see if it's building it 
>correctly.
>
>I usually go to the report menu and select sort records.  There, 
>I can specifically select which field(s) to order by.
>
>Tung Dang
>Database Admin
>Haestad Methods
>www.haestad.com
>
>-----Original Message-----
> From: Embrey, Darrell (DL) [mailto:DLEmbrey@d...]
>Sent: Tuesday, June 04, 2002 9:01 AM
>To: crystal_reports
>Subject: [crystal_reports] RE: Sorting in Crystal Reports
>
>
>Hi Vimal,
>
>What version of Crystal reports are you using? You state you 
>already have
>your report grouped by Date. The default order for grouping is 
>Ascending. To
>change the grouping order to Descending in version 8.x, move your 
>cursor
>over the group header tab in the design mode and right click the 
>mouse.
>Select Change Group... from the list. The Change Group Options 
>modal window
>displays the options for grouping. There are two drop-down lists 
>in the top
>portion of the window. One is the field the report is grouped on 
>and the
>other is for the grouping order. Select "in descending order." 
>and then
>click OK. Then save the report and your report should now be 
>grouped by date
>in descending order.
>
>________________________________________
>Darrell L. Embrey
>Information Systems Technologist - Kelly Technical Services
>On Assignment at The Dow Chemical Company
>Legal Tech & Admin Services
>1790 Building
>Phone:   xxx-xxx-xxxx
>Fax:   xxx-xxx-xxxx
>E-mail:  DLEmbrey@d...
>
>
>-----Original Message-----
> From: Vimal Bhuptani [mailto:vimal_bhuptani@r...]
>Sent: Tuesday, June 04, 2002 7:30 AM
>To: crystal_reports
>Subject: [crystal_reports] Sorting in Crystal Reports
>
>
>Dear Friends,
>
>i have created one report which displays the Date, No, Name, 
>Place
>  From adn Place To...
>and i want to sort the details with the Date.. and i have 
>grouped
>my report.. with the Date.. but i am unable to get it in 
>desending
>order.. as i have tried grouping by Year, Month, Day.. etc.. 
>but
>stil the report is not setting in order..
>
>is there any specific for Date.. if so pls tell me
>
>waiting for ur reply
>Vimal
>_________________________________________________________
>Click below to visit monsterindia.com and review jobs in India 
>or
>Abroad
>http://monsterindia.rediff.com/jobs
>
>
>
>

_________________________________________________________
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs


  Return to Index