Solved

Crystal Reports - User Input for Sort

Posted on 2013-05-21
6
216 Views
Last Modified: 2013-05-28
Hi there,

I have a request to create two sorts;

One is either ascending or descending by last name and the other is to choose either ascending or descending by amounts called ratings.

When the user runs the report, he/she would like to be asked to choose on of the options, ascending or descending for each.  I have played around with this and have reviewed some other cases but none seem to touch upon this.  

Any advice? Thank you in advance,
CS
0
Comment
Question by:rporter45
  • 3
  • 2
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39185172
Is that to sort on a single field?

Are the fields the same datatype? ie both are text/string?

mlmcc
0
 

Author Comment

by:rporter45
ID: 39185246
Hi there,

There are two fields - the first is a field called sort name - this is a string.

The second option they would like is to sort by rating that is currency.

They would like one or the other but not both at one time.

Thank you -
CS
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 350 total points
ID: 39185342
2 parmaeters and 4 formulas

Parameters
SortFIeld - allow use r to choose the field
SortOrder - Allow user to specify sort direction

Formulas
Name - Sort1
If {?SortOrder" = "A" and {?SortField} = "Rating" then
    {RatingField}
Else
    0

Name Sort2
If {?SortOrder" = "D" and {?SortField} = "Rating" then
    {RatingField}
Else
    0

Name Sort3
If {?SortOrder" = "A" and {?SortField} = "Name" then
    {NameField}
Else
    "A"

Name Sort2
If {?SortOrder" = "D" and {?SortField} = "Name" then
    {RatingField}
Else
    "A"

Add the sort formulas to the report sorting
Set SORTs 2 and 4 to DESCENDING

mlmcc
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:rporter45
ID: 39185487
Thanks! I will try these out and get back to you,

take care,
CS
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 39188263
If you are using a recent version of Crystal, it provides an option to attach sort controls to column headers.  See Crystal online help topic of "Sort controls".
0
 

Author Closing Comment

by:rporter45
ID: 39202325
Worked perfectly!
Thank you -
CS
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now