Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sorting Parameters Post Reply Post New Topic
Author Message
ridershaun
Newbie
Newbie


Joined: 31 Aug 2010
Online Status: Offline
Posts: 32
Quote ridershaun Replybullet Topic: Sorting Parameters
    Posted: 09 Jan 2015 at 7:52am
I have a user who wants to be able to sort a report three different ways depending on what he is looking for. Does anyone know of any way to include sorting as a option to select when entering your report parameters?

Any insight would be appreciated.

Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2015 at 9:02am

does the report have groups?

That can make the request implausible.
 
I think you are asking for sorting on three different fields, not asc/desc/some 3rd option
 
If so you make a static param
call it "sort by" or whatever
enter your 3 options E.g. (first name, last name, ID number)
create a formula field as
if ?sort by = "first name" then table.firstname else
if ?sort by = "last name" then table.lastname else
if ?sort by = "ID Number" then totext(table.ID,"0000000000")
 
IN your sort details sort by the formula field you just created
IP IP Logged
ridershaun
Newbie
Newbie


Joined: 31 Aug 2010
Online Status: Offline
Posts: 32
Quote ridershaun Replybullet Posted: 09 Jan 2015 at 10:03am
The report has multiple groups and the sort would be by the groups, so it seems like it is not a viable option. He should just dump it into excel once he runs the report and then sort from there.

Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2015 at 10:14am

if the sort is based on a summary value of a group it may be possible.

IP IP Logged
jms493
Newbie
Newbie


Joined: 11 Apr 2012
Location: United States
Online Status: Offline
Posts: 3
Quote jms493 Replybullet Posted: 05 Jul 2016 at 8:40am
Thanks for the Sorting by detail formula. Works great. Thank you!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.