End User Sorting

[kcoleman26]

Crystal XI

I keep building reports that sort the same data in different ways. I know there has to be an easier way so the end user can choose how they want the report displayed.



Example: Departures Report - This report the user can select the Group and a Range of Dates to see Departures. I have currently have 4 seperate reports.
1. Grouping by {DepartDate}, {Group}, {Share}
Sorted by {LastName}
2. Grouping by {Group}, {Share}
Sorted by {LastName}
3. No Grouping just sorted by {LastName}
4. Grouping by (DepartDate}
Sorted by {RoomNumber}

Is their anyway to allow the end user to choose the format they want to see the report instead of rebuilding the same report over and over with different sorts.

This is the first of many that will need to use pretty much the same format just different data fields.

Thanks,
KC

 

[Madawc]

You can group using a formula field, provided it only references items from one detail line or 'row'. Using a parameter, you could change the value of this field, e.g.

if @Param = "Name" then {LastName}
else
if @Param = "Room Number" then ToText({RoomNumber}}
...

Note that you'll not be allowed to mix data types. ToText should take care of this.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

In Crystal 2008, you can add sorting "buttons" to the report layout to achieve this without needing a parameter.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

I would create a parameter {?GroupBy} with these four string options:

DepartDate, Group, Share
Group, Share
DepartDate
No Group

Then insert groups in the following order on these formulas:

//{@Date} - Group #1:
if "DepartDate" in {?GroupBy} then {table.departdate}

//{@Group} - Group #2:
if "Group" in {?GroupBy} then {table.group}

//{@Share} -Group #3:
if "Share" in {?GroupBy} then {table.share}

Also create a formula {@Sort} and add it to your record sort area:

if {?GroupBy} = "DepartDate" then
{table.roomno} else
{table.lastname}

Then go into the section expert and select each group header and footer and check "suppress blank section".

-LB

 

[kcoleman26]

Just ordered Crystal 2008

Thanks lbass that got it hopefully it will be easier in Crystal 2008.

kc